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, 2019 at 19:13
  • how can I check ? Oct 11, 2019 at 19:51


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.