Question

Distribute the traffic for managed database

  • Posted August 14, 2021
  • MySQL

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

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.

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.