mysql 迁移6

franket

发布于 2022-03-22 11:54:24

1.2K0

发布于 2022-03-22 11:54:24

文章被收录于专栏：技术杂记

备份替换my.cnf配置文件

[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]$

innodb_additional_mem_pool_size 也已经被弃用了,如果有要注释掉

将zabbit加入mysql组以方便监控

[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 ~]#

本文系转载，前往查看

如有侵权，请联系 cloudcommunity@tencent.com 删除。

innodb