Percona

OCTOBER 4, 2023

We discussed how roles can inherit permissions from other roles, simplifying access control in your database. As a result, both A and C directly inherit permissions from B and indirectly from D. In simpler language, we can view A and C as indirect descendants of D within the role hierarchy.

C++ 102

C++ Open Source Tuning Database 102

Testlodge

APRIL 14, 2021

A software tester’s work life includes making sure that systems that have been designed to achieve specific results behave exactly as they should. Configuration testing is performed to discover the optimum combinations of software and hardware specifications that allow the system to work without flaws. What is Configuration Testing?

Testing 89

Testing Hardware Virtualization Operating System 89

Testlodge

JULY 19, 2023

SOX compliance testing validates changes made to code and verifies adherence to internal controls. Testers are responsible for testing code changes to ensure accuracy. The overall intention of SOX testing is to protect stakeholders and other investors from corporate fraud. There are four major types of controls.

Testing 81

Testing Energy Programming Government 81

HammerDB

DECEMBER 5, 2020

compared to previous releases is that the workload names have changed from TPC-C and TPC-H to TPROC-C and TPROC-H respectively and therefore a key question is how are the v4.0 The simple answer is nothing, the workloads are exactly the same workloads derived from the TPC-C and TPC-H specifications and HammerDB v4.0

C++ 40

C++ Benchmarking Virtualization Open Source 40

Percona

JUNE 26, 2023

We have faced different levels of corruption related to databases in PostgreSQL. In case of hardware failure, first, we need to fix the hardware issue or migrate our database to new hardware and then perform a restore, as mentioned below. So we need to check whether this base / 16384 / 16391 file is available in / base location.

Hardware 77

Hardware C++ Database Open Source 77

Percona

DECEMBER 7, 2023

Ensuring the security and resilience of your data hinges on having a robust backup strategy, and Percona XtraBackup (PXB), our open source backup solution for all versions of MySQL, is designed to make backups a seamless procedure without disrupting the performance of your server in a production environment. Similarly, Percona XtraBackup 8.0

C++ 95

C++ Open Source Servers Database 95

Percona

APRIL 3, 2023

SET WITHOUT OIDS; A list of tables with the problem is in the file: tables_with_oids.txt Failure, exiting postgres@xx.xx.xx.xx:~$ more tables_with_oids.txt In database: abs_test public.craft public.ports In database: postgres public.oid_test We can use the below SQL to find tables with OID, and it also generates the DDL to remove.

C++ 104

C++ Database Cache Storage 104

Percona

DECEMBER 22, 2022

PostgreSQL manages database access permissions using the concept of roles. A role can be either a database user or a group of database users, depending on how the role is set up. Roles can own the database objects and assign privileges on those objects to other roles to control who has access to which objects.

C++ 76

C++ Database Open Source Monitoring 76

Percona

MAY 2, 2023

That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks.

Best Practices 52

Best Practices Database Storage Servers 52

Dynatrace

MAY 23, 2022

As developers move to microservice-centric designs, components are broken into independent services to be developed, deployed, and maintained separately. Shifting from monolith to microservices makes it easier to test, develop, and release innovative features more rapidly. This is usually a relational database management system.

Architecture 192

Architecture DevOps Monitoring Programming 192

Percona

DECEMBER 26, 2023

This PoC demonstrates how to install and configure pg_stat_monitor in order to extract useful and actionable metrics from a PostgreSQL database and display them on a Grafana dashboard. Grafana database backend: Prometheus version 2.15.2+d About the environment Grafana: version 10.0.0 tps, lat 11.718 ms stddev 3.951 progress: 4440.0

Benchmarking 124

Benchmarking Metrics C++ Database 124

Percona

APRIL 21, 2023

This could result from a mistake (the application wrote to a replica instead of writing to the source) or by design (you need additional tables for reports). Below is my current topology: [root@monitor ~]# orchestrator-client -c topology-tabulated -alias testcluster | tr '|' 't' 192.168.56.10:3306 3306 0s ok 5.7.41-44-log

