Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
January 3, 2024
The Various Methods to Backup and Restore ProxySQL
ProxySQL is a high-performance SQL proxy that runs as a daemon watched by a monitoring process. The process monitors the [...]
January 2, 2024
Is Thread Pool Plugin the Right Choice for Your Workload?
TL&DR: Depending on the workload, the thread pool plugin can cause serious performance drops. This post was motivated by two [...]
January 2, 2024
Audit DROP Statements in Percona Server for MySQL
Managing database servers involves different aspects, among which security is critical. We know that we should always grant the minimal [...]
December 28, 2023
Introducing the MySQL Audit Log Filter Plugin
We’re happy to introduce Audit Log Filter — our newly upgraded audit plugin. Its functionality has been significantly improved in [...]
December 20, 2023
How to Monitor Online InnoDB Buffer Pool Resizing
The InnoDB buffer pool acts as a powerhouse for MySQL, caching frequently accessed data and index pages in memory to [...]
December 14, 2023
Can You Trust AI Chatbots When Seeking Help With Databases?
Will 2023 be called the year of Generative Artificial Intelligence (AI)? I don’t know, but certainly, the launching of ChatGPT [...]
December 13, 2023
Exploring MySQL 8 Priority-Based Error Log Filtering
Error logging is a critical aspect of database administration, providing insights into issues, warnings, and errors that may affect the [...]
December 12, 2023
How to Use Percona Toolkit’s pt-table-sync for Replica Tables With Triggers in MySQL
In Percona Managed Services, we manage Percona for MySQL, Community MySQL, and MariaDB. Sometimes, the replica server might have replication [...]
December 11, 2023
Maximizing Performance of AWS RDS for MySQL with Dedicated Log Volumes
A quick configuration change may do the trick in improving the performance of your AWS RDS for MySQL instance. Here, we [...]
December 8, 2023
Keepalived for Source Failover: Percona XtraDB Cluster to Percona Server for MySQL
In this article, we will demonstrate how to achieve asynchronous replication automatic source failover when our replica is a Percona [...]
December 7, 2023
Backup Mastery: Running Percona XtraBackup in Docker Containers
Ensuring the security and resilience of your data hinges on having a robust backup strategy, and Percona XtraBackup (PXB), our [...]
December 6, 2023
MySQL Interview Questions: Wrong Answers Only
During an interview or while having general discussions, I have found some funny responses that can be easily classified as [...]
November 8, 2023
Percona XtraBackup 8.0.34 Removes the Server Version Check
With the release of Percona XtraBackup 8.0.34-39, Percona XtraBackup (PXB) allows a backup on server version 8.0.35 and higher. We [...]
November 6, 2023
Quick Peek: MySQL 8.2 and 8.0.35
Oracle recently made their quarterly releases with MySQL 8.0.35 and MySQL 8.2. This blog post is a quick look at [...]
November 1, 2023
Is ANALYZE TABLE Safe on a Busy MySQL Database Server?
Sometimes, there is a need to update the table and index statistics manually using the ANALYZE TABLE command. Without going [...]
November 1, 2023
MySQL Backup and Recovery Best Practices: The Ultimate Guide
This blog was originally published in January 2021 and updated in November of 2023. As businesses and applications increasingly rely [...]
October 31, 2023
Resolving Data Drift in a Dual-Primary Topology With Replica in MySQL/MariaDB
Hello friends, In Managed Services, we have the opportunity to see different technologies and various topologies, which makes the work [...]
October 17, 2023
Using CLONE INSTANCE With DATA DIRECTORY on Replicas With Data
This blog post discusses using the [crayon-691fcc6435cd5741529509-i/] command with the safety option [crayon-691fcc6435cdb395242749-i/] when you do not have enough disk space to [...]
October 13, 2023
Debugging MySQL Core File in Visual Studio Code
Visual Studio Code (VS) supports memory dump debugging via C/C++ extension: https://code.visualstudio.com/docs/cpp/cpp-debug#_memory-dump-debugging. When MySQL generates a core file, the VS [...]
October 13, 2023
Comprehensive Insights Into SDI in MySQL 8.0
A common practice among DBAs and developers is to copy table data and .frm files from the data dictionary. They [...]