when we use the mysql replication, If the sync_binlog
is not set to 1, there is a risk of corruption of the binary log if the
server crashes. But, in many filesystems/OS, sync_binlog=1 is currently way
too slow (sometimes 2-4 times slower than set to 0). we can solve these by following solutions:
1)wait the mysql version upgrade to 5.6,we can get the information from http://forge.mysql.com/worklog/task.php?id=4925
2)change the linux file system to solaris ZFS or use Linux XFS. we can get the information from peter's URL:
http://www.mysqlperformanceblog.com/2009/01/21/beware-ext3-and-sync-binlog-do-not-play-well-together/
3)we want to change the OS or file system,we can change the linux file system flush cache time as following:
mount -o remount,notatime,nodiratime,data=ordered,barrier=0,commit=1 /
4)Using a write cache protected by battery (BBWC),we can get info from URL:
http://yoshinorimatsunobu.blogspot.com/2009/05/make-sure-write-cache-is-enabled-on.html
No comments:
Post a Comment