Question
Distribute the traffic for managed database
- Posted on August 14, 2021
- MySQL
Asked by devkhaledz
Hello everyone,
I’m working on a large app & website using PHP\Laravel, and I have the following servers:
- One load balancer.
- Three Webservers.
- one Redis server for a session, and cache.
- one worker server for running the jobs.
- One big MySQL server for the database.
However, I want to add a load balancer in front of the database to distribute the traffic.
My question is, will the managed database help with this? Or I should go with instances instead and configure the MySQL cluster manually?
Thanks
This textbox defaults to using Markdown to format your 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.
Want to learn more? Join the DigitalOcean Community!
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
Hi @devkhaledz,
You should be able to use both the suggested options - managed database, configuring MySQL cluster manually.
My opinion however would be to go about configuring it manually but that’s a personal reference not based on any facts, I just like doing it that way. Having said that, both options are plausible and achievable. It’s basically, up to you.