Log in

No account? Create an account
entries friends calendar profile My Website Previous Previous Next Next
Some basic advice for running MySQL on Amazon AWS EC2 - Mark Atwood — LiveJournal
Some basic advice for running MySQL on Amazon AWS EC2
1 comment or Leave a comment
awfief From: awfief Date: January 6th, 2009 06:29 am (UTC) (Link)
Most of these run true for regular stuff too. Add to that list "mount partitions noatime and nodiratime" and "use a 64-bit OS".

You also give very few REASONS, so people can't make informed decisions, they just say "well, smart LJ told me to do that....". ie, you want to use large or xlarge because it has more RAM, but you don't say that.

Why do you say not to run dev or test w/multiple instances? We have a client doing just that, and there are 13 instances on one machine (all are replicating production instances for backup to S3). The machine runs just fine. Is it a cost thing maybe?

As for tablespaces on raw devices -- yes and no. The same caveats apply, such as backing up is way more of a pain as you can't do a cold backup (stop the server, copy files, start the server). Again, you don't give reasons why it's good, just that it's good. It's hard to make an informed decision like that.

And you are so way behind the times -- Yes, when an instance shuts down it goes away, but Amazon now has EBS. Our clients use EBS for the database partitions. As for Automate Everything, that's something everyone should do anyway, but having an EC2 instance means you're more inclined to actually DO it.

1 comment or Leave a comment