by Marco Tusa | Jan 11, 2024 | Benchmarks, MySQL, Percona Software, ProxySQL
In my previous article, Comparisons of Proxies for MySQL, I showed how MySQL Router was the lesser performing Proxy in the comparison. From that time to now, we had several MySQL releases and, of course, also some new MySQL Router ones. Most importantly, we also had...
by Totel | Dec 8, 2023 | Insight for DBAs, MySQL, Percona Software
In this article, we will demonstrate how to achieve asynchronous replication automatic source failover when our replica is a Percona Server for MySQL (PS) and the source is a Percona XtraDB Cluster (PXC) cluster, using virtual IP (VIP) managed by Keepalived. Let us...
by Przemysław Malkowski | Nov 1, 2023 | Insight for DBAs, MariaDB, MySQL, Percona Software
Sometimes, there is a need to update the table and index statistics manually using the ANALYZE TABLE command. Without going further into the reasons for such a need, I wanted to refresh this subject in terms of overhead related to running the command on production...
by Peter Zaitsev | Aug 4, 2023 | Database Trends, MariaDB, MySQL, Percona Software
In this blog post, we will look at the lifecycle and release management for MySQL and MariaDB servers — where we are now and relevant historical background. It is worth noting both MySQL and MariaDB have Community and Enterprise versions. For MySQL, both releases...
by Bartek Gatz | Jul 27, 2023 | Insight for DBAs, MySQL, Percona Software
On July 18th, Oracle released its first pair of MySQL LTS and Innovation releases. (For more, check out A Quick Peek at MySQL 8.0.34 and MySQL 8.1.0.) These releases were announced several months ago and gradually detailed closer to the release date. Today, we know...
by Larry Xia | Jun 15, 2023 | Insight for DBAs, MySQL, Percona Software
Sometimes we might need to install/upgrade Percona Server for MySQL/MySQL 8 to a particular version in a test or production environment. The reason might be application requirements, compatibility issues, or MySQL bug fixes, or we want the same MySQL version to be...
by Colin Charles | Jun 4, 2023 | Insight for DBAs, MariaDB, MySQL
This blog post was originally published in November 2017 and was updated in June 2023. In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL). Introduction: MariaDB vs. MySQL The goal of this blog post is to...
by Fernando Mattera | Jun 1, 2023 | Insight for DBAs, MariaDB, MySQL, Percona Software
Hello friends, on certain occasions, some clients, for whatever reason, ask us to migrate a supposedly “equivalent” brand of an engine in terms of belonging to the MySQL family or ecosystem. In this case, we will be analyzing the migration of MariaDB to...
by Marco Tusa | May 15, 2023 | Cloud, Insight for DBAs, MySQL, Percona Software
Historically MySQL is great in horizontal READ scale. The scaling, in that case, is offered by the different number of Replica nodes, no matter if using standard asynchronous replication or synchronous replication. However, those solutions do not offer the same level...
by Zsolt Parragi | Dec 8, 2022 | MySQL, Percona Software
Percona Server for MySQL 8.0.30-22 introduces a new authentication plugin, named authentication_fido. With this new plugin, it is possible to perform multi-factor authentication using hardware keys, or single-factor passwordless authentication with the same keys. This...
by Zsolt Parragi | Dec 6, 2022 | Insight for DBAs, MySQL, Percona Software
Percona Server for MySQL 8.0.30-22 introduces several improvements for the LDAP plugin: SASL support, support for fallback servers, and support for LDAP-based authorization. All improvements are in technical preview. A description of the existing plugin features and...
by Anil Joshi | Nov 25, 2022 | Cloud, Insight for DBAs, MySQL
In this blog post, I will try to cover a few dump and data-loading utilities offered by MySQL Shell. What is MySQL Shell? It is a robust client and code editor for MySQL. In addition to having APIs for dealing with MySQL, MySQL Shell offers scripting capabilities for...
by Pep Pla | Nov 3, 2022 | Hardware and Storage, Insight for DBAs, MySQL, Open Source
Raspberry PI is a small single-board computer (SBCs) developed by the Raspberry Pi Foundation in association with Broadcom. This tiny computer is extremely popular and widely used in many areas. Thanks to its size, low cost, and low energy requirements, it can be used...
by Yura Sorokin | Aug 10, 2022 | Insight for DBAs, MySQL, Percona Software, Storage Engine
In Percona Server for MySQL 8.0.29-21, we added one more patch that helps us to build server code on macOS. To be precise here, we still could do this even before this patch but only partially. Now it is possible to build RocksDB Storage Engine as well. A word of...
by Sergey Pronin | Jul 11, 2022 | Cloud, MySQL, Open Source, Percona Software
There are two Operators at Percona to deploy MySQL on Kubernetes: one is based on Percona XtraDB Cluster (PXC), production-ready and widely adopted another is based on Percona Server for MySQL, now in tech preview and not recommended for production yet We wrote a blog...
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 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 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 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 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...
