… # binary logging and replication binlog_cache_size=1M binlog_format=MIXED log-slave-updates log-bin=mdmp_freehold_binlog sync_binlog=1 relay-log=mdmp_freehold…_query_time=300 key_buffer_size = 500M concurrent_insert=2 myisam_sort_buffer_size = 64M # innodb innodb_additional_mem_pool_size…
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
… DRBD. If you’re using MySQL with Innodb (and running MyISAM with DRBD makes little sense anyway) you will have to… you have 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…
Comment: Jeremy Cole on MySQL Replication
January 10, 2007 By 12 Comments
… data, 1000+ of writes per minute, all in MyISAM tables using version 4.1. Side note: A project will be underway to… I understand you correctly, the best I can do is: 1. use battery backed up cache 2. set sync_binlog = 1
Comment: Jeremy Cole on MySQL Replication
March 27, 2007 By 12 Comments
I’m planning to run with log-bin and sync_binlog=1. I’m also planning to do a full database backup (…, shouldn’t I be able to restore all data (both MyISAM and all committed InnoDB transactions) by just restoring the last…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… affect MySQL Performance. MyISAM Corruption – If you’re writting to MyISAM tables there is…sync_binlog Is helping by syncing binary log, but at performance penalty. If using Innodb you also might with to use innodb-safe-binlog…wierd error messages. In MySQL 4.1 sync_frm option was added which reduces…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
…higher performance overhead – you can run slave with –sync-binlog and –log-slave-updates so you can see…s patches if you use rpl_transaction_enabled=1 Note even though this functionality is currently …only using Innodb tables and not touching your MyISAM system tables) and use this position to point…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
… 3306 #innodb_flush_log_at_trx_commit=0 sync_binlog=0 slave-skip-errors = 1062 back_log = …150M key_buffer = 256M key_buffer_size = 256M myisam_sort_buffer_size = 16M join_buffer_size …(those using the mysqlclient10 compatibility package). #old_passwords=1 # Disabling symbolic-links is recommended to …
Comment: 7 Reasons why MySQL Quality will never be the same
December 11, 2008 By 15 Comments
… was likely to make the binlog and InnoDB out of sync. The sync_binlog option was added in 4.1 to make this less likely… for safety). I never used 3.X in production when MyISAM was THE storage engine. I remember silly claims about how…
Comment: Percona XtraDB Cluster reference architecture with HaProxy
August 3, 2012 By 63 Comments
…://10.1.1.1:4567,gcomm://10.2.2.2:4567,gcomm://10.3.3.3:4567,gcomm:// [mysqld] # # * Basic Settings # server_id=1 binlog… nodes) innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 log_slave_updates wsrep_replicate_myisam=1 now by adding the value… reboot the machine and let the rsync process complete….the synced node does not let me make connections…so i have…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… to be very careful such as using sync-binlog innodb_flush_logs_at_trx_commit=1 and only using Innodb tables to be… such as modifying meta data stored in MyISAM tables which can get master out of sync with slaves in case of soft… its position on master), Replication breakage (or running out of sync) due to MySQL bugs or wrong use. Interesting enough very…
