A while ago I wrote about how to make MySQL replication reliable, part of which is to eliminate temporary tables. The idea is this: if… went into the binlog individually, there’s clearly an opportunity to break replication here. It looks like this doesn’t avoid the problem… any way to use temporary tables with MySQL statement-based replication without some risk of breaking slaves. At some point I may test how it…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
… traditional pre MySQL 5.0 way to break such replication is also using multi-table update or delete statements, if you happen to replicate one table… to avoid, but it is still remains a way how one can break filtered replication by executing some statements on the master. Even though replicate…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
… your MySQL replication hierarchy? We have, too. As consultants, a lot of times we need to get a quick overview of the whole replication hierarchy and specific things about it, such as replication filters, versions, whether replication is running, how far behind it is, and so on. These things are very important for making sure that we don’t break something…
Post: Actively monitoring replication connectivity with MySQL's heartbeat
December 29, 2011 By Leave a Comment
… communication. How can I configure replication‘s heartbeat? Is very easy to setup with negligible overhead: mysql_slave > STOP SLAVE; mysql_slave > CHANGE MASTER TO MASTER… to note that having a 5.5 slave with replication‘s heartbeat enabled and connected to a 5.1 master doesn’t break the replication… or how to send it 
What status variables do I have? The heartbeat check period time and the number of beats received. mysql…
Post: MongoDB Approach to Availability
April 30, 2010 By 2 Comments
…of applications. In fact using MySQL Replication for failover we’re …to stabilize as well as later develop tools around them. How to check if 2 MongoDB nodes are indeed in sync ? How to…replication breaking if time on master server is changed (MongoDB uses timestamps to identify events in replication…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
… is how far MySQL may fall behind and how to keep replication from lagging. The lag you will see will vary a lot from application to… Slow Query Log patch. You may also interested to know how to measure replication lag – MySQL Toolkit has a great tool for real latency measurement… break is very good idea. Especially it will be handy when you will be reaching replication capacity and will need to buy time to…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
… all your servers you will break your replication and the SQL process will stop with an error. Example: mysql> CREATE FUNCTION this_year… to take in account when we are working with statement based replication. Knowing in advances how MySQL works internally can help us to improve our replication…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… DRBD goes on par with MySQL Statement Based Replication – it is also well too easy to use MySQL features which break replication. The failover node is… you’re looking to ensured consistency – MySQL Replication can out of sync – and there is bunch of tips in documentation of how to do it…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
…MySQL, replication. High Availability solution for MySQL: Replication This HA solution is the easiest to implement and to manage. You basically need to setup MySQL replication…MySQL replication link between the servers. Replication often break for various reasons and while replication…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
…to a level where we started looking at other ways of achieving higher availability using MySQL replication…to be only slaves or less likely to become master A node can be the preferred master If replication on a slave breaks…slave “ms” declaration. This is how Pacemaker defines an asymmetrical …
