… heard about Percona Replication Manager (PRM), a new high availability tool for MySQL. Percona Live DC 2012 Percona Live MySQL Conference & Expo 2012… / Pacemaker that take cares of MySQL and manages the replication. Corosync allows any number of servers to be part of the cluster using… with Vagrant). In the follow “terminalcast” you can see how to deploy the setup and some basic commands to check and manage your cluster:
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… easy and affordable for everyone. You can convert your existing MySQL replication setup into a cluster in just a couple minutes. Tomorrow, 4… explain what Percona XtraDB Cluster is and how does it work, you still have time to register today. I expect XtraDB Cluster… chance 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
… these setup Percona XtraDB Server is used (but it can be any other MySQL version using standard replication). PRM works with “normal” MySQL acting… similar to this setup. I know Yves 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…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…mysql-replication-running checks that replication is functioning correctly. Replicas have different data than their master. In addition to delay or failure, replication…. It is surprising how often a server crashes…to assist. In addition, please ask our sales staff to include a free monitoring setup…
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… a look first at the normal flow: Replication flow: [1] When you setup MySQL replication, you define the global variable server_id, …
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…MySQL EC2 setups suffer from lacking a good HA schema. With Galera, we can setup replication…to setup three node cluster is much more complex than an average MySQL master-slave setup. Potential performance penalty: Although to…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
…for 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 …while replication is broken, there is no High-Availability. Also, the availability of this solution is affected by how …
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
…-Master setup is often cause of the problem for similar reason as MySQL Restart -…to check the types and frequencies of queries but also how much IO they are causing and how…to catch up. MySQL or OS version changesMySQL version changes (even minor upgrade) may introduce issues which causes replication…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… path than 4.1 to 5.1 just because so much more people have followed that road. So how do people approach… want to minimize downtime it is best to use MySQL Replication for upgrade. Once you have setup slave with new version and made it to caught up you can use mk-table-checksum to…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…How to determine which MySQL High-Availability solution is best? What is really tricky with MySQL…to the servers is the preferred way, especially for the most complex solutions. Proof of concept Migration to Production MySQL replication…
