…slaves to master and knowing that mysql does not have a way match the transactions as ‘global transactions id’.I agree that matching logs is…how about ‘row based replication‘ ? i think it can help.Or may be its a dumb idea but still throwing. if…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
…is enough for one statement to get stuck to have all replication stalled. Long Queries – MySQL Replication executes queries one after another on the slave, so if…to know how to measure replication lag – MySQL…
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…slave-find, ages ago before I even worked at Percona). It automatically detects and connects to every server in the replication…to know — if…
Post: How Does Semisynchronous MySQL Replication Work?
January 19, 2012 By 23 Comments
…MySQL‘s semi-synchronous replication. I find that there are often a number of misconceptions about how semi-synchronous replication really works. I think it is…slave). If the master commits but a crash occurs while the master is waiting for acknowledgment from a slave, it is…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
…to know if MySQL is already running. It should match the my.cnf pid_file setting. socket: The MySQL unix socket file replication_user: The user to…slave” for a saner behavior. One of the important setting is “log_slave_updates = OFF” (default value). In some cases, if slaves are logging replication…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
…to know about partial replication – you can do filtering on the Master or on the Slave. Filtering on the Slave is…MySQL Replication there are things to be careful with, so if you’re considering to…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…MySQL Replication. To explain what they are, how to identify them… and how to fix them. An infinite replication loop is one or more transactions that are replicating…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
… If you want to maintain the consistency of your data is necessary to define the same Triggers in Master and Slave servers. Example: mysql… 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: Actively monitoring replication connectivity with MySQL's heartbeat
December 29, 2011 By 1 Comment
…Slave_received_heartbeats | 1476 | +—————————+——-+ Conclusion If you need to know when exactly the connection between your Master/Slaves breaks then replication‘s heartbeat is…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
…MySQL for scale out. Most of the companies would have some internal scripts to handle things as automatic fallback and slave… tool do and how it works ? Currently it is implemented based on …know if slave server reboots (say power goes down) you can’t be sure about data consistency because replication…
