I am using amazon aurora RDS in my application. I have created cluster endpoint by selecting both read and write instance. Then I used that instance in my application. Whenever I am executing update query I am getting following error:
The MySQL server is running with the --read-only option so it cannot execute this statement".
I have checked online few fixes.
- Make sure you are using cluster end point - Yes i am using cluster endpoint
- Read only for mysql is set to 0 - already set.
- Cluster is pointing to both reader/writer instance.