… the slave to replicate everything EXCEPT a specified set of databases and tables. With this …master and the slaves at the bottom of the replication topology. On the top-level master, you leave all filters disabled; on the relay master…a problem before it occurs. For example, if you see a large number…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
… any server on the replication environment, master or slave: # innobackupex /destination/ In the destination folder there will be a file with the name xtrabackup… usual restore procedure, for example remember to change the permissions to mysql:mysql. 4- Start the new slave from that GTID position…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
…empty transactions. Let’s imagine that the replication in slave server is not working because of an error… from the SHOW SLAVE OUTPUT as we can see in the example. This slave server has retrieved … this you will end up with data inconsistencies between Master and Slave servers. pt-table-checksum can …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… row? We call rows that are updated heavily “hotspots”. Examples of hotspots Example 1: Your application is an online game and you… making them (anyone obsessively testing slave position to ensure it’s caught up with the master?). Synchronous replication with PXC and Galera is no different…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… 1.0 to allow replication to resume as soon as possible. An example configuration tuning flow control in a master/slave cluster might be… be the slaves with no writes coming from them. However, with multi-node writing, larger queues will make certification more expensive replication conflicts more…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
…slave_updates enabled on the cluster node acting as async slave for replicated events from the async master…replicating from an async master, for example like the one described on these two bugs. Galera use writesets to replicate…Cluster nodes as workaround. Note that with the latter, make sure to not…
Post: Master-Master or Master with Many Slaves
April 6, 2007 By 7 Comments
… he criticizes Master-Master approach, finding Master with many slaves more optimal. There is surely room for master-N-slaves systems but I find Master-Master replication much …example if we have 6 boxes we can use 1 master and 5 slaves or 3 master-master pairs. In this case each of the master-master…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
…Master-Master replication (often in active-passive mode) is popular …master-master pair as well as other configurations such as master-master and bunch of slaves. Typically you would define “roles” for example… time for master-master pair. Each of the roles will have pair of IPs associated with it …
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…replication” and “Master-Master with MMM manager” otherwise, you can only consider the other three solutions. Data 100% safe MySQL replication no Master-Master with…example, “setting up replication” can be as simple as CHANGE MASTER…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… replication, or in MySQL 5.0 and earlier, doing the work on a slave, then piping the results back up to the master with LOAD DATA INFILE, which kind of emulates row-based replication in… day at a time, for example. There are a lot of other ways you can make replication faster. I wrote a…
