1 Answers
0
Hi I understand you are trying to find a best way to sync two or more multiple instance.
Instance per instance syncing you need to setup logical replication (one way) or physical replication (read replicas).
well, you can sync database in RDS instance by implementing replication[1], remember that an RDS instance can have up to 5 read replicas. and if you setup your own logical replication you can have more, but for logical replication, it depends on storage available,CPU, memory etc.
Reference link
1.https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html
answered 2 months ago
Relevant questions
RDS for multiple small databases
asked 2 years agoAm I billed while a RDS instance is starting/backing up?
Accepted Answerasked 7 months agoMultiple DB instance sync up
asked 2 months agoEC2 Auto Scaling group - Spot default maximum price when using multiple instance types
Accepted Answerasked 2 years agoCan we two gitlab servers connect to the same RDS postgresql database?
asked a month agocan not update beanstalk as it keeps looking for a deleted database
asked 4 months agoBest practices when upgrading RDS instance generations?
Accepted AnswerHow can I retrieve the list of all databases in an RDS DB instance via API?
Accepted Answerasked 2 years agoCloudWatch disk_used_percent alerts for multiple volumes on Nitro instance
Accepted Answerasked 3 years agoOn AWS RDS for Oracle how to install Oracle Database Gateway for SQL Server
asked 6 days ago