Monday, 20 March 2017

How to Check if MySQL Instance is read only

In order to find out if your DB server in read mode or read/write mode.

Follow the below Steps:

  • Login into your DB Server using MySQL Tools,Mysqlem etc.
  • Run below queries:
    • SELECT @@global.read_only;
    • If the Output is 1, it means DB server is read only.
    • else if Output is 0, it means DB server is both read/write.

Enjoy Reading.

No comments:

Post a Comment