MySQL in Cloud

[Praveen Sripati]

Hi,

We are migrating an application (Tomcat/MySQL) into Azure Cloud. For this we are using MySQL Accelerator provided by Microsoft which uses Master/Slave configuration for Load balancing. There are a couple of issues with this approach

1. There is 1 master and n slaves. So, the write through-put is constant and the read through-put is scalable.

2. When a slave is added, then tomcat should be made aware of the new MySQL instance. Do we need to use JMX to update the JDBC Connect String in Tomcat? We are using com.mysql.jdbc.ReplicationDriver (http://dev.mysql.com/doc/refman/5.5/en/connector-j-reference-replication-connection.html) to load balance across the master and the slaves.

Are there any best practices/patterns/softwares for making MySQL scalable in the cloud? Has anyone used MySQL Cluster in the cloud?

Thanks,
Praveen