Used to be that replication lag was as simple as Seconds_Behind_Master (renamed to Seconds_Behind_Source). But with multi-threaded replication (MTR) this is no longer the case. It’s time to relearn replication lag monitoring using Performance Schema tables.

For this penultimate article before Christmas, let's announce the 30th anniversary of MySQL!

For the 22nd day of our Advent Calendar of Content, we bring you a summary of all the MySQL Blog posts that demonstrate using the OCI TypeScript SDK

Just before the end of the MySQL Advent Calendar, let me announce (or remind you) that MySQL will turn 30 next year!! The first version of MySQL was released in 1995, three decades ago. That database would become MySQL, the open-source relational database management system that has since transformed how developers build and scale applications. […]

For the 21st day of our Advent Calendar of Content, we bring you a summary of all the MySQL Shorts that are focussed on topics that would interest DBAs.

This blog post explains the cause of “ERROR 1412 (HY000): Table definition has changed, please retry transaction” with the specific Isolation level settings. Background As per the MySQL documentation, this error should occur for “operations that make a temporary copy of the original table and delete the original table when the temporary copy is built.” […]

Let's stay a bit longer with MySQL 3.2x to advance the MySQL Retrospective in anticipation of the 30th Anniversary.

Let’s stay a bit longer with MySQL 3.2x to advance the MySQL Retrospective in anticipation of the 30th Anniversary. The idea of this article was suggested to me by Daniël van Eeden. Did you know that in the early days, and therefore still in MySQL 3.20, MySQL used the ISAM storage format? IBM introduced the […]

This blog is not intended to offer anything extraordinary; instead, consider it an anecdote, a lesson, or simply a proper way of doing things without the need to run a test when in doubt. That said, I must emphasize that, as always, testing everything before deploying to production is essential. Let’s dive into the story: […]

Earlier this year, we published a series of blog posts focusing on using thhe OCI CLI to manage HeatWave MySQL Instances. Here is a summary of each post. Using the Oracle Cloud TypeScript SDK Part 1 – Listing MySQL HeatWave Instances The first post in this series demonstrates how to return a list of HeatWave […]