by Francisco Bordenave | Sep 30, 2020 | Insight for DBAs, MySQL, Storage Engine
In this post, we will discuss what to do when you add more memory to your instance. Adding memory to a server where MySQL is running is common practice when scaling resources. First, Some Context Scaling resources is just adding more resources to your environment, and...
by Taras Onishchuk | Sep 25, 2020 | Insight for DBAs, MySQL, Percona Software
We all like when error messages are descriptive and give a clear idea about what is happening; however, there are some cases when a few possible reasons lay behind one error message. “MySQL server has gone away” is one of them. Most of the cases when the...
by Jake Davis | Sep 15, 2020 | Insight for DBAs, MySQL
If you are using XA transactions, then you’ve likely run into a few replication issues with the 2PCs (2 Phase Commits). Here is a common error we see in Percona’s Managed Services and a few ways to handle it, including injecting an empty XA transaction. Shell...
by Daniil Bazhenov | Sep 14, 2020 | MySQL, Percona Services, Percona Software
MySQL 8.0 General Availability release was launched in April 2018, and since then there have been ten versions of MySQL 8 and Percona Server for MySQL released. The MySQL Community expressed a high opinion of the MySQL 8.0 advantages, so a lot of databases have been...
by Daniel Guzmán Burgos | Sep 11, 2020 | Cloud, Insight for DBAs, MySQL
In a previous blog post on Data Consistency for RDS for MySQL, we presented a workaround to manage run pt-table-checksum on RDS instances. However, if your instance is running a MySQL 8.0.X version, there’s a simpler way to check data consistency. Starting with 8.0.1,...
by Peter Zaitsev | Sep 11, 2020 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
One of the questions you often will be faced with operating a Linux-based system is managing memory budget. If a program uses more memory than available you may get swapping to happen, oftentimes with a terrible performance impact, or have Out of Memory (OOM) Killer...
by Daniel Guzmán Burgos | Sep 8, 2020 | Cloud, Insight for DBAs, MySQL
MySQL for RDS and DBaaS, in general, are very controlled environments by the vendors, meaning that there are missing things like a SUPER grant for the root user (and any user in general). This has some implications on operations, one of them being the impossibility of...
by David Ducos | Aug 28, 2020 | Insight for DBAs, MySQL, Open Source, ProxySQL
We sometimes receive challenging requests… this is a story about one of those times. The customer has implemented a sharding solution and would like us to review alternatives or improvements. We analyzed the possibility of using ProxySQL as it looked to be a...
by Peter Zaitsev | Aug 28, 2020 | Insight for DBAs, MySQL, ProxySQL
ProxySQL brings a lot of value to your MySQL infrastructures such as Caching or Connection Multiplexing but it does not come free — your database needs to go through additional processing traffic which adds some overhead. In this blog post, we’re going to discuss...
by Sri Sakthivel | Aug 27, 2020 | Insight for DBAs, MySQL, Percona Software
by Ivan Groenewold | Aug 26, 2020 | Cloud, Insight for DBAs, MySQL
Oftentimes, we need to replicate between Amazon Aurora and an external MySQL server. The idea is to start by taking a point-in-time copy of the dataset. Next, we can configure MySQL replication to roll it forward and keep the data up-to-date. This process is...
by Ivan Groenewold | Aug 20, 2020 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Have you ever had to provision a large number of instances from a single backup? The most common use case is having to move to new hardware, but there are other scenarios as well. This kind of procedure can involve multiple backup/restore operations which can easily...
by Kathy Williamson | Aug 18, 2020 | MySQL, Percona Software
We are excited to let you know about two upcoming changes to Percona XtraBackup which will align Percona XtraBackup Versions with Percona Server for MySQL. These changes are to bring Percona XtraBackup release naming line with Percona Server and MySQL and ensure...
by Vadim Tkachenko | Aug 14, 2020 | Benchmarks, MariaDB, MySQL
MariaDB no longer meeting your needs? Migrate to Percona software for MySQL – an open source,production-ready, and enterprise-grade MySQL alternative. Learn More Recently, I published a series of posts on MySQL and MariaDB, where MariaDB 10.5.4 does not...
by Vadim Tkachenko | Aug 14, 2020 | Benchmarks, Insight for DBAs, Insight for Developers, MySQL
Part one of this series can be found here: How Many innodb_buffer_pool_instances Do You Need in MySQL 8? Following up on my recent benchmark posts on MySQL and MariaDB, MySQL and MariaDB on Enterprise SSD Storage and How MySQL and MariaDB Perform on NVMe Storage, I...
by Vadim Tkachenko | Aug 13, 2020 | Benchmarks, Insight for DBAs, Insight for Developers, MySQL
Following up on my recent benchmark posts on MySQL and MariaDB, MySQL and MariaDB on Enterprise SSD Storage and How MySQL and MariaDB Perform on NVMe Storage, I wanted to dig a little deeper and understand how different MySQL parameters affect performance. One of the...
by Carlos Tutte | Aug 12, 2020 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Disclaimer: the following script only works for Percona Server for MySQL 5.7, and relies on enabling performance schema (PS) instrumentation which can add overhead on high concurrent systems, and is not intended for continuous production usage as it’s a POC (proof of...
by Tomislav Plavcic | Aug 11, 2020 | Cloud, MySQL, Percona Software
In Percona Operator for MySQL based on Percona XtraDB Cluster versions prior to 1.5.0, there were two methods for upgrading PXC clusters, and both of these use built-in StatefulSet update strategies. The first one is manual (OnDelete update strategy) and the second...
by Sri Sakthivel | Aug 7, 2020 | Insight for DBAs, Insight for Developers, MySQL
Rewriting a MySQL query for performance is an important process that every DBA should be aware of so they can fix the wrong queries on runtime without code changes on the application end. ProxySQL has great support for rewriting the queries, which Alkin Tezuysal...
by Marcelo Altmann | Aug 6, 2020 | Insight for DBAs, Insight for Developers, MySQL
At the Percona engineering team, we often receive requests to analyze changes in MySQL/Percona Server for MySQL behavior from one version to another, either due to regression or a bug fix (when having to point out to a customer that commit X has fixed their issue and...
