There's an interesting AWS disaster recovery lab that gives information you might be interested. This page: https://disaster-recovery.workshop.aws/en/services/databases/rds/rds-cross-region.html gives an overview of replication options for various RDS database types. Aurora global databases might also be of interest: https://disaster-recovery.workshop.aws/en/labs/advanced/aurora-global-database.html.
Being a good distance apart will always mean a compromise between transaction latency and RPO whichever option you choose.
Out of interest, is the multi-region design for performance (to keep data relatively close to users) or disaster recovery? I guess you could have a pair of databases, one active in each region with a corresponding passive replica in the other region.
Relevant questions
RDS SQL Server upgrade downtime
Accepted Answerasked 2 years agoRDS SQL Server backup options
Accepted AnswerAnnouncement: Amazon RDS for SQL Server ending support for Microsoft SQL Server 2012
asked 4 months agoRDS Multi-region design discussion
asked 14 days agoHow to migrate DB on premise Oracle to Microsoft SQL Server DB in AWS. We see SCT will not allow MS SQL Server as Target when source is Oracle. Looking for tools like SCT to move Schema from Oracle.
asked 3 months agoHow is RDS for SQL Server Express charged?
Accepted Answerasked 7 months agoRDS SQL Server - Using MSDN licenses
Accepted Answerasked 5 years agoWhich application types can use SQL Server Web Edition on RDS?
asked 3 months agoLarge Oracle Migration Feature similar to restore from (Snowballed In) S3 that RDS SQL Server Has
Accepted Answerasked 5 years agoAWS Backup of RDS managed Oracle or MS-SQL database
asked 2 months ago
Thanks! Your information is helpful.