… 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…
Post: Distributed set processing performance analysis with ICE 3.5.2pl1 at 20 nodes.
May 14, 2011 By Leave a Comment
Post: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… posts comparing Amazon RDS to a server running on Amazon EC2. Upcoming posts (probably 6 or 8 in total) will extend… the results I achieved on this RDS server, from this EC2 “driver” machine, at this specific point in time. There will…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 55 Comments
… in the Amazon cloud. It’s a quadruple extra large EC2 server (currently priced at $2/hour for a non-reserved… up as sky-high latency spikes in New Relic. Suddenly EC2 doesn’t seem like such a good deal for this…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… Cluster (PXC) in a virtualized test sandbox. I used Amazon EC2 micro instances, but the content here is applicable for any… –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password=sbpass –oltp… –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password=sbpass –oltp…
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 8 Comments
… internet connectivity, I fired up an Ubuntu 10.04 EC2 instance, installed MySQL and provided the customer the credentials to upload their…_TABLENAME.ibd /var/lib/mysql/recover/ chown mysql.mysql /var/lib/mysql/recover/$CURRENT_TABLENAME.ibd sleep 1 echo “importing tablespace” mysql -u root -e…
Post: High availability for MySQL on Amazon EC2 - Part 5 - The instance monitoring script
October 22, 2010 By Leave a Comment
… provide a basic functional one that monitor MySQL with the mysqladmin ping command. #!/bin/sh # MySQL basedir passed as argument # mysqladmin must…` if [ $STATUS -ne 1 ]; then # uname -n | /bin/mail -s ” MySQL database down, forcing failover” $EMAIL /etc/init.d/heartbeat stop… on the Monitor node will loop and restart again the MySQL node. Stopping the heartbeat service achieve the desired result without…
Post: High availability for MySQL on Amazon EC2 – Part 5 - The instance monitoring script
February 15, 2011 By 3 Comments
… missing pieces is the Pacemaker script that run on the MySQL instance. First, this script is optional, Pacemaker will accept a… the monitoring instance which will in turn cause the running MySQL instance to be killed and a new one started. Here… possible. #!/bin/bash MYSQLUSER=monitor MYSQLPASS=apassword #Give time for MySQL to start if it need recovery sleep 120 while [ 1…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…, but testing 20 was all I could due to to EC2 and time limits. I think the results at 20 nodes… of compute resource which speaks SQL, but right now only MySQL storage nodes are supported. Amdahl’s law applies to the…
Post: Sharing an auto_increment value across multiple MySQL tables
October 4, 2010 By 9 Comments
… second). To start with a naive test, I booted two EC2 small instances in the same availability zone. Ping times are…
Comment: Three key things to know about moving MySQL into the cloud.
July 28, 2009 By 11 Comments
MySQL on EC2 is not to be taken lightly… with EC2‘s incredible features comes a barrel of quirks. We benchmarked how well MySQL performs on Amazon EC2 and are sharing… post is here: http://www.infibase.com/blog/2009/07/mysql-on-amazon-ec2-part-1/
