Hi,

I have this project that has a great hit on read queries so I was wondering if I can use Managed DB to have a main node and many R/O nodes, but the question is how to do the load balancing in this case?

How to do Load Balancing on a Managed DB Posgresql?

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.

×
2 answers

i have the almost the same doubt. I will lunch an application which will have many queries and i would like to have more than one node. So if the first stops, i could have the second one up.

  • So if the first stops, i could have the second one up.

    This is not what I’m asking… and even so this is provided on the go when you launch Managed DB… It already provides automatic failover when you create a stand-by node, check the documentation

    https://www.digitalocean.com/docs/databases/

    What I’m still trying to figure out is how to do load balancing in this setup.

got it. Load balacing is important to me too. Ill wait the support answer. Thanks for your explanation

Submit an Answer