Hyperdrive: Connect to closest PG database via DNS
I connected Hyperdrive to a local Postgres RDS instance, and it works, but it's quite slow to query globally.
To speed it up, I set up multiple RDS instances around the world as read replicas, and set up a new DNS record, using Route53 Latency-based routing.
The DNS works when querying manually (from different machines across the world, it always resolves to the closest Postgres instance). However, Hyperdrive seems to always connect to the same Postgres instance (making all the queries from far away regions slow).
Is there some trick to get each regional Hyperdrive pool connecting to the closest RDS instance? Or am I approaching this incorrectly?
0 Replies