I am new to AWS RDS, currently my team is using Postgres with read replica(asynchronous). The problem is this read replica is never used. We have Django application, where it using primary DB URL to connect. We want to utilize this this replica for reading the DB and primary for writing from same Django application without having to maintain multiple URLs in code(primary and replicas URLs). Is this possible to handle it on AWS to use appropriate DB based in read or write query?
I need to check if this solution possible, but I am not able getting documentation anywhere. I would appreciate if some one guides me on this topic.