by Marcelo Altmann | Feb 26, 2018 | Insight for DBAs, MySQL
In this blog post, I’ll look at how to execute a MySQL single table Point-In-Time Recovery.I recently wrote a blog post describing a different way of doing Point-In-Time Recovery (PITR). If you want to know the step by step, please visit the mentioned blog... by Marcelo Altmann | Oct 23, 2017 | Insight for DBAs, MySQL
In this blog, I’ll look at how to do MySQL point in time recovery (PITR) correctly.Sometimes we need to restore from a backup, and then replay the transactions that happened after the backup was taken. This is a common procedure in most disaster recovery plans,... by Marcelo Altmann | Feb 8, 2017 | Insight for DBAs, MySQL
This blog we describe an issue with MySQL 5.7’s super_read_only feature when used alongside with GTID in chained slave instances. Background In MySQL 5.7.5 and onward introduced the gtid_executed table in the MySQL database to store every GTID. This... by Marcelo Altmann | Jan 27, 2017 | Insight for DBAs, MySQL
In today’s blog, I will show an issue with seconds_behind_master that one of our clients faced when running slave_parallel_workers > 0. We found out that the reported seconds_behind_master from SHOW SLAVE STATUS was lying. To be more specific,... by Marcelo Altmann | Nov 8, 2016 | MySQL
In this blog post, we will discuss how we can verify if an application transaction executed on the master has been applied to the slaves.In summary, is a good practice to alleviate the load on the master by doing reads on slaves. It is acceptable in most of...