… effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’…semi-sync is: [On a semi-sync replication master] you can’t commit (at all) …. WANs usually have anywhere from a few ms up to several hundred. This really …
Post: How expensive is MySQL Replication for the Master
January 16, 2010 By 13 Comments
… about MySQL replication as being quite low overhead on Master, depending on number of Slaves. What kind of…interrupts they get and process several packets at the time we could make replication threads to be …large amount of slaves the delay from the event executed on the master to last thread sends …
Post: Minimizing Downtime from Lengthy AWS Outages
October 24, 2012 By 7 Comments
…High Level) The Amazon Web Services infrastructure contains several individual components that can be combined … another instance and simply fire up MySQL. This works wonderfully unless EBS is … Multi Region Replication The easiest approach would be to use native replication from a master to a slave …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… one of MySQL‘s log or data files from disk…. pmp-check-mysql-innodb plugin checks for several indicators of severe internal problems…mysql-replication-running checks that replication is functioning correctly. Replicas have different data than their master. In addition to delay or failure, replication…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… CPU usage and the replication lag… once again cacti is very helpful ! How to fix then ? There are several possibilities to fix… replication on the active master (server 1): mysql> stop slave; Step 2: there are writes on the active master, the loop statements are also replicated from…
Post: Percona XtraDB Cluster Feature 2: Multi-Master replication
January 19, 2012 By 22 Comments
…, as it regularly happens with regular MySQL replication if you imprudently write to the wrong…from master. This happens because the master may apply event faster than a slave. And if you do read from…to use Multi-Master capabilities of XtraDB Cluster, and run write transactions on several nodes, …
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
…replication from lagging. The lag you will see will vary a lot from application to the application and from…there will be rare cases when replication lags behind several seconds or even longer. There …so Master is almost fully busy handling the writes. This is not the case – because MySQL Replication…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
…documents about that: http://dev.mysql.com/doc/refman/5.6/en/replication-gtids-concepts.html One …a backup from the master and restore it on the slave to set up a new replication server. master > show…slave has been down for several days and the binary logs from the master have been purged. This is…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication itself and getting things right… logs from the master, filter out only what you need replicated and pass it to the group of slaves. If you have several group… can see no matter which road you take with partial MySQL Replication there are things to be careful with, so if you…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… we can setup distributed replication systems with masters in different data centers. This provides a HA solution for MySQL setups in the Cloud… current state of MySQL EC2 setups suffer from lacking a good HA schema. With Galera, we can setup replication with the same availability…. Scaling Writes. From benchmarks provided by the Galera team we may see a good scaling of throughput writing to several nodes As…
