…that was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself …, and against the table purchases_index which has 3 secondary indexes. Another thing I would like to…. Now let’s come down to the interesting part. Results With the table purchases_noindex, that has…
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… instances Part 3 – Configuring the HA resources Part 4 – The instance restart script Part 5 – The instance monitoring script Part 6 – Publishing the MySQL server location Part…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
… part 7. Since this will be a proof of concept, I’ll be using m1.small type instances while normally, the mysql… for HA MySQL solution’ GROUP hamysql nodes for HA MySQL solution From now, I’ll always assume the EC2_CERT and EC2_PRIVATE_KEY….net/2009/12/create-ebs-boot-ami.html Upcoming in part 3, the configuration of the HA resources.
Post: High availability for MySQL on Amazon EC2 – Part 4 - The instance restart script
August 19, 2010 By 6 Comments
… the MySQL EC2 instance if running Make sure the MySQL EC2 instance is stopped Prepare the user-data script for the new MySQL EC2 instance Launch… Broadcast the new MySQL instance IP to the application servers Kill the MySQL EC2 instance In order to kill the existing MySQL EC2 instance, we…’|’ -f2` perl -pi -e “s/ucast eth0 (\d+)(\.\d+){3}/ucast eth0 $MYSQL_IP/g” /etc/ha.d/ha.cf /etc/init…
Post: How to replace a NDB node on EC2
June 9, 2011 By 10 Comments
…. In an environment like EC2, where a node can …part, in all hosts. Next the NDB configuration must use the hostname like: [NDBD DEFAULT] NoOfReplicas=2 Datadir=/var/lib/mysql-cluster/ DataMemory=1G IndexMemory=100M [NDB_MGMD] Id=1 Hostname=mgmn1 [NDB_MGMD] Id=2 Hostname=mgmn2 [NDBD] Id=3…
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 on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
…) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 servers with EBS volumes (see… the general usage of AWS as you get on normal EC2 servers with EBS. I benchmarked the largest available RDS instance…: 68 GB of memory, 26 ECUs (8 virtual cores with 3.25 ECUs each), 64-bit platform, High I/O Capacity…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 13 Comments
… volume in EC2 cloud is not quite perfect. So I have spent some time benchmarking volumes. Interesting part with EBS…/sdj /dev/sdk /dev/sdl /dev/sdm RAID5 on 3 volumes as: mdadm -C /dev/md0 –chunk=256 …benefit from multi-threading IO in MySQL you need to use XtraDB or MySQL 5.4 ® However there may be…
Comment: High availability for MySQL on Amazon EC2 – Part 4 - The instance restart script
August 19, 2010 By 6 Comments
If you look in the Pacemaker configuration here:http://www.mysqlperformanceblog.com/2010/07/12/high-availability-for-mysql-on-amazon-ec2-%E2%80%93-part-3-%E2%80%93-configuring-the-ha-resources/ You’ll see that you can define the path. The current config points to /usr/local/bin/mysql.
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
…tables. And they’re running on Amazon EC2 with 8G of RAM and EBS storage,… a lot of tables, InnoDB uses over 3.5G of memory for its data dictionary…stay in the buffer pool, some small part of it will move in and out… declared inside InnoDB 500 mysql tables in use 7, locked 0 MySQL thread id 6424, query…
