… key aspects of synchronous replication setup with high-availability guarantees like split-brain immunity. Nobody likes to debug async replication while its broken… simple and uncomplicated. Their post focuses on following aspects: Initial setup Setup of other nodes with SST (Xtrabackup SST) Integration of chef…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… than with file-based replication. We will see how to change the replication topology when using GTID-based replication. That will show where… one here. Our goal will be to go from setup #1 to setup #2 on the picture below, following various scenarios: For… with GTIDs, you cannot totally forget old-style replication positioning. Conclusion Reconfiguring replication when using GTIDs is usually straightforward: just connect the…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… enabling GTIDs on a production setup. The manual describes very nicely how to switch to GTID-based replication, I won’t repeat… This procedure will switch all your servers from regular replication to GTID replication. But if you are running a production system, you…. Second try: GTIDs enabled, mixing regular replication and GTID replication This time, we will enable GTID replication on slave #1, but not on…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
If you are using Percona Replication Manager (PRM) with RHEL/CentOS prior to 6.4, upgrading … been disabled at boot… [ OK ] Checking Network Manager… [ OK ] Global setup… [ OK ] Loading kernel modules… [ OK ] Mounting configfs… [ OK ] Starting cman… been disabled at boot… [ OK ] Checking Network Manager… [ OK ] Global setup… [ OK ] Loading kernel modules… [ OK ] Mounting configfs… [ OK ] Starting cman…
Comment: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 13, 2013 By 5 Comments
… to doing a stop slave/start slave in traditional mysql replication setups?
Post: My Sessions at Percona Live MySQL Conference and Expo 2013
April 1, 2013 By Leave a Comment
… setup This talks covers the basics of why multi-writing multi-master architectures without a replication technology that somehow prevents or handles replication… considered an architecture that uses standard MySQL async replication with any kind of circular replication and multi-node simultaneous writing, you should…
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
… (bugs 1090145, 1102687) * Added UTC option to pmp-check-mysql-replication-delay to be compatible with pt-hearbeat 2.1.8… error on directory permissions issue (bug 1024001) * pmp-check-mysql-replication-running reported OK when a slave is in “Connecting” state… addition as part of Percona’s Remote DBA installation and setup of these tools are included with our services. You can…
Post: Why audit logging with triggers in MySQL is bad for replication
September 29, 2008 By 10 Comments
… with investigating slippage between master and slave in a standard replication setup. The client was using Maatkit’s mk-table-checksum to… –algorithm=BIT_XOR h=hostname.local,u=root,p=xxx –replicate=checksum.checksum –emptyrepltbl –chunksize=500000 –databases mydb –sleep 1 He…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…”, master_log_pos=401934686; 12) Run SLAVE START to restart replication. With slightly modified process you can clone slaves from the…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… sanity check on existing replication setup. As we’re checking replication consistency down the road we need to make sure replication is in sync… I frequently see forgotten Next step is setup MySQL 5.0 to 5.1 replication to see if it runs properly. It… this point we were sure the write traffic replicates properly to the new setup. It was the time to check how read…
