Re: run mysql on read-only filesystem ?

[Aimee Lin]

Hi Ingo,

I have setup a master-slave replication and I have tried to make the slave only accepts read-only operations by setting read_only variable in the option file.

mysql> show variables like '%read_only%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| read_only | ON |
+---------------+-------+

mysql> insert into test values(200);
Query OK, 1 row affected (0.06 sec)


But I am still able to perform insert statments on the slave database? Why, is there something else I need to do to make the slave server read-only?

Feed back much appreciated,
Aimee