… performance issues with ext3 and sync_binlog http://www.mysqlperformanceblog.com/2009/01/21/beware-ext3-and-sync-binlog-do-not-play-well-together…
Comment: Drop table performance
April 20, 2011 By 22 Comments
… performance issues with ext3 and sync_binloghttp://www.mysqlperformanceblog.com/2009/01/21/beware-ext3-and-sync-binlog-do-not-play-well-together…
Post: Battery Learning still problem many years after
February 10, 2011 By 7 Comments
… going from innodb_flush_log_at_trx_commit=1 and sync_binlog=1 to values 2 and 0 appropriately. Both can be…, though you may lose some uncommitted transactions and binlog may get out of sync with Innodb transaction logs. I’m also wondering…
Comment: 7 Reasons why MySQL Quality will never be the same
December 11, 2008 By 15 Comments
… on the master was likely to make the binlog and InnoDB out of sync. The sync_binlog option was added in 4.1 to…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
…-server-id=0 log-bin=newcrmdb1-bin #binlog_do_db=crmdb binlog_do_db=newcrmdb binlog-ignore-db=mysql,test #replicate_do_db… #master-port = 3306 #innodb_flush_log_at_trx_commit=0 sync_binlog=0 slave-skip-errors = 1062 back_log = 75 # skip-innodb…
Comment: Percona Server 5.5.15 + Galera 21.1-beta2
October 5, 2011 By 18 Comments
Seppo, >Note that Galera does not need to write binlog files In that case can Galera run without binlog enabled at all? And if binlog is required, can sync_binlog be set to 0?
Comment: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… sync_binlog setting in benchmarking : For single node, no replication is going on so there’s no need to even enable the binlog, right? For Galera cluster, does it require binlog to run? I seem to recall reading a long time ago that Galera replication doesn’t need binlog. is…
Comment: What is innodb_support_xa?
March 8, 2011 By 3 Comments
It seems there are many system variables which influence the consistency of the binlog with InnoDB: – sync_binlog – binlog_format – innodb_flush_log_at_trx_commit – innodb_locks_unsafe_for_binlog – innodb_support_xa – tx_isolation
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… practice you have to be very careful such as using sync-binlog innodb_flush_logs_at_trx_commit=1 and only using… stored in MyISAM tables which can get master out of sync with slaves in case of soft crash. Unless you got… its position on master), Replication breakage (or running out of sync) due to MySQL bugs or wrong use. Interesting enough very…
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
… innodb_flush_log_at_trx_commit=1 and sync_binlog=1 you will have 4 “sync” operations in MySQL 5.0 – there is… on each binary log write and both have to be synced to avoid data loss. Though in case of “data journaling…
