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.
