I am working on QLDB from last 3 months on a single region using it as a leisure database. Now, business wants to move applications in multi-region support. I found many of the AWS services support multi-region like DynamoDB, Secrets Manager.
But there is limitations on QLDB for multi-region use. I saw from some AWS articles that QLDB does not have support for multi-region as it's not a distributed technology.
Now, to cater business requirement with minimal changes in code, I have to approaches/workaround for QLDB to support multi-region.
- Do I need to create region-based ledger, with same functionality? I understand there are major challenges with maintaining the geo-based traffic.
- I will keep QLDB ledger in single region and gives cross-region access permissions to Lambda functions to access it. It's a simplest one but eat latency.
Which approach helps in long term and in scalability? Or please suggest if anyone has different approach to achieve this.