A quick question on aws rds - Is it possible to have active-active replication with distributed writes across regions with aws rds postgres sql database? If so how to achieve it?
I think this is one the key things that aurora is designed to solve.
Tying to aurora would mean tight coupling with aws right? It would be hard to also support other cloud providers like gcp and azure. Is that true?
Support in what way? Connect to the Aurora db or replicate the data itself into the other clouds?
If you want active active across regions in RDS Aurora global is the only option I’m aware of.
If you just need to connect to the db from other clouds it should be fine as long as your networking Config is set up right
We want our application to support all cloud providers so clients can choose aws, azure or gcp based on their preference
> If you want active active across regions in RDS Aurora global is the only option I’m aware of.
- Do you mean active active across regions with distributed writes is possible only in Aurora and not in RDS?
Because active active across regions with read replicas is possible with RDS too right?
Read replicas are not active
- do read replicas mean active-passive replication?
Yeah exactly. Very near real time and replica can serve queries. So it’s active for read but not write
Any managed service that provides active-active replication for postgres that you know off?
I came across a way to do so through an open source tool called symmetricDS but with a lack of a strong db and devops team a managed service would be something we would look out for
Aurora, as mentioned above
Ok. I initially thought aurora provides only active-passive replication with read replicas but it seems there is a way to architect it in a multi-master cluster. The trade off would be it would tie us to aws and make migration to other cloud provider difficult
You could look at https://www.yugabyte.com/ although I think the interface is Postgres I don’t think the architecture behind the scenes is
And there’s https://planetscale.com/ but that’s MySQL
Aurora multi-master is in a single region only, btw
> Aurora multi-master is in a single region only, btw
Indeed. Thanks for this note. I was under the impression that it supports multi-master across regions
It seems it is possible to implement multi-master replication across regions with oracle goldengate