… in time recovery it can go unnoticed. sync_binlog Is helping by syncing binary log…master.info corruption – If slave happens to crash you can also have relay logs corruption and master…experience related to MySQL Crash Recovery – Restoring data from backup, corrupted Innodb tablespace recovery etc …
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
…master-slave pair, subject the master to a transactional load, crash the master, restart it, then ensure the master and slave are in sync…CRASHED (101) I also took pains to ensure that the randgen workload was having an effect on the test tables between crash/recovery…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… does crash recovery it would print position in master log files up to which replication was done: InnoDB: In a MySQL replication slave the last master binlog… can run slave with –sync-binlog and –log-slave-updates so you can see what last statement was executed before the crash and then find…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… sync-binlog …recovery is another “liability” of compex replication tree setup. On the contrary sharded master-master pairs (or master with few slaves…Master or Slave running out of space, Slave crashing (and loosing its position on master), Replication breakage (or running out of sync) due to MySQL…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…binlogs on the master to a second server. Allows you to roll forward backups even after losing the master Very useful for disaster recovery…master and slave Re-transfer files that are partially transferred Compress the files after successful transfer Amazon S3 for MySQL…
Post: Storing MySQL Binary logs on NFS Volume
July 30, 2010 By 19 Comments
…recovery from backup. I was testing high volume replication today using Sysbench: sysbench –test=oltp –oltp-table-size=10000000 –db-driver=mysql –mysql…sync_binlog=0 and innodb_flush_log_at_trx_commit=2 I noted however if I enable replication – connect the slave…slave is caught up with master…
Comment: MySQL Replication vs DRBD Battles
May 1, 2008 By 12 Comments
…IOs pending) in InnoDB crash recovery code? The Google patch had more than semi-sync for an HA solution with MySQL. It also …slave replication state in sync after a crash (transactional replication). But the most interesting feature was mirror binlog. This maintained mirrors of the master‘s binlog…
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
…mysql wsrep_cluster_address=gcomm:// binlog_format=ROW wsrep_slave…binlog=1 innodb_autoinc_lock_mode=2 the wrong infomaton : 130221 17:59:00 mysqld_safe WSREP: Running position recovery… = 16; gcs.fc_master_slave = NO; gcs.max_packet…= 0.25; gcs.sync_donor = NO; …have already crashed, something is…
