… on a traditional master-slave setup, because there are no read-only transactions. However you can distribute this over a multi-master Galera cluster…
Post: Data Corruption, DRBD and story of bug
November 29, 2010 By 6 Comments
… that application corrupts data by itself. For this case regular Master-Slave setup (in addition to DRBD) would protect from such problem.
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…master fails, a new master is promoted from the slaves, no master to master setup needed. Selection of master is based on scores published by the slaves… element is the master-slave “ms” declaration. This is how Pacemaker defines an asymmetrical resource having a master and slaves. The only …
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
… often run directly on the Slave(s) when master switched to one of them (especially easy with Master-Master setup) and when query repeated on the second one. Doing this on Master-Master setup do…
Post: Actively monitoring replication connectivity with MySQL's heartbeat
December 29, 2011 By 2 Comments
…Slave_heartbeat_period | 1.000 | | Slave_received_heartbeats | 1476 | +—————————+——-+ Conclusion If you need to know when exactly the connection between your Master/Slaves…
Post: dbqp and Xtrabackup testing
November 16, 2011 By Leave a Comment
… snapshot and compare to original state Slave setup Similar to our basic test except we create a slave from the backup, replicating from… replication tests by creating heavy randgen loads against the master during backup and slave setup, and other assorted crimes against database software. We…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… MASTER TO to point slave to saved binary log position: change master to master_host=”master“, master_user=”user”, master_password=”password”, master_log_file=”host-bin.000335″, master_log_pos=401934686; 12) Run SLAVE START to…
Post: How to lag a slave behind to avoid a disaster
September 11, 2012 By 5 Comments
MySQL Replication is useful and easy to setup. It is used for very different purposes. For example: split … to slave 2012-09-10T12:41:31 slave stopped at master position mysql-bin.000001/100072820 [...] 2012-09-10T12:49:31 START SLAVE until master… behind at master position mysql-bin.000001/233713063 slave1 [localhost] {msandbox} ((none)) > show slave status\G *************************** 1. row *************************** [...] Slave_IO_Running: Yes Slave_SQL_Running…
Post: Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
June 14, 2012 By 7 Comments
… tested against the following setups: Control The control environment was simply a Master with log-bin enabled and one slave connected (not semi…; gcs.fc_master_slave = yes” based on Codership’s recommended tuning for single-node writing. I was running wsrep_slave_threads=16 and…, as expected, takes approximately 1 RTT for the slave to verify to the master that it got the transaction. PXC 2-colo…
Comment: Virident tachIOn: New player on Flash PCI-E cards market
June 16, 2010 By 19 Comments
… master-slave configuration. However there is another catch, as FusionIO allows to handle very high write load, it is quite possible that slave will not be able to catch-up with master. In my observation as slave is single threaded, slave is probably… load than master. And in this case there is good question if it is worth to setup RAID0 configuration on master if slave not…
