by Mike Benshoof | Apr 3, 2024 | Insight for DBAs, Monitoring, MySQL, Percona Software
This blog was originally published in June 2020 and was updated in April 2024.One of the most common support tickets we get at Percona is the infamous “database is running slower” ticket. While this can be caused by a multitude of factors, it is more... by David Stokes | Apr 2, 2024 | Insight for DBAs, PostgreSQL
Many years ago, when I was the Certification Manager for MySQL AB, I would be in contact with hiring managers looking for talent. One frustrated individual informed me that while it was hard to find a qualified MySQL DBA, it was impossible to find a qualified... by Arunjith Aravindan | Apr 2, 2024 | Insight for DBAs, MySQL, Percona Software
This blog was originally published in January 2023 and was updated in April 2024.MySQL index is a data structure used to optimize the performance of database queries at the expense of additional writes and storage space to keep the index data structure up to date. It... by Pablo Svampa | Apr 2, 2024 | Insight for DBAs, PostgreSQL
One of the most frequent concerns we see in the Percona support team is: Why is my pg_wal growing? / pg_wal is filling up the filesystem / pg_wal does not release the space, and so on.In PostgreSQL, the pg_wal directory plays a crucial role in managing the Write-Ahead... by Ankit Kapoor | Apr 2, 2024 | Insight for DBAs, Monitoring, MySQL, Percona Software
This blog was originally published in January 2023 and was updated in April 2024.Recently I was working with a customer wherein our focus was to carry out a performance audit of their multiple MySQL database nodes. We started looking into the stats of the performance... by Kedar Vaijanapurkar | Apr 2, 2024 | Insight for DBAs, Monitoring, MySQL, Percona Software
This blog was originally published in June of 2023 and updated in April of 2024.As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. A monitoring tool like Percona Monitoring... by Brian Sumpter | Apr 1, 2024 | Insight for DBAs, MySQL
This blog was published in April of 2021 and updated in April of 2024.In past versions of MySQL, there was often an ‘upgrade dance’ that had to be performed in starting up a newly upgraded MySQL instance with the previous version configuration file. In... by Jobin Augustine | Apr 1, 2024 | Insight for DBAs, Insight for Developers, PostgreSQL
This blog was originally published in April 2023 and was updated in April 2024.Indexes are generally considered to be the panacea when it comes to SQL performance tuning, and PostgreSQL supports different types of indexes catering to different use cases. I keep seeing... by Neha Korukula | Apr 1, 2024 | Insight for DBAs, PostgreSQL
This blog was originally published in July 2023 and was updated in April 2024.Partitioning is the concept of splitting large tables logically into smaller pieces for better performance of the database. In this article, we’ll discuss how to effectively use... by Kai Wagner | Apr 1, 2024 | Percona Software, PostgreSQL
This blog was published in April of 2023 and updated in April 2024.PostgreSQL is a popular open source relational database management system many organizations use to store and manage their data. One of the key benefits of using PostgreSQL is its reliability,... by Jobin Augustine | Apr 1, 2024 | Insight for DBAs, PostgreSQL
This blog was originally published in June 2022 and was updated in April 2024.PostgreSQL’s built-in autovacuum – the housekeeper – is improving, version after version. It is becoming more capable while reducing its overhead and addressing edge cases.... by Mike Grayson | Apr 1, 2024 | Insight for DBAs, Insight for Developers, MongoDB
by Larry Xia | Mar 29, 2024 | Insight for DBAs, MySQL
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... by Yoann La Cancellera | Mar 28, 2024 | Insight for DBAs, Insight for Developers, MySQL
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... by David Stokes | Mar 28, 2024 | Open Source, Percona Software, PostgreSQL
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.... by Kai Wagner | Mar 27, 2024 | Monitoring, Percona Software, PostgreSQL
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... by Jaime Sicam | Mar 27, 2024 | Insight for DBAs, MongoDB, Percona Software, Security
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... by Anil Joshi | Mar 26, 2024 | Cloud, Insight for DBAs, Monitoring, Percona Software
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... by David Stokes | Mar 26, 2024 | MySQL, Open Source, Percona Software
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 Editions Traditionally, the MySQL Community Edition has been a mainstay in the open source... by David Quilty | Mar 25, 2024 | Insight for DBAs, Percona Services, Security
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 sensitive and valuable data, ranging from financial records to personal...