…. Recently in MySQL 5.6, mysqlbinlog got a new feature addition that supports connecting to remote MySQL instances and dumping binary log data to local disks ( http://dev.mysql.com/doc/refman/5.6…>&1 > /var/log/livebinlog/server2.log & As a great addition, older logfiles that have been rotated can be checked against the MySQL server’s…
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
…’m surprised to read enabling binary log drops update performance. I guess Jeremy speaks about enabling binary log and setting sync_binlog option which… to flush their cache. Watch out for MySQL 5.0 – if you enabled Binary log with MySQL 5.0 you loose group commit which… seeks but it is only part of the latency. Disk rotation is another big contibutor. Even if we stay on the…
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
… put on and off rotation without and complex procedure. Lets now compare it to MySQL Replication based solution. With MySQL Replication you have… think about – each slave can be at different coordinates in binary log compared to masters. There can be some events which are… queing event in relay log. Now lets see how Synchronous Replication solutions such a Percona XtraDB Cluster and MySQL Cluster are different…
Post: Benchmarking Galera replication overhead
October 13, 2011 By 12 Comments
… consider: You see quite periodic drops for MySQL replication, I think it is related to binary logs rotation And, second, much more serious problem: After 1800 sec of run, slave in regular MySQL replication was behind…
Comment: Tools
July 17, 2008 By 31 Comments
I developed a Perl package to help with managing groups of MySQL servers; hopefully others will find it useful. Current components monitor replication, rotate binary logs, and allow execution of commands on groups of servers from a central server. http://forge.mysql.com/wiki/ProjectPage_MyCAT
