…switches RAID cache in write-through mode which can cause serve performance degradation. Configuration Changes Have you changed MySQL…and by the fact removing slave read traffic from non warmed up slave…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…read caching more efficient in its memory while write buffering can too be done by MySQL and… running replication Slave as slave thread will …writes too. Though for that we have a fix at least. Scalability We need more IO or space than we can get from… time significantly by switching to that backup -…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
…slave replication except that you can fail over in both directions. Aside from MySQL…the write workload from replication, and not the read …and kept it for later. I did the same on the slave…and –daemonize options so it can run in the background and follow along when the passive/active roles switch…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…slave node can’t be called hot because write load often does not touches the same data as read…MySQL Master-Master replication I can add and index on passive node, wait it to catch up and switch…for reads no transaction loss and automated fail over. Whenever you’re using MySQL Cluster, DRBD or MySQL…
Comment: When should you store serialized objects in the database?
January 21, 2010 By 42 Comments
…slave switching I’ve always been able to emulate online index adds. If you actually run operations for…omission from your article is the fact that companies like Facebook and …that you linked to will read and write through to cache without any…if the queries through to MySQL are somewhat slower, the …
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
…as “writer” and roles stay consistent. 2. on db1: stop replication mysql> STOP SLAVE; we don’…doing some changes in parallel and you want to ensure switch from old layout to new …for MySQL or ensure some load balancer/proxy does this, set read-only manually on standby master so application can’t write…
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…switching master binary log file or replication being delayed very significantly you will see different log files for…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
…MySQL for scale out. Most of the companies would have some internal scripts to handle things as automatic fallback and slave…write to the slave…read-only user for slave connection but what if your application simply was misconfigured and…for example you may configure it to remove READER role from…switch…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…for the page which is being requested via read-ahead. Q27 If my workload has a hi amount of concurrent writes…and the ‘last’ serious bug in it was only recently found and fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning a switch…
Post: When should you store serialized objects in the database?
January 21, 2010 By 42 Comments
…slave switching I’ve always been able to emulate online index adds. Projects like MMM and…write amplification. If you are constantly making small updates to one piece of data in a very large blob, the effort MySQL…
