MySQL Dynamic Scaling

The ability to scale dynamically is one of the most important requirements for your MySQL hosting deployment in the cloud, as you want to be able to scale up your deployment with minimal impact.

At ScaleGrid, we allow you to perform a dynamic, in-place scale to scale up your MySQL clusters to meet the needs of your application.

1. Login to the ScaleGrid console, and visit your MySQL cluster details page.
2. Click on the 'Scale' icon under the 'Overview' tab.
3. Select the new size that you want to scale to.
4. Review the configuration details of your scale operation directly below, then click the 'Scale' button.

👍

Your MySQL Cluster will now dynamically scale

From that point on, ScaleGrid takes over and provides a dynamic, in-place scale. This is implemented as a rolling operation where we perform the following tasks to scale your deployment:

• Take down one node at a time
• Update the instance type
• Update the disk size
• Update the disk IOPS (if necessary)
• Bring the node back up
• Wait for it to sync up
• Repeat to dynamically scale all nodes

So in this way, as a rolling operation, you can dynamically scale your MySQL deployment online. The only impact on your application is that you will see a failover of the master from one node to another during which your MySQL connections will fail. This can be handled from your application side by having connection retrys.

As always, if you have any further questions, please contact us at [email protected].