linux 部署单机polardbx离线包

官方文档

PolarDB_PolarDB社区_开源社区_数据库_阿里云
下载PolarDB-X-engine-8.4.19-20241112.el7.x86_64
 

安装PolarDB-X

yum install -y t-polardbx-engine-8.4.19-20241112.el7.x86_64.rpm

安装后的二进制文件，会出现在 /opt/polardbx_engine/bin 中
/opt/polardbx_engine/bin是/u01/xcluster80_20241112的软链接

创建用户

创建并切换到 polarx 用户
useradd -ms /bin/bash polarx
echo "polarx:polarx" | chpasswd
echo "polarx    ALL=(ALL)    NOPASSWD: ALL" >> /etc/sudoers
su - polarx

使用polarx 用户在/home/polarx下创建必要目录(pwd查看是否在当前目录)
mkdir polardbx-engine
cd polardbx-engine && mkdir log mysql run data tmp
vi 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

# change me if needed
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
server_id = 2712347953

[mysqld_safe]
pid_file = /home/polarx/polardbx-engine/run/mysql.pid

初始化(使用polarx用户)

如果 my.cnf 不在当前目录，请将下述命令的 my.cnf 改成绝对路径
/opt/polardbx_engine/bin/mysqld --defaults-file=my.cnf --initialize-insecure

启动(使用polarx用户)

/opt/polardbx_engine/bin/mysqld_safe --defaults-file=my.cnf &

查看4886端口是否启动,有结果表示成功,无结果表示失败
lsof -i:4886

(可以使用root用户)安装mysql客户端工具
yum install -y mysql
使用客户端设置root密码

mysql -h127.0.0.1 -P4886 -uroot

逐行执行下面sql,设置mysql用户

CREATE USER 'root'@'%' IDENTIFIED BY 'yourpassword';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

配置service服务

[Unit]
Description=PolarDB-X MySQL Service
After=network.target

[Service]
User=polarx
Group=polarx
ExecStart=/opt/polardbx_engine/bin/mysqld_safe --defaults-file=/home/polarx/polardbx-engine/my.cnf --user=polarx
Restart=on-failure
TimeoutSec=60
LimitNOFILE=65535

[Install]
WantedBy=multi-user.target