… more about MySQL buffer pools or anything else that’s on your mind! There are numerous solutions for MySQL high availability. Many rely on MySQL’s… catch that? What does that mean? In most of these high-availability solutions it means that mysqld is running on the standby server…_server:3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin…
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
…for MySQL — high-quality components to add enterprise-grade MySQL monitoring and graphing capabilities to your existing in-house, on-premises monitoring solutions. … graphs need to be recreated: MySQL “MySQL Threads”, Linux “Network Traffic”. A new tarball is available from downloads area or RPM …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… (PXC) and mostly they are interested in PXC as a high-availability solution. But, what they tend not to think too much about… no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually… to the tradeoffs we take when deploying conventional stand-alone MySQL Innodb with asynchronous slaves. We may not think about the…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… step is to respond to some questions. Do you need MySQL High-Availability? That question is quite obvious but some times, it is…! How to determine which MySQL High-Availability solution is best? What is really tricky with MySQL is the number of possible HA solutions. From the simplest…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… HA solution. In this new post, we will cover what is the most popular HA solution 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…
Post: Finding your MySQL High-Availability solution - The definitions
October 9, 2009 By 10 Comments
…the various high-availability (HA) options available for MySQL. I have done dozen of MySQL HA related engagements while working for Sun/MySQL over the… also needed to insure a successful solution. In other words, no solution is fool proof, if a high-availability solution is running in recovery mode…
Post: High Availability Deep Dive tutorial at PLMCE
April 6, 2012 By Leave a Comment
… rebroadcast of Florian’s post) If you are interested by High availability solution with MySQL, Florian Haas from and myself myself will be co… as we walk you through several deployment scenarios for Pacemaker MySQL high availability. We’re coming with pre-installed virtual machine images for…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
… where we started looking at other ways of achieving higher availability using MySQL replication. One of the weakness of MMM is its… this solution PRM for Percona Replication Manager. All the parts are opensource and available under the GPL license. Keep in mind this solution… IP=”10.2.2.162″ primitive p_mysql ocf:heartbeat:mysql \ params config=”/etc/mysql/my.cnf” pid=”/var/run/mysqld/mysqld.pid…
Post: High availability for MySQL on Amazon EC2 - Part 1 - Intro
June 17, 2010 By 8 Comments
…, it is not easy to have a truly highly available solution for MySQL on EC2. If a MySQL instance fails, here are some challenges that… a viable HA solution for MySQL on EC2. The goal is to have a cheap small instance monitor the availability of a large (any size) and taking measures to keep MySQL available. A few weeks later, I ended up with a solution…
Post: Percona XtraDB Cluster Feature 1: High Availability
January 17, 2012 By 20 Comments
…of Percona XtraDB Cluster. The first feature is High Availability. But before jumping to HA, let’s review… point is that you can convert your existing MySQL / Percona Server into Node and roll Cluster …’t be used as an effective write scaling solution. There might be some improvements in write …
