ROWbinary log format, you may have spent the night sad and upset, maybe even unable to sleep. Likely, the narrative was along the lines of, "why, oh why, MySQL, must you make me choose between binary log size and safety?!" Well, rest-assured, tonight ... read more
Tagged with "replication"
STATEMENTbinary log format. We've also discussed, no less than two times, that the
STATEMENTformat is prone to incorrect results for non-deterministic DML (Data Manipulation Language) statements, and last Friday, we considered the ... read more
MASTER_DELAYfunctionality, 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 twist. ... read more
Seconds_Behind_Masterand identified some of its shortcomings. While it's not a completely useless metric, it's also not a very helpful one. What we probably really want is an absolute measure of replication latency, and we'll look at one way of accomplishing ... read more