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 instance restart script. Remember, I am more a DBA than [...]
High availability for MySQL on Amazon EC2 – Part 4 – The instance restart script
August 19, 2010 By 6 Comments
High availability for MySQL on Amazon EC2 – Part 2 – Setting up the initial instances
June 29, 2010 By 9 Comments
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 this will be a proof [...]
XtraDB Amazon Image
October 25, 2009 By 9 Comments
For those who use Amazon EC2 service and were anxious about having XtraDB ready to launch there is a good news. We created a public AMI (Amazon Machine Image) with XtraDB release 8 installed on CentOS 5.3. How to use it. First make sure it is avaiable.
1 2 3 | $ ec2-describe-images ami-4701e22e IMAGE  ami-4701e22e   xtradb/centos-5.3-x86_64.fs.manifest.xml       834362721059   available      public         x86_64 machine $ |
Run it. It is built for x86_64 [...]
Dissection of EC2 / EBS volume
August 7, 2009 By 4 Comments
So during preparation of XtraDB template for EC2 I wanted to understand what IO characteristics we can expect from EBS volume ( I am speaking about single volume, not RAID as in my previous post). Yasufumi did some benchmarks and pointed me on interesting behavior, there seems several level of caching on EBS volume.
EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 14 Comments
During preparation of Percona-XtraDB template to run in RightScale environment, I noticed that IO performance on EBS volume in EC2 cloud is not quite perfect. So I have spent some time benchmarking volumes. Interesting part with EBS volumes is that you see it as device in your OS, so you can easily make software RAID [...]
