by Mauricio Cacho | Sep 20, 2023 | Insight for DBAs, MySQL, Percona Software
If you’re a DBA, one of your “easiest” tasks is to stop/start MySQL during a maintenance window, but even that could lead to unwanted scenarios if you modify some dynamic parameters at some point in your instance. Here’s a brief story of how this could happen, to make...
by Larry Xia | Sep 15, 2023 | Insight for DBAs, MariaDB, MySQL
At Percona Managed Services, we manage Percona Server for MySQL, Community MySQL, and MariaDB. There are slight differences when configuring and managing MariaDB GTID replication. In this blog, we’ll show you how to convert MariaDB binary log file and position-based...
by Sri Sakthivel | Sep 14, 2023 | Insight for DBAs, MySQL
MySQL is an outstanding open source transactional database used by most web-based applications and is very good at handling OLTP workloads. However, modern business is very much dependent on analytical data. ClickHouse is a columnar database that handles analytical...
by Michael Villegas | Sep 12, 2023 | Insight for DBAs, MySQL
Schema changes are required to add new features or to fix bugs in an application. However, there is no standard procedure to make the changes in a quick and safe manner. If the changes are not made considering the necessary precautions, you may face unwanted outages...
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...