Percona's MySQL & InnoDB performance and scalability blog
91k followers 11 articles/week
How Missing Primary Keys Break Your Galera Cluster

Any Galera documentation about limitations will state that tables must have primary keys. They state that DELETEs are unsupported and other DMLs could have unwanted side-effects such as inconsistent ordering: rows can appear in different order on different nodes in your cluster.If you are not actively relying on row orders, this could seem acceptable....

Thu Mar 28, 2024 18:58
Percona’s PostgreSQL pg_tde Extension: March Update

Transparent Data Encryption is one ‘missing item’ in comparing PostgreSQL to commercial databases. Percona’s pg_tde project will correct this shortcoming. Progress is ongoing, and Percona would love your feedback, so please download and test.DocumentationThe pg_tde documentation is here. You will find many options for obtaining pg_tde – Docker images,...

Thu Mar 28, 2024 16:45
Enhancing PostgreSQL Insights with Percona Monitoring and Management: A Closer Look at Recent Updates

Database monitoring tools play a crucial role in ensuring the smooth operation and performance optimization of database systems, and Percona Monitoring and Management (PMM) has been a go-to choice for many organizations seeking robust monitoring solutions for their open source databases. Recently, two significant enhancements have been made to PMM and...

Wed Mar 27, 2024 18:03
Using PAM with SASL in Percona Server for MongoDB

Percona Server for MongoDB currently has several external authentication options, such as LDAP with SASL, LDAP, Kerberos, and AWS IAM. What is amazing is that SASL can authenticate with Pluggable Authentication Modules (PAM) too. This means that you still have additional external authentication options to choose from through PAM libraries.For a quick...

Wed Mar 27, 2024 16:12
Copying Alert Rules From One Percona Monitoring and Management Server to Another

Since Percona Monitoring and Management (PMM) 2.40.0, Grafana uses PostgreSQL instead of SQLite database to store users, dashboards, and other persistent data. This aids in getting some useful information related to [configured alerts] directly via querying from the Postgres backend.Sometimes we need to migrate only alert rules from one PMM server to...

Tue Mar 26, 2024 18:14
Why Your Next MySQL Database Should Not Be a MySQL Database

MySQL is a very popular database and a good choice for new projects. But is it the best choice?Luckily you have several options for this choice.MySQL Community vs. Enterprise EditionsTraditionally, the MySQL Community Edition has been a mainstay in the open source community for decades, and it is available for free. Originally, MariaDB was a […]

Tue Mar 26, 2024 15:10

Build your own newsfeed

Ready to give it a go?
Start a 14-day trial, no credit card required.

Create account