…@yves-laptop:~$ export EC2_PRIVATE_KEY=pk-yves.pem yves@yves-laptop:~$ ec2-add-group hamysql -d ‘nodes for HA MySQL solution’ GROUP hamysql nodes for HA MySQL solution From now, I’ll always assume the EC2_CERT and EC2_PRIVATE_KEY…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
… of these two approaches to hosting MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn’t always… 5.1′s performance with the combination of stock MySQL 5.1, EC2, and a 10-volume EBS RAID. However, I was… is that there is not a huge performance difference between EC2+EBS+MySQL versus RDS, in most cases, unless you use Percona…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
… been working for a customer benchmarking insert performance on Amazon EC2, and I have some interesting results that I wanted to… software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for…, so that was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned…
Post: High availability for MySQL on Amazon EC2 - Part 1 - Intro
June 17, 2010 By 8 Comments
… easy to have a truly highly available solution for MySQL on EC2. If a MySQL instance fails, here are some challenges that we… me if I could build a viable HA solution for MySQL on EC2. The goal is to have a cheap small instance… Part 5 – The instance monitoring script Part 6 – Publishing the MySQL server location Part 7 – Pitfalls to avoid Hopefully, I should…
Post: Three key things to know about moving MySQL into the cloud.
July 13, 2009 By 11 Comments
…” gets asked often enough. If by cloud you mean Amazon EC2, then from a technical perspective there isn’t much that… for the application to connect to the current master. With EC2, you can’t do this. There’s no customization of… software RAID striping the internal disks on an extra large EC2 instance or using striped EBS volumes is still going to…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 14 Comments
… environment, I noticed that IO performance on EBS volume in EC2 cloud is not quite perfect. So I have spent some… is that if you are looking for IO performance in EC2/EBS environment it’s definitely worth to consider some RAID… get benefit from multi-threading IO in MySQL you need to use XtraDB or MySQL 5.4 ® However there may be small…
Post: High availability for MySQL on Amazon EC2 – Part 3 – Configuring the HA resources
July 12, 2010 By 4 Comments
… the previous of this series, we now have two working EC2 instances that are EBS based. The first instance is the… Give away the resources On hamysql Run MySQL Monitor MySQL Get out of way if MySQL is not running From the above requirements… crm(live)configure# primitive mysql ocf:heartbeat:anything \ params binfile=”/usr/local/bin/mysql” pidfile=”/var/run/heartbeat/mysql.pid” \ op start interval…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… Remote DBA? We have these major components: Percona XtraBackup for MySQL for binary backups mydumper for logical backups mysqlbinlog 5.6…, load them there periodically. You can also spin up an EC2 instance to load your backups onto. In addition, you can… retention dailies weeklies, long term backups Decompressing Percona XtraBackup for MySQL in parallel using all your resources available Downloading from s3…
Post: Sharing an auto_increment value across multiple MySQL tables (revisited)
October 26, 2010 By 7 Comments
… I blogged about Sharing an auto_increment value across multiple MySQL tables. In the comments, a few people wrote in to… got around to benchmarking those alternatives today across two large EC2 machines: (Measured in transactions/second – higher is better) What is… not too dissimilar from the Flickr solution, but uses a MySQL stored function. Full Disclosure.
Post: Create 3 nodes XtraDB Cluster in 3 minutes
January 12, 2012 By 1 Comment
… set of scripts which setup N nodes cluster on running EC2 instances. The script assumes that you have running N EC2 instances (in the same availability zone) running RedHat Enterprise Linux …
