Percona's MySQL & InnoDB performance and scalability blog
91k followers 12 articles/semaine
A MyLoader Error You Might Face When Restoring Databases

At Percona Managed Services, we manage Percona for MySQL, MySQL Community, MariaDB, and other software. Sometimes we might need to use mydumper/myloader to restore one or more databases from the production environment to the lower environment for testing. The automated restore process ran well until one day, we got the error below.0. The error we face...

Fri Mar 29, 2024 15:02
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

Construisez votre propre fil d'actualité

Prêt à tenter le coup ?
Commencer un essai de 14 jours, aucune carte de crédit n'est requise.

Créer un compte