by Jay Janssen | Nov 14, 2014 | Insight for DBAs, MySQL, Percona Software
Thanks to all who attended my Nov. 12 webinar titled, “Percona XtraDB Cluster as a MySQL HA Solution for OpenStack.” I had several questions which I covered at the end and a few that I didn’t. You can view the entire webinar and download the slides...
by Stephane Combaudon | Oct 7, 2014 | Insight for DBAs, MySQL, Percona Services
I’ve recently worked with customers using replication rings with 4+ servers; several servers accepting writes. The idea behind this design is always the same: by having multiple servers, you get high availability and by having multiple writer nodes, you get...
by Yves Trudeau | Sep 11, 2014 | Insight for DBAs, MySQL, Percona Software, Webinars
I’ll have the pleasure to present, next Wednesday, September 17 at 10 a.m. PDT (1 p.m. EDT) a webinar titled “OpenStack: A MySQL DBA Perspective.” Everyone is invited. The webinar will be divided into two parts. The first part will cover how MySQL...
by Fernando Ipar | Aug 4, 2014 | Insight for DBAs, MySQL, Webinars
Martin Arrieta and I gave an online presentation last week on “Putting MySQL Fabric To Use.” If you missed it, you can find a recording and the slides here, and the vagrant environment we used plus a transcript of the commands we ran here (be sure to check...
by Fernando Ipar | Jul 24, 2014 | MySQL, Webinars
Martin and I have recently been blogging together about MySQL Fabric (in case you’ve missed this, you can find the first post of the series here), and on July 30th, we’re going to be presenting a webinar on this topic titled “Putting MySQL Fabric to...
by Jervin Real | Jul 16, 2014 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
This is the second part of my series on High Availability with mysqlnd_ms. In my first post, “Simple MySQL Master HA with mysqlnd_ms,” I showed a simple HA solution using asynchronous MySQL replication. This time we will see how to leverage an all-primary...
by Jervin Real | Jul 14, 2014 | Insight for Developers, MySQL
I had the pleasure of presenting to the PHP Users Group Philippines a few days ago about mysqlnd_ms. The mysqlnd plugin, MySQL Master Slave, is a transparent layer on top of mysqlnd extension. This allows you to do read-write splitting and slave reads load balancing...
by Fernando Ipar | May 30, 2014 | Insight for DBAs, MySQL
This is the third post in our MySQL Fabric series. If you missed the previous two, we started with an overall introduction, and then a discussion of MySQL Fabric’s high-availability (HA) features. MySQL Fabric was RC when we started this series, but it went GA...
by Martin Arrieta | May 15, 2014 | Insight for DBAs, MySQL
In our previous post, we introduced the MySQL Fabric utility and said we would dig deeper into it. This post is the first part of our test of MySQL Fabric’s High Availability (HA) functionality. Today, we’ll review MySQL Fabric’s HA concepts, and...
by Fernando Ipar | Apr 25, 2014 | Insight for DBAs, Insight for Developers, MySQL
While built-in replication has been a major cause for MySQL’s wide adoption, official tools to help DBAs manage replication topologies have typically been missing from the picture. The community has produced many good products to fill in this gap, but recently,...
by Tom Diederich | Mar 3, 2014 | Insight for DBAs, Insight for Developers, MySQL, Percona Live
MySQL Fabric is an integrated framework for managing farms of MySQL servers with support for both high-availability and sharding. Its development has been spearheaded by Mats Kindahl, senior principal software developer in MySQL at Oracle. Mats is leading the MySQL...
by Yves Trudeau | Jan 10, 2014 | Insight for DBAs, MySQL, Percona Software
Most technologies achieving high-availability for MySQL need a load-balancer to spread the client connections to a valid database host, even the Tungsten special connector can be seen as a sophisticated load-balancer. People often use hardware load balancer or...
by Yves Trudeau | Dec 10, 2013 | Insight for DBAs, MySQL
My December 4 webinar, “Geographical disaster recovery with Percona Replication Manager (PRM),” gave rise to a few questions. The recording of the webinar and the slides are available Percona Gold or Platinum Support contract. It is not availabe with...
by Yves Trudeau | Oct 23, 2013 | Insight for DBAs, MySQL, Percona Software
The technologies allowing to build highly-available (HA) MySQL solutions are in constant evolution and they cover very different needs and use cases. In order to help people choose the best HA solution for their needs, we decided, Jay Janssen and I, to publish, on a...
by Przemysław Malkowski | Jul 5, 2013 | Insight for DBAs, MySQL
Among many of the improvements you can enjoy in MySQL 5.6, there is one that addresses a huge operational problem that most DBAs and System Administrators encounter in their life: schema changes. While it is usually not a problem for small tables or those in early...
by Ernie Souhrada | Jun 7, 2013 | Insight for DBAs, Insight for Developers, MySQL, Webinars
Thanks to everyone who was in attendance on 05 June 2013 for my “Choosing a MySQL HA Solution” webinar. If you weren’t able to make it but are interested in listening to the presentation, it’s currently up and available for viewing over at...
by Ernie Souhrada | May 28, 2013 | Insight for DBAs, MySQL, Percona Events, Webinars
Selecting the most appropriate solution for a MySQL HA infrastructure is as much a business and philosophical decision as it is a technical one, but often the choice is made without adequately considering all three perspectives. When too much attention is paid to one...
by Yves Trudeau | Apr 19, 2013 | Hardware and Storage, Insight for DBAs, MySQL
Swapping has always been something bad for MySQL performance but it is even more important for HA systems. It is so important to avoid swapping with HA that NDB cluster basically forbids calling malloc after the startup phase and hence its rather complex...
by Yves Trudeau | Feb 15, 2011 | Cloud, MySQL
This post is the fifth of a series that started here. From the previous posts of this series, we now have nearly everything setup, only a few pieces are missing. One of the missing pieces is the Pacemaker script that run on the MySQL instance. First, this script is...
by Vadim Tkachenko | Nov 29, 2010 | Hardware and Storage, MySQL
Working with customer, I faced pretty nasty bug, which is actually not rare situation , but in this particular there are some lessons I would like to share. The case is pretty much described in bug 55981, or in pastebin. Everything below is related to...
