Zabbix配置TiDB数据库

安装zabbix httpd mysql

[root&＃64;localhost bin]# pd-server --data-dir&＃61;/data/pd --log-file&＃61;/data/logs/pd.log &
[1] 3402
[root&＃64;localhost bin]# tikv-server --pd&＃61;"172.25.20.12:2379" --data-dir&＃61;/data/tikv --log-file&＃61;/data/logs/tikv.log &
[2] 3410
[root&＃64;localhost bin]# tidb-server --store&＃61;tikv --path&＃61;"172.25.20.12:2379" --log-file&＃61;/data/logs/tidb.log &
[3] 3463
[root&＃64;localhost bin]# ps ax3402 pts/0 Sl 0:00 pd-server --data-dir&＃61;/data/pd --log-file&＃61;/data/logs/pd.log3410 pts/0 Sl 0:14 tikv-server --pd&＃61;172.25.20.12:2379 --data-dir&＃61;/data/tikv --log-file&＃61;/data/logs/tikv.log3463 pts/0 Sl 0:00 tidb-server --store&＃61;tikv --path&＃61;172.25.20.12:2379 --log-file&＃61;/data/logs/tidb.log3469 pts/0 R&＃43; 0:00 ps ax

配置数据库

[root&＃64;localhost zabbix-server-mysql-3.4.6]# mysql -h 127.0.0.1 -P 4000 -uzabbix -pwestos
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.7.1-TiDB-0.9.0 MySQL Community Server (Apache License 2.0)Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.Type &＃39;help;&＃39; or &＃39;\h&＃39; for help. Type &＃39;\c&＃39; to clear the current input statement.MySQL [(none)]> show databases;
&＃43;--------------------&＃43;
| Database |
&＃43;--------------------&＃43;
| INFORMATION_SCHEMA |
&＃43;--------------------&＃43;
1 row in set (0.00 sec)MySQL [(none)]> CREATE DATABASE zabbix CHARSET &＃39;utf8&＃39;;
Query OK, 0 rows affected (0.34 sec)MySQL [(none)]> grant all privileges on zabbix.* to zabbix&＃64;localhost identified by &＃39;westos&＃39;;
Query OK, 0 rows affected (0.01 sec)MySQL [(none)]> show database;
ERROR 1105 (HY000): line 0 column 13 near "" (total length 13)
MySQL [(none)]> show databases;
&＃43;--------------------&＃43;
| Database |
&＃43;--------------------&＃43;
| INFORMATION_SCHEMA |
| zabbix |
&＃43;--------------------&＃43;
2 rows in set (0.00 sec)MySQL [(none)]> use zabbix;
Database changed
MySQL [zabbix]> show tables;
Empty set (0.00 sec)

在将数据导入zabbix库
[root&＃64;localhost zabbix-server-mysql-3.4.6]# mysql -h 127.0.0.1 -P 4000 -uzabbix -pwestos zabbix
[root&＃64;localhost zabbix-server-mysql-3.4.6]#

导入完成后 查看


Aborted
[root&＃64;localhost zabbix-server-mysql-3.4.6]# mysql -h 127.0.0.1 -P 4000 -uzabbix -pwestos
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 20
Server version: 5.7.1-TiDB-0.9.0 MySQL Community Server (Apache License 2.0)Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.Type &＃39;help;&＃39; or &＃39;\h&＃39; for help. Type &＃39;\c&＃39; to clear the current input statement.MySQL [(none)]> use zabbix
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -ADatabase changed
MySQL [zabbix]> show tables;
&＃43;----------------------------&＃43;**************************
| trigger_depends |
| trigger_discovery |
| trigger_tag |
| triggers |
| users |
| users_groups |
| usrgrp |
| valuemaps |
| widget |
| widget_field |
&＃43;----------------------------&＃43;
140 rows in set (0.00 sec)MySQL [zabbix]>

其他配置与前一部分相同 添加端口


添加php脚本
[root&＃64;localhost web]# vim zabbix.conf.php
[root&＃64;localhost web]# pwd
/etc/zabbix/web
// Zabbix GUI configuration file
global $DB;$DB[&＃39;TYPE&＃39;] &＃61; &＃39;MYSQL&＃39;;
$DB[&＃39;SERVER&＃39;] &＃61; &＃39;172.25.20.12&＃39;;
$DB[&＃39;PORT&＃39;] &＃61; &＃39;4000&＃39;;
$DB[&＃39;DATABASE&＃39;] &＃61; &＃39;zabbix&＃39;;
$DB[&＃39;USER&＃39;] &＃61; &＃39;zabbix&＃39;;
$DB[&＃39;PASSWORD&＃39;] &＃61; &＃39;westos&＃39;;// Schema name. Used for IBM DB2 and PostgreSQL.$DB[&＃39;SCHEMA&＃39;]&＃61;&＃39;&＃39;;$ZBX_SERVER &＃61; &＃39;localhost&＃39;;
$ZBX_SERVER_PORT &＃61;&＃39;10051&＃39;;
$ZBX_SERVER_NAME &＃61;&＃39;zabbixServer&＃39;;$IMAGE_FORMAT_DEFAULT &＃61; IMAGE_FORMAT_PNG;

启动登陆浏览器