by Mauricio Cacho | Sep 20, 2023 | Insight for DBAs, MySQL, Percona Software
If 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... by Mauricio Cacho | Mar 6, 2023 | Insight for DBAs, MySQL
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... by Mauricio Cacho | Oct 5, 2022 | Insight for DBAs, Insight for Developers, MySQL
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...