by Chetan Shivashankar | Jul 25, 2022 | Cloud, MySQL, Percona Software
Introduction/FAQ Question: I need to run a production-grade open source MySQL DB. Answer: Percona to the rescue! Percona XtraDB Cluster (PXC) is an open source enterprise MySQL solution that helps you to ensure data availability for your applications while improving...
by Fernando Laudares Camargos | Jul 21, 2022 | Insight for DBAs, MySQL, Percona Software
When we run a SELECT in a replica server and it returns a different result to the one we would have obtained had we queried the source server instead, due to changes in the dataset that have not yet been replicated or synchronized to the replica, we get what is known...
by Sveta Smirnova | Jul 21, 2022 | Insight for DBAs, MySQL
In this blog, I explain how to recover from a replication failure caused by a corrupted relay log file. MySQL replica stores data received from its source binary log in the relay log file. This file could be corrupted due to various reasons, mostly hardware failures....
by Marcelo Altmann | Jul 19, 2022 | Insight for DBAs, MySQL, Percona Software
Oracle’s MySQL 8.0.29 release extended the support for ALTER TABLE … ALGORITHM=INSTANT to 1) allow users to instantly add columns in any position of the table, and 2) instantly drop columns. As part of this work, the InnoDB redo log format has changed for all DML...
by David Stokes | Jul 18, 2022 | Insight for DBAs, MySQL, PostgreSQL
Experienced MySQL DBAs exploring PostgreSQL are often shocked to learn that they will need to vacuum their tables. This is not using a Hoover brand-like device or letting a Roomba-like robot loose on the server. Vacuuming is a necessary part of maintenance on a...
by David Stokes | Jul 15, 2022 | Insight for DBAs, MySQL, PostgreSQL
The differences between MySQL and PostgreSQL are often trivial but occasionally there are stark differences. A MySQL DBA wanting to optimize a query on a PostgreSQL server will hopefully have some experience with using EXPLAIN. For the uninitiated, the keyword...
by Peter Zaitsev | Jul 14, 2022 | Cloud, Insight for DBAs, MySQL, Percona Software
In this blog post, I will show how to install the MySQL-compatible Percona XtraDB Cluster (PXC) Operator on Minikube as well as perform some basic actions. I am by no means a Kubernetes expert and this blog post is the result of my explorations preparing for a local...
by Sveta Smirnova | Jul 13, 2022 | Monitoring, MySQL, Percona Software
In this blog, I will demonstrate how to use Percona Monitoring and Management (PMM) to find out the reason why the MySQL server is stalling. I will use only one typical situation for the MySQL server stall in this example, but the same dashboards, graphs, and...
by Yves Trudeau | Jul 13, 2022 | Insight for DBAs, MySQL
As a principal architect at Percona, one of my duties is to tune MySQL database servers for our customers. The tuning effort looks at every aspect of the database service like the operating system, the MySQL configuration, the schema, the queries, etc. We have...
by Fernando Mattera | Jul 8, 2022 | Insight for DBAs, MySQL, Percona Software
Hello folks, we all know the benefits of table compression in MySQL, with current technology, processing speed, and compression disks, and in most cases, it is a benefit. Now, what happens when that doesn’t happen? In this simple blog, I’m going to show...
by Natalia Marukovich | Jul 6, 2022 | Cloud, MongoDB, MySQL, Percona Software, PostgreSQL
There are several ways to manage storage in Percona Kubernetes Operators: Persistent Volume (PV), hostPath, ephemeral storage, etc. Using PVs, which are provisioned by the Operator through Storage Classes and Persistent Volume Claims, is the most popular choice for...
by Zsolt Parragi | Jul 6, 2022 | Cloud, MySQL, Percona Software
Percona Server for MySQL 8.0.28-20 introduces a new keyring component, component_keyring_kms, which allows using the AWS Key Management Service as a keyring. The component is also included in Percona XtraBackup 8.0.28, allowing backing up databases encrypted with this...
by Zsolt Parragi | Jul 5, 2022 | Insight for DBAs, MySQL, Percona Software
The MySQL error log is usually used to store and later analyze error and warning messages, but in some cases, it is also used for high throughput debug messages for analyzing complex issues. These messages take up more space, slow down the server, and also make the...
by David Stokes | Jun 30, 2022 | Insight for DBAs, MySQL, PostgreSQL
Many MySQL DBAs have expressed interest in learning about PostgreSQL and this series is a guided tour through the basics. One of the ‘Wow! That is Different!’ things for MySQL DBAs looking at PostgreSQL are sequences. Sequences can be used as a rough...
by David Stokes | Jun 21, 2022 | Insight for DBAs, MySQL, PostgreSQL
The videos for PostgreSQL for MySQL Database Administrators (DBA) episodes three and four are live here and here. Episode three covers a simple backup and restoration while episode four covers some handy PSL commands. For those of you who missed the first two videos...
by David Ducos | Jun 3, 2022 | Insight for DBAs, MySQL
As you might know, mysqldump is single-threaded and STDOUT is its default output. As MyDumper is multithreaded, it has to write on different files. Since version 0.11.3 was released in Nov 2021, we have the possibility to stream our backup in MyDumper. We thought for...
by IP | Jun 1, 2022 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Temporary Tables handling in MySQL has a somewhat checkered past. Some time ago, my colleague Przemek wrote a post about differences in the implementations between versions of MySQL. If you are looking for the differences in implementation, that’s a perfect...
by Przemysław Malkowski | May 26, 2022 | Insight for DBAs, MySQL
The binary logging format in MySQL has been ROW by default since MySQL 5.7, yet there are still many users sticking with STATEMENT or MIXED formats for various reasons. In some cases, there is just simple hesitation from changing something that has worked for years on...
by David Stokes | May 26, 2022 | Insight for DBAs, MySQL, Open Source
Last week at Percona Live, I was asked what book I recommend for novices seeking to learn MySQL. For a long time, there has not been a good choice for modern versions of MySQL. Luckily I had just stumbled upon such a book. Now I am happy to recommend The MySQL...
by Zsolt Parragi | May 25, 2022 | Insight for DBAs, MySQL, Percona Software, Security
MySQL allows changing the location of the general log and the slow query log while the server is running by anybody having the SYSTEM_VARIABLES_ADMIN privilege to any location, including appending to existing files. In Percona Server for MySQL 8.0.28-19 we introduced...
