I have global user base spread globally. If I use AWS Aurora MySQL Serveless DB, and select Multi-AZ support, how to use read replica closer to the user for RO queries. To be more specific, Primary DB will in London. London User -> London App Server --> London DB (for read) Tokyo user -> Tokyo App Server --> Tokyo DB (for read)
London/Tokyo user -> London/Tokyo App Server --> London DB (for write) All I want to understand is how to force App SErver to connect to the nearest read replica.
I don't think there is an option to create a read replica for Aurora MySQL Serverless DB. Please refer to the official setup documentation here.
I think your only option is to use Aurora Global Database that spans multiple AWS regions. Read more here.