1. 下载解压TIDB
tar zxf tidb-latest-linux-amd64.tar.gz
cd tidb-v5.0.1-linux-amd64/
./bin/pd-server --name=pd1 --data-dir=pd1 --client-urls="http://172.25.3.6:2379" --peer-urls="http://172.25.3.6:2380" --initial-cluster="pd1=http://172.25.3.6:2380" --log-file=pd.log &
查看端口占用:
netstat -antlp |grep :2379
netstat -antlp |grep :2380
2.运行TIDB 迁移数据与用户授权
运行数据库,授权用户
./bin/tidb-server &
mysql -h 172.25.52.1 -P 4000 -uroot
create database zabbix character set utf8 collate utf8_bin;
CREATE USER 'zabbix'@'%' IDENTIFIED BY 'westos';
grant all privileges on *.* to 'zabbix'@'%';
备份数据库
mysqldump -uroot -pwestos zabbix >/mnt/zabbix.sql
mysql -h 172.25.52.1 -P 4000 -uroot
导入TIDB
use zabbix;
set tidb_batch_insert=1;
source /mnt/zabbix.sql;
3. 修改配置文件 重启ZABBIX
zabbix-server配置文件:
vim /etc/zabbix/zabbix_server.conf
#DB端口
DBPort=4000
zabbix-web监控配置文件:
vim /etc/zabbix/web/zabbix.conf.php
$DB['SERVER'] = '172.25.52.1';
$DB['PORT'] = '4000';
重启:
systemctl restart zabbix-server.service
systemctl restart zabbix-agent.service
4.测试:
zabbix可以正常访问