Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
June 1, 2023
Process MySQL LIMIT & ORDER BY for Performance Optimization
Updated June 1, 2023. Suboptimal MySQL ORDER BY implementation, especially together with MySQL LIMIT is often the cause of MySQL [...]
June 1, 2023
Migrating From MariaDB to Percona Server for MySQL 8: The Security Witchcraft
Hello friends, on certain occasions, some clients, for whatever reason, ask us to migrate a supposedly “equivalent” brand of an [...]
May 16, 2023
Backup and Restore with MyDumper on Docker
At the end of 2021, I pushed the first Docker image to hub.docker.com. This was the first official image and [...]
May 15, 2023
Proof of Concept: Horizontal Write Scaling for MySQL With Kubernetes Operator
Historically MySQL is great in horizontal READ scale. The scaling, in that case, is offered by the different number of [...]
May 2, 2023
How To Use pt-secure-collect for Capturing Data in a Secure Way From the OS and Database System
Sometimes crucial data sharing is avoided because of compliance rules, organizational policies, or numerous security concerns. The common use cases [...]
May 2, 2023
ChatGPT vs. MySQL DBA Challenge
Given the increasing popularity of ChatGPT in solving questions of humankind, I decided to take a better look at the [...]
May 1, 2023
Save Money in AWS RDS: Don’t Trust the Defaults
Default settings can help you get started quickly – but they can also cost you performance and a higher cloud [...]
April 24, 2023
How to Persist a Hashed Format Password Inside ProxySQL
In this blog post, we will see how to persist the password inside the ProxySQL mysql_users table in hashed format [...]
April 21, 2023
Fixing Errant GTID With Orchestrator: The Easy Way Out
In this article, we will discuss errant Transaction /GTID and how we can solve them with the Orchestrator tool. Orchestrator [...]
April 20, 2023
Upgrading to MySQL 8: Tools That Can Help
As we approach end of life for MySQL 5.7 later this year, many businesses are currently working towards upgrading to [...]
April 19, 2023
MySQL 8.0.33 – A Quick Peek
MySQL released version 8.0.33 on April 18th, featuring some attention-catching features. This blog post is a quick review of the [...]
April 17, 2023
MySQL 8 Doesn’t Like Your Groups
If you have not been keeping up with MySQL news, MySQL 5.7 reaches end of life in October 2023. This [...]
April 14, 2023
MySQL Data Caching Efficiency
A shared characteristic in most (if not all) databases, be them traditional relational databases like Oracle, MySQL, and PostgreSQL or [...]
April 12, 2023
Don’t Auto pt-online-schema-change for Tables With Foreign Keys
During the early stages of my career, I was captivated by the theories and concepts surrounding foreign keys and how [...]
April 11, 2023
Take This Unique Quiz About Duplicate Indexes In MySQL | pt-duplicate-key-checker
Indexes are crucial for optimizing query execution times in databases, but having an excessive number of indexes, or redundant ones, [...]
April 10, 2023
Masquerade Your Backups To Build QA/Testing Environments With MyDumper
For a long time, MyDumper has been the fastest tool to take Logical Backups. We have been adding several features [...]
April 6, 2023
Turbocharging Percona Monitoring and Management With Loki’s Log-shipping Functionality
In this blog post, we’ll check how to integrate Percona Monitoring and Management (PMM) with Loki to be able to [...]
April 4, 2023
ProxySQL for Short-Term Application Fixes
When talking about the benefits and use cases of ProxySQL with clients, one feature I generally reference is the query [...]
April 4, 2023
Creating and Using MySQL 8 User Attributes
In this blog post, we’ll look at MySQL 8 user attributes and how we can use them. What is the [...]
April 4, 2023
MySQL 5.7 Upgrade Issue: Reserved Words
MySQL 5.7 reaches End of Life status this October. If you still need to start your migration, time is getting [...]