In a mysql replica , when there is a need to enable slave as Read only so that no user can modify data, this is done by updating parameter read_only to On.
However when we try to enables the same in RDS from the command line this is the error:
To enable Read_only mode in an RDS replica, we need to change the db parameter group as shown below. Change this parameter in your PG to enable read_only mode (the below one is default PG and hence won't change).
Post making the changes the Replica should be in Read only mode
No comments:
Post a Comment