C++ 86

C++ Monitoring Database Open Source 86

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. It enables the user to measure database performance and make comparative judgements about database hardware and software. Databases are highly sophisticated software, and to design and run a fair benchmark workload is a complex undertaking.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Percona

JUNE 20, 2023

In order to understand “segmentation fault,” it is a must to know the basic idea of segmentation and its implementation in C programming. In order to overcome these issues, the concept of paging and segmentation was introduced, where physical address space and virtual address space were designed.

Programming 85

Programming C++ Database Virtualization 85

Percona

DECEMBER 29, 2023

Not everything can be addressed on the database side. Human factor: In an ideal case, there must be stringent restrictions and enforcement on what load and number of connections can be onboarded to the Database. App-Dev often demands unrestricted, uncontrolled access to the database. However, gatekeeping is not an easy job.

Servers 82

Servers Database C++ Airlines 82

Percona

JUNE 5, 2023

Sooner or later, one must address this issue; otherwise, one can suffer the consequences of handicapping your entire database infrastructure. This SQL statement must be executed against each and every database that is to be accessed by any ROLE connection using PgBouncer. 22 0.0.0.0:* LISTEN tcp 0 0 127.0.0.1:5432

Database 122

Database Open Source Servers C++ 122

Percona

AUGUST 29, 2023

Data redundancy, a database version of a RAID Pondering the case of high availability and redundancy, one replicates data by creating a replica via streaming replication. Extension citus has been created in database db01. Now let’s stretch our imagination and consider a second method of high availability, ala Citus.

C++ 81

C++ Database Storage Testing 81

Percona

AUGUST 16, 2023

In database management, well-formatted SQL code is easier to read and a vital aspect of maintaining clean, efficient, and error-free databases. PostgreSQL developers and database administrators often deal with complex SQL queries, making code readability a critical factor for productivity.

Code 79

Code Best Practices Open Source C++ 79

Dynatrace

JANUARY 31, 2024

In the age of AI, data observability has become foundational and complementary to AI observability, data quality being essential for training and testing AI models. An erroneous change in the database system leads to a subset of the data being categorized incorrectly.

DevOps 192

DevOps Analytics Airlines Metrics 192

Percona

OCTOBER 3, 2023

While THP can be beneficial for many applications, enabling it on a database server could have unintended consequences. In this post, we will explore THP, its impact on database servers, and how to disable it for optimal performance and stability. As such, it is generally recommended to disable THP for most database workloads.

Database 90

Database Servers Open Source C++ 90

Percona

MAY 8, 2023

In simpler terms, logical replication in PostgreSQL is a way to copy data from one database to another in a more flexible and customizable manner compared to physical replication. Instead of copying the entire database, logical replication focuses on replicating changes made to individual rows or transactions.

C++ 102

C++ Servers Database Open Source 102

Percona

DECEMBER 5, 2023

Inspired by David’s insights, I embarked on a journey to explore logical replication from a different perspective – within the realm of on-premises server databases. Also, it is a helpful method for version upgrades since the target database can run on a different (minor or major) PostgreSQL version. to PostgreSQL v15.4.

Database 78

Database Traffic C++ Servers 78

Percona

AUGUST 31, 2018

It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. It is important to pay attention to performance when writing database queries. PostgreSQL’s Tuneable Parameters. shared_buffer.

Tuning 57

Tuning Database Performance Benchmarking 57

Scalegrid

JUNE 18, 2019

servers.mongodirector.com:27017/test?replicaSet=RS-example-0&ssl=true" Our yml file: development: # Configure available database clients. Alternatively, you can define the following: # # Define the name of the default database that Mongoid can connect to. # (required). The user's database roles. user: 'testuser'. #

C++ 100

C++ Servers Database Network 100

Percona

JUNE 28, 2023

In the Postgres database, the application data can be organized in various ways using Postgres schemas. In the Postgres database cluster, whenever we create a new database, It gets created with the default schema called public schema. This blog post will discuss the Public Schema Security upgrade in PostgreSQL 15.

