MySQL Replication: Slave Performance

There's a few final configuration options that may help the performance of your slave MySQL servers. If you're not using certain storage engines, like InnoDB or Berkeley, then by all means, remove them from your configuration. For those two specifically, just add the following to your my.cnf on the slave server:

skip-innodb
skip-bdb

To reduce disk I/O on big MyISAM write operations, you can delay the flushing of indexes to the disk:

delay_key_write = ALL

You can also make all of your write queries take a backseat to any reads:

low-priority-updates

Keep in mind, however, that the last two options will increase slave performance, but it may cause them to lag behind the master. Depending on your application, this may not be acceptable.

Digg This
Reddit This
Stumble Now!
Buzz This
Vote on DZone
Share on Facebook
Bookmark this on Delicious
Kick It on DotNetKicks.com
Shout it
Share on LinkedIn
Bookmark this on Technorati
Post on Twitter
Printed from: http://rackerhacker.com/2008/01/14/mysql-replication-slave-performance/ .
© Major Hayden 2010.

Leave a Reply