Hi Mark, No it’s not, in these setup Percona XtraDB Server is used (but it can be any … as Master -> Slaves and in case of the master being evicted (intentionally or not) from the cluster the “best” slave will be promoted as Master. Your howto seems very interesting and it’s similar to this setup. I know Yves…
Post: Just how useful are binary logs for incremental backups?
July 21, 2009 By 6 Comments
We’ve written about replication slaves lagging behind masters before, but one of the other side effects of the … a Master-Slave topology. The database size is 100 GB (same tables on each). The slave machine barely keeps up with the master (at….75) = 19h48m). If you wanted to do something like setup a new slave with a 24-hour old backup, and apply the…
Comment: Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
… two Percona server node as Master-Master ? I believe the point with this question is that the standard setup expects you to have… independently. You can use this in master-slave mode, and it brings back failover and slave promotion issues like you have with MySQL… the question: no, in this mode you must not use master-master load balancing!) Q: In the haproxy example, how do you…
Comment: Why you can't rely on a replica for disaster recovery
August 3, 2010 By 25 Comments
… completely horrible setup…and useful for someone else. We run master/slave MySQL replication…ZFS is the FS for both master and slave. We snapshot the filesystems on master and slave regularly. 3…
Post: The Math of Automated Failover
September 18, 2012 By 9 Comments
… assurance ? right testing! If you’re really serious implementing HA setup you might need to spend 3-10 times as much… large systems only. If I’m looking not at one Master-Slave pair but at 1000 I will be dealing with failures… Master to Slave but never fail back without manual intervention. We also will failover only when replication is caught up (wait for slave…
Comment: Logging your MySQL command line client sessions
July 9, 2008 By 10 Comments
… installed. They have 5 database servers in a master/slave farm setup. I have aliases setup to launch mytop and have it connect to… handy to quickly check how queries are spreading over the slave pool as the load balancing is controlled on the application…
Comment: Data Corruption, DRBD and story of bug
November 30, 2010 By 6 Comments
… a drop database on master. Slave happily replicates. Backup time Customer deletes a bunch of data they actually need. Slave happily replicates. Backup time. variants on the same An HA setup protects you from hardware failures…
Comment: State of the art: Galera - synchronous replication for InnoDB
October 27, 2009 By 15 Comments
… run with multi-master, it is always possible to direct writes just to one node. This setup works then as synchronous master slave replication.
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
…! now,i meet a trouble and need your help! i setup percona cluster in vm, if in file /etc/my.cnf… user=mysql wsrep_cluster_address=gcomm:// binlog_format=ROW wsrep_slave_threads=2 wsrep_cluster_name=trimethylxanthine wsrep_sst_method=rsync…; gcs.fc_factor = 1; gcs.fc_limit = 16; gcs.fc_master_slave = NO; gcs.max_packet_size = 64500; gcs.max_throttle = 0…
Comment: Why MySQL could be slow with large tables ?
August 20, 2006 By 141 Comments
… Mysql Server too (and the next step will be a Master/Slave server setup for the database).
