0
votes
1answer
48 views

MySQL Replication across two mounts on AWS Amazon Linux

Recently we took advantage of the SSD instance stores available on AWS. While these are great, they obviously get deleted when the instance dies. Obviously the performance of non Provision IOPS is ...
0
votes
1answer
101 views

Single ec2 instance with multiple mySQL databases on separate EBS volumes

I have a single ec2 instance on which I am running multiple separate wordpress sites. I want to store the database for each separate site on it's own mounted ebs volume, so that I can handle the db ...
0
votes
1answer
54 views

Database modularity with EBS volumes

I would like to add modularity to my websites on EC2 instances by encapsulating the site files and the mysql files in their own EBS volumes. The end result that I'm going for is the ability to quickly ...
1
vote
1answer
157 views

High mysql server load, sar output

I have a MySQL Server that should be performing better than it seems to be. We're running ubuntu on a Amazon Cluster Compute (cc1.4xlarge) Linux ip-10-0-1-60 3.2.0-25-virtual #40-Ubuntu SMP Wed May ...
0
votes
0answers
620 views

Mysql failed to Start Ubuntu 12.04 EC2

I followed this http://quarkgluon.com/tutorials/MySQL-on-Ubuntu-Lucid-with-EBS-Drive-EC2/ tutorial to move my existing MySQL installation form root EBS volume to new EBS volume everything just go fine ...
5
votes
2answers
2k views

Running MySQL on Amazon EC2 with EBS (Elastic Block Store) and Elastic Beanstalk

I'm new to Elastic Beanstalk, but I created an environment with a container running 64bit Amazon Linux running PHP 5.3. I want to get MySQL set up on EBS, then install phpMyAdmin and import my ...
2
votes
1answer
260 views

high cancelled_write_bytes

On a MySQL server running on AWS EC2 with an EBS volume iostat returns the following avg-cpu: %user %nice %system %iowait %steal %idle 37.67 0.00 5.26 0.75 0.08 56.24 ...
5
votes
4answers
4k views

High iowait on Amazon EC2 MySQL instance with EBS volume

We have a MySQL server running on an Amazon EC2 c1.medium instance relying on a single EBS volume using the ext3 filesystem for storage. This MySQL server is queried ~500/ps by several applications ...
0
votes
1answer
555 views

Moved mySQL to an EBS volume, now innoDB performs very slowly

Hello has anyone had a similar problem to this.. I've set up a new instance on Amazon EC2 for a client. I've also attached a 250GB EBS volume to hold the files and configured mySQL to use the EBS ...
1
vote
2answers
133 views

LAMP server on AWS running out of HD space. Options?

I have a simple LAMP stack on an EBS Ubuntu instance on AWS EC2. It's been running well for a while now, but I'm now starting to run low on hard disk space. What are my options? I've already ...
7
votes
3answers
2k views

Restoring an Amazon EBS RAID0 array from snapshots taken with ec2-consistent-snapshot

I've configured a new MySQL server on Amazon EC2 and decided to store my data on a EBS RAID0 Array. So far so good, and I've tested taking snapshots of those devices with ec2-consistent-snapshot, ...
0
votes
1answer
355 views

Replicated filesystem and EC2 MySQL

I'm currently investigating migrating our infrastructure over to run on Amazon's EC2 and am trying to figure out the best way to set up a MySQL service. I'm leaning towards running our own MySQL ...
4
votes
2answers
2k views

EBS with RAID0 (striping) and restoring snapshots

We have a MySQL database on EC2 and are looking at the disk IO performance there. Currently we have a single EBS volume with XFS and take snapshots for backup. It seems that a lot of people have ...
3
votes
4answers
832 views

best practice? Consumer data in MySQL on Amazon EBS (Elastic block store)

This is a consumer app, so I will care about storage costs - I don't want to have 5x copies of data lying about. The app shards very well, so I can use MySQL and not have scaling issues. Amazon EBS ...