This is not necessarily going to be a comprehensive post, but I learned somethings about MySQL SSL today that I thought would be worth sharing. I was setting up a PRM install for a customer and one of the requirements was SSL replication. In this particular case, I had setup PRM first, and then was [...]
Percona Live MySQL Conference and Expo 2013 – News from the Committee – Part 1
November 8, 2012 By Leave a Comment
I was honored to be asked to be a member of the committee for the “big” MySQL conference: Percona Live MySQL Conference and Expo 2013 in Santa Clara, CA. Personally, I’ve been attending this conference for 6 or 7 years and missing it only when my wife was pregnant with a due date in April [...]
Webinar: The Hazards of Multi-writing in a Dual-Master Setup
November 5, 2012 By Leave a Comment
On November 15th at 1PM Eastern / 10 AM Pacific, I will be giving a webinar entitled “The Hazards of Multi-writing in a Dual-Master Setup“. In my experience many people do not understand the difficulty of managing writes to RDBMS datastores in a high availability environment, especially where asynchronous replication is used (which is almost everywhere). [...]
Minimizing Downtime from Lengthy AWS Outages
October 24, 2012 By 6 Comments
Well, it happened again… Another lengthy EBS outage in the US-East region impacted several sites across the net. While failures like this are rare, they can be quite costly and translate into headaches for the operations team when impact production systems for any length of time. At Percona, we routinely help clients architect and deploy [...]
Upcoming webinar on PRM
September 20, 2012 By 2 Comments
Just a reminder that Wednesday the 26th at 10am Pacific time, I’ll give a webinar on PRM, the Percona replication manager. During the webinar, I’ll walk you through the setup of a PRM cluster and show you how to perform some basic management tasks. If you are interested, click here to register. See you Wednesday! [...]
What attendees are saying about Percona Live NYC ?
September 19, 2012 By Leave a Comment
With Percona Live NYC right around the corner I decide some of attendees what did they like on the last year event and what they are looking forward to in 2012. Here are some responses I got. If you’ve attended in 2011 or planning to join us in 2012 please feel free to comment with [...]
Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
Just yesterday I wrote about math of automatic failover today I’ll share my thoughts about what makes MySQL failover different from many other components and why asynchronous nature of standard replication solution is causing problems with it. Lets first think about properties of simple components we fail over – web servers, application servers etc. We [...]
The Math of Automated Failover
September 18, 2012 By 9 Comments
There are number of people recently blogging about MySQL automated failover, based on production incident which GitHub disclosed. Here is my take on it. When we look at systems providing high availability we can identify 2 cases of system breaking down. First is when the system itself has a bug or limitations which does not [...]
Announcing Percona Playback 0.4 (now with packages!)
September 13, 2012 By 7 Comments
We are glad to announce the availability of Percona Playback 0.4, the first release where we’ve released binary packages alongside our source release. Binary packages for RHEL/CentOS 6 are available with Debian/Ubuntu packages soon to come (we are ensuring our dependencies are correct before publishing). Packages and source may be downloaded from here and are available [...]
How to lag a slave behind to avoid a disaster
September 11, 2012 By 5 Comments
MySQL Replication is useful and easy to setup. It is used for very different purposes. For example: split read and writes run data mining or reporting processes on them disaster recovery Is important to mention that a replication server is not a backup by itself. A mistake on the master, for example a DROP DATABASE [...]
