- 论坛徽章:
- 3
|
replicate-wild-ignore-table=mysql.%
replicate-wild-ignore-table=information_schema.%
replicate-wild-ignore-table=performance_schema.%
replicate-wild-ignore-table=sys.%
这些参数不起作用吗
我在主库上创建了个存储过程,但是在备库上也查得到
mysql> SELECT t.ROUTINE_SCHEMA,t.ROUTINE_NAME FROM information_schema.ROUTINES t WHERE ROUTINE_SCHEMA = 'hxl';
+----------------+------------------+
| ROUTINE_SCHEMA | ROUTINE_NAME |
+----------------+------------------+
| hxl | proc_insert_data |
+----------------+------------------+
1 row in set (0.00 sec)
|
|