by Yves Trudeau | Oct 22, 2010 | Cloud, Insight for DBAs, MySQL
This post is the fifth of a series that started here. From the previous posts of this series, we now have an instance restart script that can restart the database node in case of failure and automatically reconfigure Pacemaker and the other servers that needs to...
by Yves Trudeau | Aug 19, 2010 | Insight for DBAs, MySQL
This post is the fourth of a series that started here. From the previous of this series, we now have resources configured but instead of starting MySQL, Pacemaker invokes a script to start (or restart) the EC2 instance running MySQL. This blog post describes the...
by Yves Trudeau | Jul 12, 2010 | Insight for DBAs, MySQL
This post is the third of a series that started here. From the previous of this series, we now have two working EC2 instances that are EBS based. The first instance is the monitor, usually an m1.small type instance and the second instance is hamysql, a large instance...
by Yves Trudeau | Jun 29, 2010 | Insight for DBAs, MySQL
This post is the second of a series that started here. The first step to build the HA solution is to create two working instances, configure them to be EBS based and create a security group for them. A third instance, the client, will be discussed in part 7. Since...
by Yves Trudeau | Jun 17, 2010 | Insight for DBAs, MySQL
Like many, I have been seduced by the power and flexibility of Amazon EC2. Being able to launch new instances at will depending on the load, is almost too good to be true. Amazon has also some drawbacks, availability is not guaranteed and discovery protocols relying...
by Yves Trudeau | May 19, 2010 | Insight for DBAs, MySQL
Customers have always asked me to make NDB Cluster starts automatically upon startup of the servers. For the ones who know NDB Cluster, it is tricky to make it starts automatically. I know at least 2 sets of scripts to manage NDB startup, ndb-initializer and from...
by Justin Swanhart | May 6, 2010 | Insight for DBAs, MySQL
MySQL 5.1 introduces row-based binary logging. In fact, the default binary logging format in GA versions of MySQL 5.1 is ‘MIXED’ STATEMENT*; The binlog_format variable can still be changed per sessions which means it is possible that some of your binary...
by Yves Trudeau | Nov 13, 2009 | Insight for DBAs, MySQL
In the last 2 blog posts about High Availability for MySQL we have introduced definitions and provided a list of ( questions that you need to ask yourself before choosing a HA solution. In this new post, we will cover what is the most popular HA solution for MySQL,...
by Vadim Tkachenko | Oct 27, 2009 | Insight for DBAs, MySQL
First time I heard about Galera on Percona Performance Conference 2009, Seppo Jaakola was presenting “Galera: Multi-Master Synchronous MySQL Replication Clusters”. It was impressed as I personally always wanted it for InnoDB, but we had it in plans at the...
by Yves Trudeau | Oct 16, 2009 | Insight for DBAs, MySQL
After having reviewed the definition my the previous post (The definitions), the next step is to respond to some questions. Do you need MySQL High-Availability? That question is quite obvious but some times, it is skipped. It can also be formulated “What is the...
by Yves Trudeau | Oct 9, 2009 | Insight for DBAs, MySQL
As my first contribution to the MySQL Performance Blog, I joined Percona at the beginning September, I chose to cover the various high-availability (HA) options available for MySQL. I have done dozen of MySQL HA related engagements while working for Sun/MySQL over...
by Morgan Tocker | Jul 7, 2009 | Insight for DBAs
It seems pretty common to find customers install DRBD for the wrong reasons. There are many pros/cons to compare DRBD to replication, but I’ve managed to cut down my spiel I give to customers to these two points: DRBD’s aim (assuming replication mode C) is...
by Morgan Tocker | Mar 10, 2009 | Percona Events
Percona presented two talks at PHP Quebec last week – one on A Tour of MySQL High Availability, and another on Performance Tuning MySQL. There was a great reaction to showcasing some of the quick-wins that can be found by using the Percona patches....
by Baron Schwartz | Feb 1, 2009 | Insight for DBAs
One of my favorite MySQL configurations for high availability is master-master replication, which is just like normal master-slave replication except that you can fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this is probably...
