… are many documents about that: http://dev.mysql.com/doc/refman/5.6/en/replication-gtids-concepts.html One thing that worths… on the slave: slave> set global GTID_EXECUTED=”9a511b7b-7059-11e2-9a24-08002762b8af:1-14″ ERROR 1238 (HY000): Variable ‘gtid_executed’ is a read only… SET because is a read only variable. The only way to change it is with reset master (yes, on a slave server): slave1> reset master…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…read_ahead_thresholdblogpercona.commanual innodb_read_io_threadsblogpercona.commanual innodb_replication_delayblogpercona.commanual innodb_rollback_on…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
…MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication…on the Slave. Filtering on the Slave is normally preferred as in this case you get full binary log on the Master which is not only… stop reading documentation, specify databases they want to replicate (or ignore…
Post: Getting use of Slave in MySQL Replication
February 14, 2007 By 15 Comments
MySQL Replication is asynchronous which causes problems if you would like to use MySQL Slave as…heavy queries on the master which not take time to replicate to the slave replication lag …slaves from the reads if lag is high or adjust behavior to make sure you only read slaves if you can afford reading…
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
…on and off rotation without and complex procedure. Lets now compare it to MySQL Replication based solution. With MySQL Replication…. Not only Failover process for MySQL replication is tricky it can be long – consider slaves lagging … provides – such as it is safe to read and write from any node and …
Post: Percona XtraDB Cluster Feature 2: Multi-Master replication
January 19, 2012 By 22 Comments
… with regular MySQL replication if you…on the node, and only on COMMIT there is special handling. When you issue COMMIT, your transaction has to pass certification on…reads=ON. In this case the read on the slave will wait until event is applied (this however will increase the response time of the read…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… performance. In the large databases I run in production relaying on MySQL Replication for HA I often have 15+ minutes reply of Innodb… be hot on the slave which is doing reads but only last few hours will be hot on the standby box. Running two instances on the… at least for reads no transaction loss and automated fail over. Whenever you’re using MySQL Cluster, DRBD or MySQL Replication you have to…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
…Slave(s) If you want to minimize downtime it is best to use MySQL Replication for upgrade. Once you have setup slave…MySQL only fully support slaves newer than the master. Older slaves may have issues unable to interpret new replication…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
…MySQL replication latency — or better yet, call it data propagation latency. It was interesting to see whenever I can get stale data reads… only delay data propagation but can stall updates done to the different tables on …3 #wsrep_cluster_address=gcomm:// wsrep_slave_threads=8 wsrep_sst_method=…
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 read and writes run data… mistake on the master. Conclusion We can improve the security and availability of our infrastructure using delayed replication slave. Is useful not only for…