Transportation 74

Transportation Database Open Source C++ 74

Percona

JUNE 7, 2023

Triggers on Data Definition Language (DDL) events are a powerful feature of PostgreSQL that allows you to perform additional actions in response to changes to the database schema. DDL events include operations such as CREATE, ALTER, and DROP statements on tables, indexes, and other database objects.

Database 77

Database Best Practices Open Source C++ 77

HammerDB

FEBRUARY 25, 2021

HammerDB is a load testing and benchmarking application for relational databases. All the databases that HammerDB tests implement a form of MVCC (multi-version concurrency control). On high-performance multi-core systems all the supported databases can return performance in the many millions of transactions per minute.

Programming 67

Programming Benchmarking Virtualization C++ 67

SQL Performance

AUGUST 1, 2022

I’ll be using the sample database TSQLV6 in the examples in this article. You can download this sample database here. SQL Server 2022 introduces a standard feature called the distinct predicate, which is designed to apply comparisons using two-valued logic, treating NULLs like non-NULL values. The Distinct Predicate.

Servers 142

Servers Testing C++ Code 142

Percona

MARCH 28, 2023

Every database system has to ensure durability and reliability. wt list -c WiredTigerCheckpoint.33: In this blog post, we will dive deep into WiredTiger’s Logging and Checkpoint mechanism. MongoDB uses classic Write-Ahead-Logging (WAL) using Journals and Checkpoints. Starting with the basics, why is WAL needed in the first place?

Hardware 90

Hardware C++ Storage Cache 90

HammerDB

JANUARY 5, 2019

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

Benchmarking 40

Benchmarking Database Social Media Scalability 40

Percona

AUGUST 21, 2023

Although the installation of LDAP includes setting the password, which will be admin, by executing the following command, one can reset the password at will: # Select "No" when asked to configure the database with dbconfig-common. # Set the domain name for your LDAP server, for example, "example.com". #

C++ 71

C++ Servers Open Source Testing 71

HammerDB

APRIL 19, 2023

Among the different components of modern software solutions, the database is one of the most critical. There are many times we get asked why some cloud instance performed poorly for their database application and almost always turned out to be some configuration error. TB)) for storage of database tablespaces and logging.

Performance 54

Performance Benchmarking Cache Storage 54

Percona

DECEMBER 19, 2023

Since our previous blog post, Adding Transparent Data Encryption to PostgreSQL with pg_tde: Please Test , it received new features such as TOAST data encryption and HashiCorp Vault support for key storage. This, with some additional information, is what gets stored in the.tde file: hexdump -C /tmp/tdedata/postgresql/data/base/5/16397.tde

Open Source 85

Open Source Storage Database C++ 85

Percona

AUGUST 30, 2023

This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. Database level setting All options discussed so far have a global scope. But there could be reasons why a PostgreSQL user wants to change that at a specific database level.

Database 105

Database Servers Open Source Tuning 105

Percona

FEBRUARY 23, 2023

If you ever had to make a quick ad-hoc backup of your MongoDB databases, but there was not enough disk space on the local disk to do so, this blog post may provide some handy tips to save you from headaches. while not overloading the CPU capacity on the production database. Therefore, applying on-the-fly compression is essential.

AWS 122

AWS Storage Database Open Source 122

Percona

OCTOBER 17, 2023

When multiple operations, such as reads and writes, attempt to access the database concurrently, WiredTiger uses tickets to ensure these operations do not conflict in a way that would compromise data integrity or performance. Bounce the database, replacing the binaries with the older release. Remove backward-incompatible features.

Metrics 104

Metrics C++ Storage Database 104

SQL Performance

JULY 13, 2022

This could also happen if you need to migrate code written for another database platform with a different dialect of SQL to T-SQL. To test the performance of the solutions, you’ll need a larger set of sample data. L0 AS ( SELECT 1 AS c. So you have to come up with a supported alternative.

C++ 112

C++ Code Azure Database 112