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?
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?
Welcome to the official Cloudflare Developers server. Here you can ask for help and stay updated with the latest news
85,042Members
Resources
Similar Threads
Was this page helpful?
