by Fernando Mattera | Oct 31, 2023 | Insight for DBAs, MySQL, Percona Services
Hello friends,In Managed Services, we have the opportunity to see different technologies and various topologies, which makes the work fascinating and challenging at the same time.This time, I’m going to tell you about a particular case: a client with a... by Przemysław Malkowski | Jul 5, 2023 | Insight for DBAs, MySQL
Upgrading to MySQL version 8.0 is a hot topic since version 5.7 is approaching the official end of life very soon. MySQL 5.7 EOL is set for the end of October 2023.If you feel unprepared for the upgrade, consider post-EOL support from Percona. But it would be the... by Eduardo Krieg | Jan 19, 2023 | Insight for DBAs, MySQL, Percona Software
16 years ago, our founder Peter Zaitsev covered this topic and some of the points described there are still valid, and we will cover more on this blog. While the technologies have evolved and matured enough, there are still some people thinking that MySQL is only... by Miguel Angel Nieto | Apr 15, 2015 | MySQL
Data inconsistencies in replication environments are a pretty common. There are lots of posts that explain how to fix those using pt-table-checksum and pt-table-sync. Usually we only care about the data but from time to time we receive this question in support: How... by Jaime Sicam | Feb 10, 2014 | MySQL
One of the common tasks requested by our support customers is to optimize slow queries. We normally ask for the table structure(s), the problematic query and sample data to be able to reproduce the problem and resolve it by modifying the query, table structure, or... by David Stokes | Jul 31, 2023 | Database Trends, Insight for DBAs, MySQL
Open source database architects usually do not implement business logic in their databases. This is in stark contrast to many commercial databases where this is a common practice. In the first case, all the heuristics are kept at the application layer, and the... by Tyler Duzan | Mar 18, 2020 | Insight for DBAs, MongoDB, MySQL, Percona Software
Percona has been investing in building and releasing Operators for Kubernetes to run traditional databases in a cloud-native fashion. The first two Kubernetes operators were for Percona Server for MongoDB and Percona XtraDB Cluster, chosen because they both feature... by Peter Zaitsev | Sep 19, 2009 | Insight for DBAs, MySQL
The mistake I commonly see among MySQL users is how indexes are created. Quite commonly people just index individual columns as they are referenced in where clause thinking this is the optimal indexing strategy. For example if I would have something like AGE=18 AND...