MySQL数据库高可用之pxc

先定义hosts主机
Vim /etc/hosts

先解决依赖包
yum install -y libev lsof perl-Compress-Raw-Bzip2 perl-Compress-Raw-Zlib perl-DBD-MySQL perl-DBI \ perl-Digest perl-Digest-MD5 perl-IO-Compress perl-Net-Daemon perl-PlRPC qpress socat openssl openssl-devel

其中qpress包安装不了需要单独安装

安装XtaBackup
rpm -ivh percona-xtrabackup-24-2.4.18-1.el7.x86_64.rpm

卸载MariaDB
rpm -qa | grep mariadb
rpm -e mariadb-libs --nodeps

创建mysql的组和用户
groupadd -r mysql
useradd -M -s /bin/false -r -g mysql mysql

解压软件包到/usr/local/mysql,并创建数据目录，赋予权限

配置环境变量
Vim /etc/profile
export PATH=/usr/local/mysql/bin:$PATH

关闭selinux
vim /etc/selinux/config
SELINUX=disabled

关闭防火墙
Systemctl stop firewalld

编写mysql主配文件

[client]
port = 3306
socket = /tmp/mysql.sock
[mysql]
prompt="\u@\h \R:\m:\s[\d]> "
no-auto-rehash
[mysqld]
user = mysql
port = 3306
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
socket = /tmp/mysql.sock
pid-file = db.pid
character-set-server = utf8mb4
skip_name_resolve = 1
open_files_limit = 65535
back_log = 1024
max_connections = 512
max_connect_errors = 1000000
table_open_cache = 1024
table_definition_cache = 1024
table_open_cache_instances = 64
thread_stack = 512K
external-locking = FALSE
max_allowed_packet = 32M
sort_buffer_size = 4M
join_buffer_size = 4M
thread_cache_size = 768
#query_cache_size = 0
#query_cache_type = 0
interactive_timeout = 600
wait_timeout = 600
tmp_table_size = 32M
max_heap_table_size = 32M
slow_query_log = 1
slow_query_log_file = /usr/local/mysql/data/slow.log
log-error = /usr/local/mysql/data/error.log
long_query_time = 0.1

mysql初始化
如果报错查看环境变量
刷新环境变量

mysqld --default-file=/etc/my.cnf --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --initialize

启动mysql

查看msyql是否开启

查看mysql密码

使用密码登录mysql