Question

Does managed database split read load between master and read-only node?

I would like to know if adding a read-only node to the managed mysql database help with the load by splitting the select queries between servers automatically?

Thank you

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Hello,

I don’t think that this happens automatically, you need to either use a Load Balancer or a service like ProxySQL, or build the logic into your application.

For example if you use a framework like Laravel this is quite straight forward to implement, you could take a look at this tutorial here on how to do that:

https://www.digitalocean.com/community/tutorials/how-to-set-up-a-scalable-laravel-6-application-using-managed-databases-and-object-storage#step-6-—-scaling-up-a-digitalocean-managed-mysql-database-with-read-only-nodes-(optional)

Regards, Bobby