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 ...
https://www.percona.com/blog/myloader-error-when-restoring-databases/
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 inconsist...
https://www.percona.com/blog/how-missing-primary-keys-break-your-galera-cluster/
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 w...
https://www.percona.com/blog/percona-postgresql-pg_tde-extension-march-update/
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 choic...
https://www.percona.com/blog/enhancing-postgresql-monitoring-with-percona-monitoring-and-management/
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...
https://www.percona.com/blog/using-pam-with-sasl-in-percona-server-for-mongodb/
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 in...
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 EditionsTraditionall...
https://www.percona.com/blog/why-your-next-mysql-database-should-not-be-a-mysql-database/
Indexes in MongoDB play a crucial role in improving the query performance and increasing the overall database efficiency. Without indexes, MongoDB will perform a collection scan, i.e., it will re...
https://www.percona.com/blog/stages-of-index-build-in-mongodb/
Anyone working with databases knows that data is the driving force behind every online activity, and data security is always a top concern. Seeing as how they store and manage vast amounts of sen...
https://www.percona.com/blog/best-practices-for-database-security/
PostgreSQL configuration file parameters are very important when managing a PostgreSQL database, and this blog post will discuss the importance of backing those files up. The following are the pr...
https://www.percona.com/blog/how-can-i-take-a-backup-of-configuration-files-in-postgresql/
Comprehensive knowledge of ITIL (Information Technology Infrastructure Library) processes proves advantageous for Database Administrators (DBAs) as it significantly elevates the efficiency of an ...
https://www.percona.com/blog/boosting-it-productivity-the-crucial-role-of-itil-knowledge-for-dbas/
PostgreSQL has a feature called data checksum which is used to detect any storage-level corruption of data pages. However, a new PostgreSQL database cluster does not have this feature enabled by ...
https://www.percona.com/blog/enable-data-checksums-with-minimum-downtime-in-postgresql/
When checking for how good (or bad) a PostgreSQL instance is behaving, one just wants to see everything that matters on a single-ish page. That’s what the new summary dashboard in Percona Monit...
In a previous blog, One Index, Three Different PostgreSQL Scan Types: Bitmap, Index, and Index Only, we reviewed three ways PostgreSQL can use an index to retrieve data as quickly as possible. In...
https://www.percona.com/blog/leverage-index-only-scans-in-postgresql/
Percona Monitoring and Management (PMM) overview dashboards were always meant to be a starting point for DBAs to check the overall health of the databases. Current overview dashboards can be a li...
Percona XtraBackup (PXB) version 8.0.28 supports taking backups for the encrypted tables in your MySQL database using the AWS Key Management Service. For setting up data-at-rest encryption using ...
Open core is a monetization strategy for open source, where in addition to the open source version, often called “community,” there is an extended version, often called the “enterprise” v...
https://www.percona.com/blog/the-challenge-with-open-core-software/
Before MongoDB 4.4, we had a tool to use to analyze slow queries from the log file called mplotqueries from mtools (thanks, Thomas Rueckstiess, for the tool and the inspiration).Mplotqueries is a...
https://www.percona.com/blog/analyzing-slow-queries-after-mongodb-4-4/
In Using Percona Backup for MongoDB in Replica Set and Sharding Environment: Part One, I demonstrated a basic Percona Backup for MongoDB (PBM) setup under the Replica Set and Sharding environment...
PostgreSQL extensions are great! Simply by adding an extension, one transforms what is an otherwise vanilla general-purpose database management system into one capable of processing data requirem...
https://www.percona.com/blog/managing-time-series-data-using-timescaledb-powered-postgresql/