Linux Today: Linux News On Internet Time.

Top 5 Considerations for MySQL Administration in the Cloud

Jan 20, 2011, 00:05 (0 Talkback[s])
(Other stories by Sean Hull)

"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

Related Stories: