mysql 迁移6

[root@slave02 etc]# mv my.cnf my.old.2015.12.09.backup
[root@slave02 etc]# mv mynew02.cnf  my.cnf
[root@slave02 etc]# ll my*
-rw-r--r-- 1 root root  1928 Dec  8 21:18 my.cnf
-rw-r--r-- 1 root root 21146 Jul  4  2014 my.old.2015.12.09.backup
[root@slave02 etc]# 

[testuser@slave01 etc]$ diff /tmp/old /tmp/new
11c11
< table_cache = 2048
---
> table_open_cache = 2048
18d17
< thread_concurrency = 8
22c21
< default_table_type = INNODB
---
> default_storage_engine = INNODB
23a23
> relay-log=relay-bin
31c31
< server-id = 123
---
> server-id = 321 
41,42c41
< myisam_max_sort_file_size = 5G
< myisam_max_extra_sort_file_size = 5G
---
> myisam_max_sort_file_size = 1G
44c43
< myisam_recover
---
> myisam_recover_options
[testuser@slave01 etc]$ 

[root@new-master mysql]# vim /etc/group
[root@new-master mysql]# id zabbix
uid=496(zabbix) gid=493(zabbix) groups=493(zabbix),492(mysql)
[root@new-master mysql]# /etc/init.d/zabbix-agent restart 
Shutting down Zabbix agent:                                [  OK  ]
Starting Zabbix agent:                                     [  OK  ]
[root@new-master mysql]# 
----------
[root@zabbix-server ~]# zabbix_get -s new-master -p 10050 -k "mysql.slowlog[100,/var/lib/mysql/new-master-slow.log]"
2.98465
[root@zabbix-server ~]#