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...
by Nickolay Ihalainen | May 24, 2022 | Cloud, MongoDB, Monitoring, MySQL, Percona Software
While it is convenient to view the log of MySQL or MongoDB pods with kubectl logs, sometimes the log is purged when the pod is deleted, which makes searching historical logs a bit difficult. Grafana Loki, an aggregation logging tool from Grafana, can be installed in...
by Lenz Grimmer | May 10, 2022 | MySQL, Open Source, Percona Announcements, Percona Software
As you are probably aware, Red Hat Enterprise Linux 6 (RHEL 6 or EL 6 in short) officially reached “End of Life” (EOL) on 2020-11-30 and is now in the so-called Extended Life Phase, which basically means that Red Hat will no longer provide bug fixes or security fixes....
by Marcelo Altmann | May 9, 2022 | MySQL, Percona Software
Earlier last week, Oracle released their Q2 releases series. Unlike previous releases, backward compatibility has now been broken with previous versions of MySQL. MySQL 8.0.29 extended the support for the online DDL algorithm INSTANT. Prior to 8.0.29 only adding...
by David Ducos | May 9, 2022 | Insight for DBAs, MySQL
The new MyDumper 0.12.3-1 version, which includes many new features and bug fixes, is now available. You can download the code from here. MyDumper is Open Source and maintained by the community, it is not a Percona, MariaDB, or MySQL product. In this new version we...
by David Stokes | Apr 27, 2022 | Insight for DBAs, MySQL
Oracle released MySQL Server 8.0.29 on April 26th and this is a quick review of the release notes. I have put my own comments in italics. So what is in the ’29 release of MySQL Server? Does it come festooned with new, neat features or is it a big bug-fix...
by Marco Tusa | Apr 22, 2022 | Cloud, Insight for DBAs, MySQL, Percona Software
In the last quarter of 2021, AWS released Aurora version 3. This new version aligns Aurora with the latest MySQL 8 version, porting many of the advantages MySQL 8 has over previous versions. While this brings a lot of new interesting features for Aurora, what we are...
by Michael Patrick | Apr 20, 2022 | Insight for DBAs, MySQL, Percona Software
When one is responsible for promoting application development from Dev through the various environments such as QA, UAT, etc., through Production, it is often useful to ensure that configurations in test environments are comparable to the final production...
by Kedar Vaijanapurkar | Apr 19, 2022 | MySQL
As a best practice before dropping a large table in MySQL, pt-archiver can be used to delete all the records in batches. This helps to avoid a situation where your server may get stalled under certain circumstances. I recently read a comment from a user saying “The...
by Sergey Pronin | Apr 18, 2022 | Cloud, MySQL, Open Source, Percona Software
Ingress is a resource that is commonly used to expose HTTP(s) services outside of Kubernetes. To have ingress support, you will need an Ingress Controller, which in a nutshell is a proxy. SREs and DevOps love ingress as it provides developers with a self-service to...
by Edwin Wang | Apr 15, 2022 | Insight for DBAs, MySQL
Abstract: By diving into the details of our case study, we will explain how incorrect table statistics may lead the optimizer to choose a suboptimal execution plan. We will also go into how MySQL calculates the table statistics and the ways to correct the table...
by Marco Tusa | Apr 12, 2022 | Cloud, MySQL, Percona Software
Last month I performed a review of the Percona Operator for MySQL Server which is still Alpha. That operator is based on Percona Server for MySQL and uses standard asynchronous replication, with the option to activate semi-synchronous replication to gain higher...
by Sveta Smirnova | Apr 6, 2022 | Insight for DBAs, MySQL, Security
For my previous blog post on the topic, I received plenty of questions about why I did not cover the caching_sha2_password plugin. This plugin is the default since MySQL 8, and all user accounts which are created without the option IDENTIFIED WITH, will use this...
by Przemysław Malkowski | Apr 5, 2022 | Insight for DBAs, Insight for Developers, MySQL
Do you wonder if MySQL tells you the truth about writes to tables that have foreign key constraints? The situation is complex, and getting visibility on what is really happening can be a problem. I found this issue intriguing and decided to share and highlight some...
by David Stokes | Mar 30, 2022 | Insight for DBAs, Insight for Developers, MySQL
MySQL Shell For VS Code integrates the MySQL Shell directly into VS Code development workflows and was released last week. This extension to the popular VS Code platform enables interactive editing and execution of SQL for MySQL Databases and optionally the MySQL...
by Sveta Smirnova | Mar 29, 2022 | Insight for DBAs, Insight for Developers, MySQL
The utf8mb4 character set is the new default as of MySQL 8.0, and this change neither affects existing data nor forces any upgrades. Migration to utf8mb4 has many advantages including: It can store more symbols, including emojis It has new collations for Asian...
by Yves Trudeau | Mar 24, 2022 | Insight for DBAs, MySQL
For a very long part of its history, MySQL replication has been limited in terms of performance. Because there was no way of knowing if transactions or updates were independent, the updates had to be executed on a replica following the exact same sequence of...
by Brian Sumpter | Mar 23, 2022 | Insight for DBAs, MySQL, Security
As part of my ongoing series around MySQL 8 user administration, I’d like to cover one of the new features introduced in MySQL 8.0.27 – multi-factor authentication. In order to establish identity, multi-factor authentication (MFA) is the use of multiple...
by Brian Sumpter | Mar 22, 2022 | Insight for DBAs, MySQL, Security
In keeping with my MySQL 8 user administration and security theme, I’d like to discuss the password verification-required policy introduced in MySQL 8.0.13. With this feature, it is possible to require that attempts to change an account password be verified by...
by Sveta Smirnova | Mar 22, 2022 | Insight for DBAs, MySQL
When MySQL client connects to the server it uses one of the authentication plugins. On the server-side, plugins are located in the directory, specified by the option plugin-dir that defaults to BASEDIR/lib/plugin where BASEDIR is the base directory of your MySQL...
