I need some advice on architecture.
I have a national database that relies on postgres and some architectural design that involves orchestrating several components, very much similar to the picture found here. We want to achieve HA and scaleability.
Now, before I move further with the proposal, I have a couple of questions :
What considerations need to be taken before choosing
which one is easier to maintain: multi masters or master - slave ?
master - slaveconfiguration is setup in such a way so that the slave can act as master in case the primary master goes down, isn't it the same as
How do we know which one suits well to answer the problem?
thank you for any advice or perhaps there are some readings that I can read?