Support separate DB endpoint for read and write operations
Add support for specifying separate read-write and read-only database endpoint when configuring strapi instance.
Modern web apps often deployed on cloud platforms like AWS or GCP or Azure.
These platform offers very powerful Managed Database Services like RDS, Aurora (on AWS) or CloudSQL (Google cloud).
These services are built to scale and offer separate database replicas for read and write operations to help distributing the load on the Database.
Here: (https://cloud.google.com/sql/docs/postgres/replication/create-replica) and here (https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html)
Currently, Strapi only supports specifying a single DB endpoint that is used for all operations.
This request is to add support for separate endpointsfor write operations and one or many endpoints (could be round-robin balanced under the hood) for read-only operations.