Tagged with "binlog"
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
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
STATEMENT-based binary log format. When using a
STATEMENTbinary log format, MySQL very simply puts the SQL statement that issued a change into the binary log. Then, when ... 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