Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
September 26, 2023
The MySQL Clone Plugin Is Not Your Backup
This blog post discusses the limitations of the MySQL Clone plugin. The MySQL clone plugin significantly simplifies the process of [...]
September 26, 2023
Explore the New Feature of MySQL To Restrict Users From Creating a Table Without a Primary Key
As MySQL database administrators, we are well aware of the significance of implementing a primary key within a table. Throughout [...]
September 25, 2023
Restrict MySQL Connections to Broken Replica in ProxySQL
ProxySQL is a high-performance SQL proxy, which runs as a daemon watched by a monitoring process. The process monitors the [...]
September 20, 2023
How to Read Simplified SHOW REPLICA STATUS Output
As a MySQL database administrator, you’re likely familiar with the SHOW REPLICA STATUS command. It is an important command for [...]
September 20, 2023
Avoid Surprises When Restarting MySQL — Ensure Dynamic Changes Won’t Be Lost
If you’re a DBA, one of your “easiest” tasks is to stop/start MySQL during a maintenance window, but even that [...]
September 15, 2023
Convert MariaDB Binary Log File and Position-Based Replication to GTID Replication
At Percona Managed Services, we manage Percona Server for MySQL, Community MySQL, and MariaDB. There are slight differences when configuring [...]
September 14, 2023
Complete Walkthrough: MySQL to ClickHouse Replication Using MaterializedMySQL Engine
MySQL is an outstanding open source transactional database used by most web-based applications and is very good at handling OLTP [...]
September 12, 2023
How To Make Schema Changes and Not Die Trying
Schema changes are required to add new features or to fix bugs in an application. However, there is no standard [...]
September 12, 2023
Auto-Increment Counter Persistence in MySQL 8: Comparing the Evolution From MySQL 5.7
The auto-increment feature, which generates unique values for primary key columns, is an integral part of the database’s design. With [...]
September 8, 2023
MySQL 5.7 End of Life Options – Free Course at Percona University Online
Percona University Online has released a new free course, “MySQL 5.7 End of Life Options – Free Course at Percona [...]
September 6, 2023
Putting the Fun in MySQL Functional Indexes
Functional indexes are found in both of Percona’s relational databases, MySQL and PostgreSQL, but they are probably the least used [...]
September 1, 2023
PostgreSQL for MySQL DBAs Episode 13: Inheritance
MySQL users can easily be confused by the seemingly infinite differences between MySQL and PostgreSQL. The good news is that [...]
September 1, 2023
Understanding How MySQL Collation and Charset Settings Impact Performance
This blog was originally published in February 2019 and was updated in September 2023. Web applications rely on databases to [...]
September 1, 2023
Understanding MySQL Triggers: Exploring How Triggers Impact MySQL Memory Allocation
This blog was originally published in November 2021 and was updated in September 2023. MySQL server performance can sometimes be [...]
August 25, 2023
Failover and Recovery Scenarios in InnoDB Cluster and ClusterSet
This blog post will focus on failover and recovery scenarios inside the InnoDB Cluster and ClusterSet environment. To know more [...]
August 23, 2023
The Deprecation of qpress/QuickLZ Compression Algorithm
To reduce the backup size, save storage space, and speed up the backup and restore process, you can compress a [...]
August 18, 2023
How To Use systemd in Linux to Configure and Manage Multiple MySQL Instances
This blog describes how to configure systemd for multiple instances of MySQL. With package installations of MySQL using YUM or [...]
August 18, 2023
Want to Migrate From MariaDB 10.4 to MySQL 8.0 but Facing Hurdles? MySQL 5.7 to the Rescue!
Note that MariaDB 10.4 is not the latest version and has had new releases since 10.4. The client requirement was [...]
August 17, 2023
InnoDB ClusterSet Deployment With MySQLRouter
This blog post will cover the basic setup of the InnoDB ClusterSet environment, which provides disaster tolerance for InnoDB Cluster [...]
August 15, 2023
An Introduction to MySQL Replication: Exploring Different Types of MySQL Replication Solutions
This blog was originally published in February 2017 and was updated in September 2023. In this blog post, I provide [...]