Report this

What is the reason for this report?

Distribute the traffic for managed database

Posted on August 14, 2021

Hello everyone,

I’m working on a large app & website using PHP\Laravel, and I have the following servers:

  1. One load balancer.
  2. Three Webservers.
  3. one Redis server for a session, and cache.
  4. one worker server for running the jobs.
  5. 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.

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.

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.