Aug 08, 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 yet, sometimes I get questions about regaining […]
Feb 13, 2023 |
Cloud, Insight for DBAs, MySQL
Recently, I was working with my colleagues Edwin Wang and Taras Onishchuk and found an interesting edge case involving a situation where a replica running Percona Server for MySQL 5.7, external to AWS Aurora instance version 2.10.2 (5.7-compatible), broke. I recreated the issue in my lab with a simple create database statement, as you will […]
Nov 29, 2022 |
Insight for DBAs, Monitoring, MySQL, Percona Software
Earlier in the year, I was working on an issue where one of my clients had reported a massive influx in connection on their hosts after enabling Percona Monitoring and Management (PMM). This was something I had not seen before and after researching for a couple of days I discovered that if you monitor a […]
Nov 23, 2022 |
Insight for DBAs, MySQL, Percona Software
One thing I commonly hear when working with my clients is “I want to change my DDL strategy in order to avoid locking in my database! The last time I used the same old method I ended up in a metadata lock situation!” I agree that metadata locks can be painful, but unfortunately, it’s completely […]