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 Mike Benshoof | Mar 24, 2022 | Insight for DBAs, MySQL, PostgreSQL
DBAs can be set in their ways. Oftentimes, we start with a particular flavor and from that moment until the end of time, it will always be “the best”. In some cases, the debate is actually based on matching the use case to the proper tech (I’m looking at you SQL vs...
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...
by David Stokes | Mar 16, 2022 | Insight for DBAs, Insight for Developers, MySQL
Oracle released MySQL 8.0.28 on January 18th with little fanfare, as part of their four times a year release cycle. So what is included in the new release? Over the past few years, there have been some cool new features included in these ‘dot’ releases that some in...
by Manish Chawla | Mar 10, 2022 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
KMIP (Key Management Interoperability Protocol) is an open standard developed by OASIS (Organization for Advancement of Structured Information Standards) for the encryption of stored data and cryptographic key management. Percona Server for MySQL 8.0.27 and Percona...
by Vinicius Grippa | Feb 28, 2022 | Insight for DBAs, MySQL, Percona Software
A little bit ago, I released a blog post comparing the backup performance of different MySQL tools such as mysqldump, the MySQL Shell feature called Instance Dump, mysqlpump, mydumper, and Percona XtraBackup. You can find the first analysis here: Backup Performance...
by Nik Krichko | Feb 16, 2022 | Cloud, Insight for DBAs, Insight for Developers, MySQL
It is always hard to select a CPU for your own purpose. You could waste hours reviewing different benchmarks, reviews, and bloggers, and in the end, we would limit all our requirements to performance and price. For performance measuring we already have some specific...
by Rahul malik | Feb 11, 2022 | Insight for DBAs, MySQL, Percona Software
Incremental backups of MySQL, specifically for the InnoDB engine, are taken by copying modified pages from the previous backup. The brute force method takes backups by scanning every page in tablespace file in the server data directory is an expensive operation. The...
by Arunjith Aravindan | Feb 9, 2022 | Insight for DBAs, MySQL, Percona Software
It is essential to upgrade MySQL to the most recent version. Do you believe it’s tough to test and upgrade to a newer version? For a variety of reasons, including new features, performance advantages, bug corrections, and so on, databases with obsolete versions are...
by Rahul malik | Feb 8, 2022 | MySQL, Percona Software
Percona XtraBackup delivers the xbcloud binary – an auxiliary tool to allow users to upload backups to different cloud providers directly. Today we are glad to announce the support of the Azure Blob storage to xbcloud. This new feature will allow you to...
by Przemysław Malkowski | Feb 3, 2022 | Insight for DBAs, MySQL, Percona Software
Percona XtraDB Cluster (PXC) offers a great deal of flexibility when it comes to the state transfer (SST) options (used when a new node is automatically provisioned with data). For many environments, on-the-fly compression capability gives great benefits of saving...
by Sergey Pronin | Jan 27, 2022 | Cloud, MySQL, Open Source, Percona Software
Operators are a software framework that extends Kubernetes API and enables application deployment and management through the control plane. For such complex technologies as databases, Operators play a crucial role by automating deployment and day-to-day operations. At...
