…makes reads consistent and therefore makes the replication between servers consistent. If you execute SELECT *…restarting transaction transaction2 > INSERT INTO t VALUES(29); ERROR 1205 (HY000): Lock wait timeout exceeded;…/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the default…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
…MySQL replication hierarchy? We have, too. As consultants, a lot of times we need to get a quick overview of the whole replication… behind, running, no errors Slave mode IDEMPOTENT …29:58 (started 2011-10-18T09:10:16) Replication Is a slave, has 0 slaves connected, is not read_only Filters replicate…
Post: Debugging problems with row based replication
May 6, 2010 By 10 Comments
…MySQL doesn’t know anything is wrong. This isn’t the case with row-based replication…Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event’s master log mysql-bin.000001, end_log_pos 340718 This error…* The MySQL 5.1 default binary logging format changed back to STATEMENT in MySQL 5.1.29…
