…a single thread and something which might not look like a lot of load for your powerful master may be enough to…in other case 10-20% difference in data size can be the difference between slave never lags and slave never is able to catch up. MySQL…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…to get a standby MySQL server or at least synchronously replicated master binary logs. If you can‘t loose any single transaction you’ve can…to the slave. What if you can ? The switch to the slave in this case is not very easy too – all slaves can be on different positions at the master…
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
…single master and should have done sharding functional partitioning or something else. Complex Replication There are impressive numbers out there on how many slaves…be able to handle all traffic from capacity planning standpoint anyway. At the same time slave can be perfect to be…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…in MySQL 4.1 or changing JOIN evaluation in 5.0 (which could both cause different result set or make query not runnable in MySQL…Master. In many cases you can leave the ex-Master as a slave so you can fail back to the old version easily if you need to. In…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
…a counter how many time given object – blog post, forum thread, image, movie etc was viewed. This is sometimes handy feature but it can be…to serialize transactions on the slave which could be executed in parallel on the master. So we learned it can be quite nasty, so how can…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…in MySQL 5.0 and earlier, doing the work on a slave, then piping the results back up to the master…a lot of joins between fact and dimension tables, and so on. With careful tweaking, many of these things can be overcome, but how…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
…slaves used for long reporting queries can have queries running for hours which stalls replication progress for this time. As MySQL Replication goes in single…Master-Master setup do not forget to disable binary logging with SET SQL_BIN_LOG=0 before you run ALTER TABLE query. Replication Overload Many…
Post: Debugging problems with row based replication
May 6, 2010 By 10 Comments
…in DML statements. A statement based replication slave can get out of sync with the master fairly easily, especially if data is changed on the slave…MySQL slaves to prevent accidental changes in data from happening! *edit* The MySQL 5.1 default binary logging format changed back to STATEMENT in MySQL…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
…in MySQL 5.0. There are number of ways the problem can be solved but first we decide to see how broad is it. We let Slave to…to be fixed. At this point we were confident enough Slaves can handle the traffic and we could put them in production. Before upgrading Master…
Comment: Master-Master or Master with Many Slaves
April 9, 2007 By 7 Comments
…a single master and two slaves that can be promoted to master. We can just create as many shards as we need writes.” Well that if fine when. To often however people use too many slaves using replication Instead of partitioning. By the way, how many shards do you have and how many…
