Zabbix Server Database Migration

Zabbix Server Migration db:

Before Zabbix server and DB 10.10.4.3on the same machine, DB is now migrating to another machine 10.10.4.2

Zabbix Server Intranet ip:10.10.4.3

The new DB intranet IP is 10.10.4.2

1. Export the Zabbix library and import it into the new DB

Mysql-uroot-p zabbix< Zabbix.sql

2. New DB Add and authorize Zabbix users

Grant all on zabbix.* to [email protected] '% ' identified by ' Zabbix ' with grant option;      

flush Privileges;

#添加用户zabbix密码zabbix can be accessed by the% arbitrary IP    

3. Set MY.CNF listener address for all, and modify iptables allow

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M01/7B/0F/wKioL1bFnWiDo5fGAAADuoFuRwA511.png "title=" 11111. PNG "alt=" Wkiol1bfnwido5fgaaaduofurwa511.png "/>

4. Firewall Policy

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/7B/0F/wKioL1bFna_x7EpLAAANAuLNdyY961.png "title=" 22222222.png "alt=" Wkiol1bfna_x7eplaaanaulndyy961.png "/>

Note: Be sure to use the command line on the server machine to connect the DB remotely

#mysql-H 10.10.4.2-u zabbix-p

5. Modify Zabbix page profile db SERVER = 10.10.4.2

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/7B/0F/wKioL1bFnhewa5CzAAAmDgcKBsQ804.png "title=" 333333333333.png "alt=" Wkiol1bfnhewa5czaaamdgckbsq804.png "/>

6. Start Zabbix_server, migration is successful

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M01/7B/0F/wKioL1bFnkbjUSH0AAAQc567Yh4359.png "title=" 4444444444444444444.png "alt=" Wkiol1bfnkbjush0aaaqc567yh4359.png "/>

This article is from the "Brother" blog, please be sure to keep this source http://yangmv.blog.51cto.com/2366107/1743108

Zabbix Server Database Migration