Top 5 Considerations for MySQL Administration in the Cloud

“Cloud deployments of internet sites are becoming much more
prevalent everyday. Let’s take a look at what type of special
considerations we’ll need to make for hosting MySQL successfully in
the cloud.

“1. Pay attention to disk I/O

“For all databases, disk I/O is an important consideration.
MySQL of course is no different, and when hosting a database in the
cloud the concepts remain the same. How you achieve fast I/O is
slightly different.

“Although you may use instance store boot images, remember that
everything on the root volumes will be lost when the instance dies;
and they die much more often than servers in traditional managed
hosting facilities do. EBS rooted images boot faster, allow you to
backup the root volume, and provide root volume persistence after
reboot.”

Complete Story