Support for Distinct Credentials between Read Replica and Primary Database

[stinkymonkeyph]

I believe having different passwords between your read replica and primary database is essential.

Enhanced Security: Different passwords for read replicas and primary databases provide an additional layer of security. Users can limit access to read replicas without exposing write permissions, reducing the risk of unauthorized changes.

Access Control: It allows administrators to assign different roles or permissions for read and write operations, helping segregate duties and protect sensitive operations.

Improved Flexibility: Users can better manage different user groups, such as read-only analytics teams, while ensuring that only trusted systems or personnel have write access to the primary database.