Question

Distribute the traffic for managed database

Posted August 14, 2021 73 views
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

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.

×
Submit an Answer
1 answer

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.