by Peter Sylvester | Aug 8, 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... by Peter Sylvester | 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... by Peter Sylvester | 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... by Peter Sylvester | 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...