by Arunjith Aravindan | Sep 12, 2023 | Insight for DBAs, MySQL
The auto-increment feature, which generates unique values for primary key columns, is an integral part of the database’s design. With the release of MySQL 8, a notable enhancement was introduced to the auto-increment counter. Compared to MySQL 5.7, this...
by Aleksandra Abramova | Sep 8, 2023 | MySQL, Open Source, Percona Events
Percona University Online has released a new free course, “MySQL 5.7 End of Life Options – Free Course at Percona University Online,” by Dave Stokes, Technical Evangelist at Percona. Dave is the author of MySQL & JSON – A Practical Programming Guide. He...
by David Stokes | Sep 6, 2023 | Insight for DBAs, MySQL
Functional indexes are found in both of Percona’s relational databases, MySQL and PostgreSQL, but they are probably the least used and most understood index type, aside from geospatial. You may also hear this type of index being called Index on expression. So, what is...
by Sveta Smirnova | Sep 1, 2023 | Insight for DBAs, MySQL
This blog was originally published in November 2021 and was updated in September 2023. MySQL server performance can sometimes be perplexing, and if you’ve ever wondered about the role of triggers in influencing your MySQL server’s memory allocation, this...
by Anil Joshi | Aug 25, 2023 | Insight for DBAs, MySQL
by Alina Derkach | Aug 23, 2023 | Insight for DBAs, MySQL, Percona Software
To reduce the backup size, save storage space, and speed up the backup and restore process, you can compress a backup with Percona XtraBackup. The XtraBackup –compress option makes XtraBackup compress all output data, including the transaction log file and...
by Mughees Ahmed | Aug 18, 2023 | Insight for DBAs, MySQL
This blog describes how to configure systemd for multiple instances of MySQL. With package installations of MySQL using YUM or APT, it’s easy to manage MySQL with systemctl, but how will you manage it when you install from the generic binaries? Here, we will configure...
by Rituja Borse | Aug 18, 2023 | Insight for DBAs, MariaDB, MySQL
Note that MariaDB 10.4 is not the latest version and has had new releases since 10.4. The client requirement was to move to MySQL 8.0 on the cloud for specific RDS features. Caution: It is important to verify that you are not using any specific MariaDB features...
by Anil Joshi | Aug 17, 2023 | Insight for DBAs, MySQL
by Dimitri Vanoverbeke | Aug 15, 2023 | Insight for DBAs, MySQL
This blog was originally published in February 2017 and was updated in September 2023. In this blog post, I provide an in-depth introduction to MySQL Replication, answering what it is, how it works, its benefits and challenges, as well as reviewing some of the MySQL...
by Sri Sakthivel | Aug 10, 2023 | Insight for DBAs, MySQL, Security
MySQL 8.0.34 brings us a new password validation parameter. Using this, we can control the minimum number of characters in a password that a user must change before validate_password accepts a new password for the user’s account. In this blog, I offer a few...
by Arunjith Aravindan | Aug 9, 2023 | Insight for DBAs, MySQL
MySQL 8 brought a significant architectural transformation by replacing the traditional MyISAM-based system tables with the Transaction Data Dictionary (TDD), a more efficient and reliable approach. This upgrade has vastly improved the management and storage of...
by Arunjith Aravindan | Aug 8, 2023 | Insight for DBAs, MySQL
The clone plugin was introduced in MySQL 8.0.17 and offers a convenient method for cloning data from either a local or remote MySQL server instance. This cloning process creates a physical snapshot of the data stored in InnoDB, including schemas, tables, tablespaces,...
by Peter Sylvester | Aug 8, 2023 | Insight for DBAs, Monitoring, MySQL
As businesses grow and develop, the requirements that they have for their data platform grow along with it. As such, one of the more common questions I get from my clients is whether or not their system will be able to endure an anticipated load increase. Or worse...
by Arunjith Aravindan | Aug 7, 2023 | Insight for DBAs, MySQL
In InnoDB, the undo log and the redo log are two indispensable components that play a vital role in maintaining data integrity and ensuring transactional consistency. Both logs are crucial in the ACID (Atomicity, Consistency, Isolation, Durability) properties of...
by Manjot Singh | Aug 5, 2023 | Insight for DBAs, MySQL
This blog was originally published in July 2017 and was updated in August 2023. It’s a pretty common question around here, so let’s see what we can do about that. So, What is MySQL Partitioning? Partitioning is a way in which a database (MySQL in this...
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 Corrado Pandiani | Aug 3, 2023 | Insight for Developers, MySQL, Open Source
In this article, I want to discuss a couple of pretty new features in MySQL 8.0 — and an older one. Maybe these are minor features you are not aware of, and maybe not so relevant, to be honest. But it is worth providing a quick overview, showing how they work, and how...
by David Stokes | Aug 2, 2023 | Insight for DBAs, MySQL
The MySQL 5.7 End of Life is now two months away. Those of you who have waited may be wondering which is the best way to upgrade – an In-Place or Logical upgrade. An In-Place upgrade is where the binaries for 5.7 are replaced with the binaries for 8.0, and the...
by Brijesh Chauhan | Aug 2, 2023 | Insight for DBAs, Monitoring, MySQL
Restoring a MySQL database backup is a crucial task that can sometimes be time-consuming, especially for large databases. Monitoring the progress of the restore process is essential to estimate completion time and ensure everything is proceeding smoothly. In this blog...
