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.

  1. Make sure you are using cluster end point - Yes i am using cluster endpoint
  2. Read only for mysql is set to 0 - already set.
  3. Cluster is pointing to both reader/writer instance.
  • Is this flagged as a "replica"? – Rick James Oct 11 '19 at 19:13
  • how can I check ? – Akash Arora Oct 11 '19 at 19:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.