I just wanted to let you all know that MHA for MySQL (Master High Availability Manager and tools for MySQL) version 0.53 has been released.

Yoshinori Matsunobu discusses the release in much more detail here:

http://yoshinorimatsunobu.blogspot.com/2012/01/mha-for-mysql-053-released.html

The full MHA 0.53 changelogs are here:

http://code.google.com/p/mysql-master-ha/wiki/ReleaseNotes

MHA 0.53 can be downloaded from here:

http://code.google.com/p/mysql-master-ha/downloads/list

And if you would like support for MHA, simply contact SkySQL:

…

Call or SKYPE us in New York City: +1-212-533-6828

MySQL in the Cloud

• Deploying MySQL in the Cloud
• Cloud Security considerations for databases
• Deploying in multiple Availability Zones
• Deploying in multiple regions
• Deploying MySQL with multi-az
• Horizontal scalability in the cloud
• MySQL spinup scripts
• Deploying Amazon RDS
• Evaluating RDS
• Evaluating MySQL in the cloud
• EBS Performance considerations
• Tuning MySQL parameters in the cloud
• Backup types & options
• Mitigating against cloud server failure
• Vertical scalability & MySQL on EC2

MySQL Consulting and Services

• Backup & recovery
• MySQL master master replication
• MySQL replication & horizontal scaling
• MySQL …

Deploying in the Amazon cloud is touted as a great way to achieve high scalability while paying only for the computing power you use. How do you get the best scalability from the technology?

1. Use Auto-scaling

Auto-scaling is a unique feature of cloud computing and Amazon's EC2 offering. Setup a load balancer and a couple of webservers for your application as you normally would. Design your webserver based on a template AMI that you'll reuse over and over. Then setup auto-scaling and set thresholds based on the traffic you forecast. When a threshold is passed, AWS will spinup a new instance of your webserver, and roll it into the load balancer pool automatically. Once traffic falls below the scale back threshold, Amazon will take a server out of the pool for you.

Be sure to monitor this …

Today, SkySQL announced a partnership with Yoshinori Matsunobu, an Oracle ACE Director and the creator of the newly announced MySQL Master High Availability Manager and Tools (MySQL MHA) for automating MySQL master failover. With this partnership, SkySQL will be the first MySQL database commercial services company to provide technical support, professional services, and training, for MySQL MHA.

read more