… of the missing pieces is the Pacemaker script that run on the MySQL instance. First, this script is optional, Pacemaker will accept… but since we have the opportunity to run a script on the MySQL host, let’s take it. At minimum, let’s… possible. #!/bin/bash MYSQLUSER=monitor MYSQLPASS=apassword #Give time for MySQL to start if it need recovery sleep 120 while [ 1…
Post: High availability for MySQL on Amazon EC2 – Part 5 - The instance monitoring script
February 15, 2011 By 3 Comments
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
… a series of posts showing benchmark results on Amazon EC2 servers with RAID’ed EBS volumes and MySQL, versus RDS machines. For reasons that… MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn’t always great in comparison to what you can get on… to share on that speculation, but for all intents and purposes, it seems valid. However, the versions of MySQL that Amazon runs on RDS…
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… community here. Our first post shares an incredible finding on how Amazon‘s hardware variations can make a significant difference in the… post is here: http://www.infibase.com/blog/2009/07/mysql-on-amazon-ec2-part-1/
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… MySQL version and starting new one. MySQL always was very good maintaining on disk binary compatibility between version and so you can run MySQL… which runs on it may not run well on production until it is upgraded. In case fixing code to run on different MySQL version… back quickly. This especially makes sense for cloud environments as Amazon EC2 where it is easy and inexpensive to temporary get extra…
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: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… InnoDB versions are only available on 64 bit instances. MySQL will fail to start on a micro instance, simply…< /dev/null done; Where to find the images Amazon ID Name Arch Notesami-20b74949 shard-query-…yourself. Spin up the desired number of EC2 instances using on of the the AMI images. You …
Post: How to STOP SLAVE on Amazon RDS read replica
December 20, 2012 By 4 Comments
… migration from Amazon RDS to EC2 with a customer. This, unfortunately, involves some downtime…: Error ‘Duplicate entry ’1′ for key ‘PRIMARY” on query. Default database: ‘percona’. Query: ‘INSERT INTO…the following to resume replication: replica> CALL mysql.rds_skip_repl_error; master> DROP DATABASE …
Post: Three key things to know about moving MySQL into the cloud.
July 13, 2009 By 11 Comments
… cloud” 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…. Both software RAID striping the internal disks on an extra large EC2 instance or using striped EBS volumes is still going…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… XtraDB Cluster (PXC) in a virtualized test sandbox. I used Amazon EC2 micro instances, but the content here is applicable for any… this as a single MySQL server running on localhost. In order to achieve this, we will configure HaProxy on the client node. There… use check MySQL via HTTP. The clustercheck script is a simple shell script, which accepts HTTP requests, and checks MySQL on incoming request…
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
… running MySQL on Debian or Ubuntu with InnoDB? You might want to disable /etc/mysql/debian-start. When you run /etc/init.d/mysql… databases and a lot of tables. And they’re running on Amazon EC2 with 8G of RAM and EBS storage, which is slower… the meanwhile, it’ll interfere with everything else going on. Look what happens: mysql> show processlist; +——+——————+—————-+————- | Id | User | State | Info +——+——————+—————-+————- | 7 | debian…
