… mysql> insert into percona values (0,’percona1′,’vadim’); Query OK, 1 row affected (7.77 sec) percona1 mysql…: STATE EXCHANGE: Waiting for state UUID. 2012-07-24 11:42:51.276 INFO: STATE EXCHANGE: sent state …one behaves without any problem and when the dead node comes back it will perform its…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
…fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, …dead weight.) As a result, some people choose to make the passive server truly passive, handling none of the application’s queries…the insert buffer in a production steady-state. The buffered records are forced to …
Comment: Slow Query Log analyzes tools
June 10, 2008 By 84 Comments
…query log without restarting mysql – i moved the log file aside, touched a replacement, but didn’t give the mysql… an identical server, with data in a state ready to be benchmarked. It’s worth… { # Convert to unix epoch – makes date arithmetic dead easy. $datetime = Time::Local::timelocal($6, $5, $4, …
