Featured
Percona Products
Percona Services
Use Cases
Mauricio CachoIf you’re a DBA, one of your “easiest” tasks is to stop/start MySQL during a maintenance window, but even that could lead to unwanted scenarios if you modify some dynamic parameters at some point in your instance. Here’s a brief story of how this could happen, to make it clearer: You’re a DBA managing a […]
MySQL uses Redo Logs internally during crash recovery to correct data written by incomplete transactions. But how do you know what the right Redo Log size is? We will walk through how to figure that out in this blog. We already have a couple of posts related to this topic. “How to calculate a good […]
A few weeks back, we faced an issue in a replication environment for a Managed Services client: LAST_ERROR_MESSAGE: Worker 2 failed executing transaction ‘UUID:GTID’ at master binlog.0012345, end_log_pos 98765; Error ‘Operation CREATE USER failed for ‘test_user’@’10.10.10.10” on query. Default database: ‘mysql’. Query: ‘CREATE USER ‘test_user’@’10.10.10.10’ IDENTIFIED WITH ‘mysql_native_password’ AS ‘************” After some initial investigation, we […]