… server to the cluster. The “replication_info” config setting is only changed when a new master is elected. So how to add a new slave? Create… the mysql RA uses, which is: crm_attribute –type crm_config –name replication_info -s mysql_replication -v “||” Now start corosync on your slave and…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
March 7, 2012 By 94 Comments
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
…to ask us any questions. Related talks: Tutorial on PL MySQL Conference Galera Synchronous Multi-Master Replication for MySQL. My talk on PL MySQL…
Comment: Testing Percona Replication Manager (prm) with Vagrant
April 17, 2012 By 2 Comments
… be any other MySQL version using standard replication). PRM works with “normal” MySQL acting as Master -> Slaves and in case of the master being evicted (intentionally… plans to look on how to use MHA with PRM. The goal of my approach here it to automate the installation and to allow everybody to…
Comment: Emulating global transaction ID with pt-heartbeat
April 24, 2012 By 6 Comments
Whenever i hear the talk about failover from intermediate slaves to master and knowing that mysql does not have a way match the transactions…’.I agree that matching logs is very tedious but how about ‘row based replication‘ ? i think it can help.Or may be…_master_log_file: test_file , exec_master_log_pos: 2399 ) was replicating from these positions before crashing then we can tell C to start replicating…
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
… later we need to promote a Slave to Master we will need to do some steps to enable all the events replicated from the master because as we… 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: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
… The MySQL unix socket file replication_user: The user to use when setting up replication. It is also currently used for the ‘CHANGE MASTER TO‘ …interesting element is the master-slave “ms” declaration. This is how Pacemaker defines an asymmetrical resource having a master and slaves. The only thing …
Post: Actively monitoring replication connectivity with MySQL's heartbeat
December 29, 2011 By 1 Comment
…Slave_heartbeat_period | 1.000 | | Slave_received_heartbeats | 1476 | +—————————+——-+ Conclusion If you need to know when exactly the connection between your Master/Slaves breaks then replication…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
…Slave Role Changing Slave role, such as swapping active and passive masters in Master-Master…slave never is able to catch up. MySQL or OS version changesMySQL version changes (even minor upgrade) may introduce issues which causes replication…
Post: MongoDB Approach to database synchronization
April 30, 2010 By 4 Comments
… one replication problem and how MongoDB solves it. If you’re using MySQL Replication when your master goes down it is possible for some writes to be executed on the master, but not on the slave, which…
