mysql 从库写

回复 2# Wentasy

我设置了这个参数，一样可以在mycat_tc库中的表上进行DML、DDL操作的？？？
   mysql> show variables like 'read_only';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| read_only     | ON    |
+---------------+-------+
1 row in set


mysql> insert into readonly_test values (1,"zhang");
Query OK, 1 row affected


mysql> select * from readonly_test;
+----+-------+
| id | name  |
+----+-------+
|  1 | zhang |
+----+-------+
1 row in set