Percona

DECEMBER 20, 2023

Please check out the Why Linux HugePages are Super Important for Database Servers: A Case with PostgreSQL blog post for more information. Kubectl helps to check the amount of huge pages available. OS maintains a huge list of allocated and free pages to make slow but reliable address translation from virtual to physical.

C++ 95

C++ Virtualization Benchmarking Database 95

Percona

DECEMBER 27, 2022

Encrypting data at rest in a database management system (DBMS) refers to securing data by encrypting it when it is not being used or accessed. TDE can be applied at various levels, such as at the database, column, or cell level, depending on the organization’s specific security needs. Database-level encryption.

Database 93

Database Storage Servers Strategy 93

Percona

MARCH 20, 2023

In short, each cluster is, in reality, a single database with high availability and other functionalities built in. MySQL router, after the 2048 connection, could not serve anything more. ProxySQL was penalized by the limited resources, but this was the game, we had to get the most out of the few available.

Games 118

Games Latency Traffic Cache 118

Percona

AUGUST 29, 2018

For optimum performance, a PostgreSQL database depends on the operating system parameters being defined correctly. Poorly configured OS kernel parameters can cause degradation in database server performance. Therefore, it is imperative that these parameters are configured according to the database server and its workload.

Tuning 54

Tuning Database Servers Processing 54

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. Now let’s stretch our imagination and consider a second method of high availability, ala Citus. Extension citus has been created in database db01.

C++ 77

C++ Database Storage Testing 77

Percona

DECEMBER 5, 2022

ProxySQL is a very useful tool for gaining high availability, load balancing, query routing, query caching, query rewriting, multiplexing, and data masking. Proxysql has a stats database which we can see with an admin login. This database contains metrics gathered by ProxySQL concerning its internal functioning. Explanation.

Servers 58

Servers Cache C++ Metrics 58

SQL Server According to Bob

JANUARY 11, 2020

KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? SQL Server 2005 introduces the snapshot database feature for point-in-time databases ​​ and online DBCC operations.

Servers 40

Servers Cache Database Media 40