… result in low hanging fruit troubleshooting MySQL Replication Lag First fact you absolutely need to remember is MySQL Replication is single threaded, which… is of course rule of thumb depending on differences in master/slave configuration, their load and concurrency you may need to keep…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 5 Comments
… bug in the master‘s or slave‘s MySQL code. If you want to check the master‘s binary log or slave‘s relay log… network (especially if replicating over unreliable long distance networks), MySQL bugs on master or slave, hardware problems and few others. In any case…:(none)> slave stop; Query OK, 0 rows affected (0.00 sec) localhost:(none)> change master to master_log_file=Relay_Master_Log_File,master_log…
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
…slaves people use. For me simple is best. Complex architectures are more error prone harder to maintain (upgrades etc) and troubleshoot…you got pair of servers replicating as Master-Master which you typically want for high…application is only related to the MySQL redundancy for very high quality/high …
