…replication, can you help re-affirm this statement about replication? I’ve observed things differently in MySQL…replication down. If the load takes 4 hours on the master, it will cause the slave…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
Post: Fighting MySQL Replication Lag
September 22, 2008 By 6 Comments
… result in low hanging fruit troubleshooting MySQL Replication Lag First fact you absolutely need to remember is MySQL Replication is single threaded, which means if you… slave to run the same load through single thread. The solution in many cases is to simply space it out and slow down…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… only using Innodb tables your replication is not completely crash safe – if Slave MySQL Server crashes/power goes down it is likely for relay logs to… a MySQL replication slave the last master binlog file InnoDB: position 0 115, file name portland-bin.001717 All you needed to do is…
Post: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
… shutting down MySQL? If not, what is the impact on the running server? Blocking, I/O load, cache pollution, etc? What technique is used… effects are there on MySQL? I’ve seen systems that do a RESET MASTER, which immediately breaks replication. Are there any FLUSH…, and replication? Can you use the system to set up new MySQL replication slaves? How? Does the system verify that the backup is restorable, e…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…is easy for MySQL replication to become bottleneck when Master server is not …replication capacity, so we can deal with replication load before slave is unable to catch up. Need to replication capacity is… ALTER TABLE through replication they will surely get your replication capacity down for their …
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…MySQL replication reliable, part of which is to eliminate temporary tables. The idea is this: if a slave is stopped (or crashed) while a temporary table is…
Post: MongoDB Approach to database synchronization
April 30, 2010 By 4 Comments
… post is about one replication problem and how MongoDB solves it. If you’re using MySQL Replication when your master goes down it is possible for some writes to be executed on the master, but not on the slave… Durability is implemented it will be pretty cool. What is really interesting – it should be possible to apply the same concept to MySQL Replication…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… MySQL Replication (statement based) works by fetching statements from MASTERs binary log and executing them on the SLAVE. Since MySQL 4.0 this process is…the “snapshot” – shutting down MySQL Server and copying data, using LVM, Using Innodb Hot Backup Tool, Using another Slave, using backup image etc…
Post: Actively monitoring replication connectivity with MySQL's heartbeat
December 29, 2011 By 1 Comment
… to the SLAVE every X seconds where X is a value you can define. If the network link goes down or the …configure replication‘s heartbeat? Is very easy to setup with negligible overhead: mysql_slave > STOP SLAVE; mysql_slave > CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD=1; mysql_slave > START SLAVE; …
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
… not shut down normally! InnoDB: Starting…MySQL replication slave the last master binlog file InnoDB: position 0 12501110, file name bin.000025 InnoDB: Last MySQL…where 10b is master of 1a mysql> show master status; …
