…. Requires m1.large or larger. ami-f65ea19f shard-query-infobright-demo i686 ICE 3.5.2pl1 32bit. Requires m1.small or greater… RLE, I doubt it will have the same impact. For large datasets effective compression results in the need for fewer nodes… set up the hosts file: sudo su – # cat hosts.internal | ~ec2-user/tools/mkhosts >> /etc/hosts # ping shard20 PING shard20 (10…
Post: High availability for MySQL on Amazon EC2 - Part 1 - Intro
June 17, 2010 By 8 Comments
… have been seduced by the power and flexibility of Amazon EC2. Being able to launch new instances at will depending on… solution for MySQL on EC2. The goal is to have a cheap small instance monitor the availability of a large (any size) and… Heartbeat. The setup is fairly complex, being in the Amazon EC2 virtual world is not a simplification, far from. Because of…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 14 Comments
…, I noticed that IO performance on EBS volume in EC2 cloud is not quite perfect. So I have spent … volumes. So I created 4 volumes ( I used m.large instance), and made: RAID0 on 2 volumes as: mdadm -… XtraDB or MySQL 5.4 ® However there may be small problem with backup over EBS. On single EBS volume …
Post: High availability for MySQL on Amazon EC2 – Part 3 – Configuring the HA resources
July 12, 2010 By 4 Comments
… 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 type. So far, we…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 55 Comments
…, running in the Amazon cloud. It’s a quadruple extra large EC2 server (currently priced at $2/hour for a non-reserved… per second of writes, but the performance (latency) is both large and variable even though the devices are idle most of… fight between the EBS gang and the SSD thugs, a small number of SSDs mops the floor with the competition, and…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… to work with single core systems and relatively small memory amounts, both of which are things of … I believe it can be done for rather large set of applications. Many applications in MySQL … might be limited especially in constrained environments as EC2. We could implement API which would allow one …
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
… a lot of tables. And they’re running on Amazon EC2 with 8G of RAM and EBS storage, which is slower…) and so we can’t make the buffer pool as large as we’d like to. To avoid physical I/O… working set and will stay in the buffer pool, some small part of it will move in and out of the…
