… NIC.] The other two NIC ports should be bonded with active-backup or LACP (depending on your switching infrastructure). In essence… set up replication filters on the slave, as described in the MySQL manual. You can configure the slave to only replicate a specific…-based replication, it looks like you’ll need to wait for the next release of MHA. Q: How do you monitor MySQL…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… Replication Manager (PRM) with RHEL/CentOS prior …monitors the names and number of active cluster nodes in order to deliver…MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… MySQL high availability. Many rely on MySQL’s asynchronous replication to maintain a warm standby server which is flipped into service if the active… active server. wget -q -O – http://master_server:3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
…exciting alternative to traditional MySQL replication. For those who don’t know, it gives you: Fully Synchronous replication with a … Changed: 1 Warnings: 0 node1 mysql> SHOW ENGINE INNODB STATUS\G … ———— TRANSACTIONS ———— … —TRANSACTION 83B, ACTIVE 50 sec 2 lock struct(s),…
Post: Actively monitoring replication connectivity with MySQL's heartbeat
December 29, 2011 By 2 Comments
… detected at all. We needed an active master/slave connection check. And here is where replication‘s heartbeat can help us. This… actively checking the communication. How can I configure replication‘s heartbeat? Is very easy to setup with negligible overhead: mysql_slave > STOP SLAVE; mysql…
Post: Testing Percona Replication Manager (prm) with Vagrant
April 17, 2012 By 2 Comments
… about Percona Replication Manager (PRM), a new high availability tool for MySQL. Percona Live DC 2012 Percona Live MySQL Conference & Expo …replication. Corosync allows any number of servers to be part of the cluster using any number of fault-tolerant configurations (active/passive, active/active…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… query: mysql> select * from information_schema.user_statistics where user=”#mysql_system#” \G *************************** 1. row *************************** USER: #mysql_system…activity anyway. Using this way you can also measure “cold” vs “hot” replication capacity as well as how long replication…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
… have and how to avoid them. TRIGGERS When a statement activates a Trigger only the original query is logged not the…. So all used variables are replicated on the slave. Example: mysql> SELECT YEAR(CURDATE()) INTO @this_year; mysql> insert into t VALUES(@this… are working with statement based replication. Knowing in advances how MySQL works internally can help us to improve our replication availability and data.
Post: MySQL - to use or not to use
May 28, 2007 By 10 Comments
… too dynamic in development (nothing stops you from starting to actively break old code though). Indeed there are some problems which… as Semi-synchronous replication, advanced Monitoring and scaling features some users need other features than MySQL adding in newer MySQL releases. In other…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… replication master position on the active master to a newer position from the passive master (get position from show master status\G on mysql… 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…
