Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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-68c323f7203d2775286518-i/] command with the safety option [crayon-68c323f7203d6951787353-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 [...]
October 12, 2023
Kubernetes Observability: Code Profiling With Flame Graphs
In this blog post, we’ll review how to run Linux profilers such as perf and produce flame graphs on Kubernetes [...]
October 11, 2023
Deep Dive Into Roles in MySQL 8.0
This blog post discusses roles in MySQL 8.0, which are named collections of privileges. Like user accounts, roles can have [...]
October 10, 2023
Using Jobs to Perform Schema Changes Against MySQL Databases on K8s
Performing an operation is always challenging when dealing with K8s. When on-prem or DBaaS like RDS or Cloud SQL, it [...]
October 4, 2023
What’s New in Percona Toolkit 3.5.5
Percona Toolkit 3.5.5 was released on October 3, 2023. This blog post covers the main changes in this release. pt-online-schema-change [...]
October 3, 2023
Transparent Huge Pages Refresher
Transparent Huge Pages (THP) is a memory management feature in Linux operating systems that aims to enhance system performance. While [...]
September 29, 2023
Using MySQL Offline Mode To Disconnect All Client Connections
As a DBA, one of the very frequent tasks is to stop/start MySQL service for batching or some other activities. [...]
September 28, 2023
Don’t Start Using Your MySQL Server Until You’ve Configured Your OS
Whenever you install your favorite MySQL server on a freshly created Ubuntu instance, you start by updating the configuration for [...]