… compatibility between version and so you can run MySQL 5.0 database with MySQL 5.1 with no problems in most cases…, such as DECIMAL field got whole another meaning in MySQL 5.0 MySQL generally supports legacy storage format for a while, even… quickly. This especially makes sense for cloud environments as Amazon EC2 where it is easy and inexpensive to temporary get extra…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
…@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: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 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: 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 13 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: 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 …
Post: Distributed set processing performance analysis with ICE 3.5.2pl1 at 20 nodes.
May 14, 2011 By Leave a Comment
… number of nodes that I am allowed to create in EC2. I can test further on our 32 core system, but… a slight performance oddity at 16 nodes. I suspect the EC2 environment is the reason for this, but it requires further…
