测试环境
AnolisOS-8.6-x86_64-minimal.iso
Virtual Box，2 vCPU, 4G RAM, 60 vDisk
下载PolarDB-X安装包
https://openpolardb.com/download?type=PolarDB-X
安装依赖
yum install -y libaio* ncurses-devel
ln -s /usr/lib64/libncurses.so.6.1 /usr/lib64/libncurses.so.5
ln -s /usr/lib64/libtinfo.so.6.1 /usr/lib64/libtinfo.so.5
安装PolarDB-X
rpm -ivh t-polardbx-engine-2.4.0-a6d7022.el7.x86_64.rpm
创建并切换到polarx用户
useradd -ms /bin/bash polarx
echo "polarx:polarx" | chpasswd
echo "polarx ALL=(ALL) NOPASSWD: ALL" >> /etc/sudoers
su - polarx
创建必要目录
mkdir polardbx-enginecd polardbx-engine && mkdir log mysql run data tmp
mkdir polardbx-engine/log
mkdir polardbx-engine/tmp
mkdir polardbx-engine/run
touch /home/polarx/polardbx-engine/log/alert.log
创建my.cnf配置文件
[mysqld]
basedir = /opt/polardbx_engine
log_error_verbosity = 2
default_authentication_plugin = mysql_native_password
gtid_mode = ON
enforce_gtid_consistency = ON
log_bin = mysql-binlog
binlog_format = row
binlog_row_image = FULL
master_info_repository = TABLE
relay_log_info_repository = TABLE
datadir = /home/polarx/polardbx-engine/data
tmpdir = /home/polarx/polardbx-engine/tmp
socket = /home/polarx/polardbx-engine/tmp.mysql.sock
log_error = /home/polarx/polardbx-engine/log/alert.log
port = 4886
cluster_id = 1234
cluster_info = 127.0.0.1:14886@1
[mysqld_safe]
pid_file = /home/polarx/polardbx-engine/run/mysql.pid
初始化
/opt/polardbx_engine/bin/mysqld --defaults-file=my.cnf --initialize-insecure
启动
/opt/polardbx_engine/bin/mysqld_safe --defaults-file=my.cnf &
登录数据库
/opt/polardbx_engine/bin/mysql -h127.0.0.1 -P4886 -uroot
安装ZABBIX 6.0
https://repo.zabbix.com/zabbix/6.0/rhel/8/x86_64/zabbix-release-6.0-4.el8.noarch.rpm
rpm -ivh zabbix-release-6.0-4.el8.noarch.rpm
yum clean all
yum install -y zabbix-server-mysql zabbix-web-mysql zabbix-apache-conf zabbix-sql-scripts zabbix-selinux-policy zabbix-agent
创建数据库
create database zabbix character set utf8mb4 collate utf8mb4_bin;
create user 'zabbix'@'192.168.1.0/255.255.255.0' identified WITH mysql_native_password by 'PolarX@2024!';
grant all on zabbix.* to 'zabbix'@'192.168.1.0/255.255.255.0';
set global log_bin_trust_function_creators=1;
导入数据库
zcat /usr/share/zabbix-sql-scripts/mysql/server.sql.gz | /opt/polardbx_engine/bin/mysql -h 192.168.1.37 -P4886 --default-character-set=utf8mb4 -uzabbix -p zabbix
编辑zabbix配置文件
vi /etc/zabbix/zabbix_server.conf
DBHost=192.168.1.37
DBUser=zabbix
DBPassword=PolarX@2024!
DBPort=4886
grep -v "^$|#" /etc/zabbix/zabbix_server.conf
vi /etc/httpd/conf/httpd.conf
ServerName 192.168.1.37:80
vi /etc/php-fpm.d/zabbix.conf
php_value[date.timezone] = Asia/Shanghai
启动zabbix服务
systemctl restart zabbix-server zabbix-agent httpd php-fpm
systemctl enable zabbix-server zabbix-agent httpd php-fpm
systemctl status zabbix-server zabbix-agent httpd php-fpm
访问zabbix WEB，注意修改数据库配置
注意：初始帐号和密码。Admin / zabbix
