2019-06-06 12:43 UTC

Fun MySQL fact of the day: PITR without GTIDs

When we isolated yesterday's bad transaction using GTIDs, life was pretty simple. But in some cases, GTIDs won't be an option for us. So, today, we'll take a slightly closer look at the binary log and figure out an alternative. ... read more

2019-06-05 11:05 UTC

Fun MySQL fact of the day: PITR with GTIDs

Yesterday, we looked at MySQL's MASTER_DELAY functionality, which we may use to maintain a delayed replica in our important database clusters. A couple weeks ago, we also looked at a very basic point-in-time recovery technique using mysqlbinlog. Today, we're going to combine the two with a universal ... read more

2019-06-04 12:37 UTC

Fun MySQL fact of the day: replication lag can be good

We've spent number of days discussing replication delay, and we've mostly considered replication delay as bad. And, true, in most cases, it usually is pretty bad, but today we're going to consider a case when replication delay is as desirable as it is important. ... read more

2019-05-24 22:18 UTC

Fun MySQL fact of the day: mysqlbinlog

It's 3:37 A.M. when your phone blares out. Your hands are numbed from the early on-set of carpel tunnel and you can't hush the wailing siren that has become of your phone. With adrenaline coursing through your body, you shove your phone under your pillow mashing around in the dark ... read more