… is to set up replication filters on the slave, as described in the MySQL manual. You can configure the slave to only replicate a specific database, a… not that familiar with, I’d suggest reading over the manual’s description of how replication filtering rules are processed. There are…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…of articles focused on MySQL 5.6 GTIDs. …mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; Those of you who have already done these operations with file-based replication…specific event. The only part were we… mysqlbinlog to start reading from there? Unfortunately, …
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
…make the master read-only? Can we use regular replication for some slaves and GTID replication for other slaves at the same …replication and GTID replication This time, we will enable GTID replication on slave #1, but not on slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…existence of a replication feedback mechanism, unlike anything you find in standard async MySQL replication. It …on all nodes. On a master/slave cluster, therefore, it’s reasonable to increase the fc_limit because the only… I execute a FLUSH TABLES WITH READ LOCK on node3: [root@node3 ~]# myq_status …
Post: How does MySQL Replication really work?
January 9, 2013 By 9 Comments
…MySQL replication, but my main focus will be the logistics – how replication events are written on the master, how they are transferred to the replication slave…there’s only one thread reading binary log from the master and one writing relay log on the slave, very rarely copying of replication events…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
…MySQL Replication Lag. The story is typically along the lines everything is same as before and for some unknown reason the slave…
Post: Making MySQL Replication Parallel
January 30, 2007 By 1 Comment
…MySQL Replication Parallel. Many of us have been beaten by the fact MySQL Replication is single threaded so in reality it is only…MySQL Replication semantics – which is – Slave database state corresponds to master database state at certain point in time. It is delayed but threads reading…pieces on it,…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
…MySQL replication hierarchy? We have, too. As consultants, a lot of times we need to get a quick overview of the whole replication… has a replication filter on it,…Replication Is a slave, has 0 slaves connected, is not read_only Filters replicate_wild_ignore_table=foo%.mount% Binary logging ROW Slave…
Post: Thoughts on MySQL Replication
July 7, 2006 By 18 Comments
… even if writes only consume 10% of resources as almost only one core and only one disk will be working on slave side. Now let… else. So your “read” performance will drop 4 times if write load growth by only 50%. – Delays in replication MySQL replication is fast which means… database is small and load is virtually read only. you may however want to structure replication with median servers to avoid master overload…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…” \ last-lrm-refresh=”1322236006″ property $id=”mysql_replication” \ replication_info=”10.2.2.162|mysql-bin.000090|106″ rsc_defaults $id=”rsc-…some cases, if slaves are logging replication updates, it may cause failover issues. Also, the solution relies on the read_only setting on the slave so, …
