Mysql双机集群搭建(双主集群)
一、 环境准备
OS:RED HAT 7.6
Mysql:mysql-5.7.33
1.1 在安装MySQL要先卸载冲突的包(两节点执行)
查看冲突包 rpm -qa |grep mariadb
卸载冲突包 rpm -e mariadb-libs-1:5.5.60-1.el7_5.x86_64 --nodeps
查看历史包 rpm -qa | grep mysql
普通删除 rpm -e xxx 根据查看历史包的情况卸载
-----使用普通删除不掉的话,用下面的命令进行强力删除
强力删除 rpm -e --nodeps xxx根据查看历史包的情况卸载
1.2 创建用户、初始化(两节点执行)
查看是否已存在mysql用户
id mysql
如果已存在,请先删除存在的用户,使用命令:userdel –r mysql 不存在的情况,使用下列命令创建用户及组
[root@linux_128 src]# groupadd mysql
[root@linux_128 src]# useradd -g mysql -d /home/mysql -m mysql
二、安装配置
2.1 解压安装(两节点执行)
本次用5.7版本的安装包安装
下载好linux版本的mysql安装包
mysql-5.7.33-1.el6.x86_64.rpm-bundle.tar
解压:
tar -xvf mysql-5.7.33-1.el6.x86_64.rpm-bundle.tar
查看列表:
ls -ltr
依次安装使用rpm -ivh xxx依次安装
rpm -ivh mysql-community-common-5.7.33-1.el6.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.33-1.el6.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.33-1.el6.x86_64.rpm
rpm -ivh mysql-community-client-5.7.33-1.el6.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.33-1.el6.x86_64.rpm
rpm -ivh mysql-community-embedded-5.7.33-1.el6.x86_64.rpm
rpm -ivh mysql-community-embedded-devel-5.7.33-1.el6.x86_64.rpm
rpm -ivh mysql-community-server-5.7.33-1.el6.x86_64.rpm --nodeps
rpm -ivh mysql-community-test-5.7.33-1.el6.x86_64.rpm --nodeps
2.2 配置/etc/my.cnf配置文件并启动(两节点执行)
备份:
[root@linux_128 soft]# cp /etc/my.cnf /etc/my.cnf_bak
[root@linux_128 soft]# echo>/etc/my.cnf
修改配置:
[root@linux_128 soft]# vi /etc/my.cnf
节点1配置
[client]
socket=/var/lib/mysql/mysql.sock
default-character-set=utf8
[mysqld]
server-id=1
init-connect='SET NAMES utf8'
default-storage-engine=INNODB
character-set-server=utf8
datadir=/soft/mysql
socket=/var/lib/mysql/mysql.sock
#assorted security risks
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
#validate_password=off
explicit_defaults_for_timestamp=true
skip-grant-tables
lower_case_table_names=1
log-bin=/soft/mysql/log_bin
log-bin-index=/soft/mysql/log_bin.index
slow_query_log = 1
slow_query_log_file = /soft/mysql/slowlog/mysql_slow_query.log
long_query_time = 3
relay-log = /soft/mysql/relaylog/relay-log
auto_increment_offset = 1
auto_increment_increment = 2
节点2配置
[client]