MySQL in Amazon EC2 – Beginners Guide

“Increasingly, enterprises are looking at cloud services such as
Amazon Web Services for their deployments. Datacenter
virtualization is much more sophisticated than its desktop
counterpart is, providing a whole suite of tools that allow you to
control every aspect of your deployments. Join Sean Hull as he
explores the MySQL – Amazon EC2 solution.

“Elastic Block Storage

“For databases, whether they be Oracle, MySQL, SQL Server or any
other, the first question that will probably come to mind is
surrounding storage. Am I limited to the onboard storage that my
server comes with? Luckily no, or database deployments in the cloud
would not be what they are today.

“It turns out that AWS has brought virtualization to storage
too, with its Elastic Block Storage or EBS solution. This allows
you to configure your server in any of a myriad of different
ways.

“EBS can be used for the root volume, making server spinup
faster and allowing your machine to be persistent, even if you
shutdown the instance for months on end. It also makes the bundling
of new AMIs trivial, with the ec2-create-image command line too.
Lastly, you can take snapshots of your root volume as a full root
partition backup if you so desire.”

Complete Story