… state in sync after a crash (transactional replication). But the most interesting feature was mirror binlog. This maintained mirrors of the master’s binlog on… thread would copy events into the relay log and the mirrored binlog. It allows hierarchical replication and transparent slave failover. We are…
Comment: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
Should’nt Google’s MySQL solution an HA option: . Semi-sync replication to wait for replica’s responses . Mirror binlog on the replicas . Make replicas serve the mirrored binlogs during the failover The code is there. But, it is not smoothly integrated yet.
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…binlog_cache_sizeblogpercona.commanual Binlog_cache_useblogpercona.commanual binlog_direct_non_transactional_updatesblogpercona.commanual binlog_do_dbblogpercona.commanual binlog_formatblogpercona.commanual binlog_ignore_dbblogpercona.commanual binlog…mirrored…
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… Google has solution for us again which comes as “log mirroring” patches which make sure Slaves has copy of logs as… its position on master), Replication breakage (or running out of sync) due to MySQL bugs or wrong use. Interesting enough very…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
…innodb_lock_wait_timeout 50 innodb_locks_unsafe_for_binlog OFF innodb_log_buffer_size 8388608 innodb_log_file…pages_pct 75 innodb_max_purge_lag 0 innodb_mirrored_log_groups 1 innodb_old_blocks_pct 37 …innodb_strict_mode OFF innodb_support_xa ON innodb_sync_spin_loops 30 innodb_table_locks ON innodb_…
