centos7安装mysql5.7.40双主双从配置

一、5.7安装

环境信息

安装目录：/apps/xwsoft/mysql

tar -zxvf mysql-5.7.40-el7-x86_64.tar.gz

二、在mysql目录下创建文件my.cnf，创建data、log目录

[whl@localhost mysql]$ mkdir log

[whl@localhost mysql]$ mkdir data

[whl@localhost mysql]$ vi my.cnf

编写：/apps/xwsoft/mysql/my.cnf

[client]
port=3306
socket=/data01/apps/mysql/mysql.sock
default-character-set=utf8

[mysqld]
port=3306
basedir=/data01/apps/mysql
datadir=/data01/apps/mysql/data
socket=/data01/apps/mysql/mysql.sock

symbolic-links=0
log-error=/data01/apps/mysql/log/mysqld.log
pid-file=/data01/apps/mysql/mysqld.pid
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION


[mysql]
default-character-set=utf8

[mysqld]
# 开启bin_log，模式为ROW
log-bin=mysql-bin
binlog-format=ROW
log-slave-updates=1
relay_log=mysql-relay-bin
#保证全局唯一
server_id=1
max_connections=1000
lower_case_table_names=0
# 设置自增ID初始值为1，每次自增量为2,,B角色offset则设置2
auto_increment_offset=1
auto_increment_increment=2
# 开启gtid
gtid_mode=ON
enforce_gtid_consistency=1
# 忽略不需要同步的数据库
replicate-ignore-db=mysql
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema
replicate-ignore-db=sys

init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake

三、初始化

指定my.cnf路径

指定user

指定basedir路径

指定data路径

[whl@node01 mysql]$ bin/mysqld  --defaults-file=/apps/xwsoft/mysql/my.cnf --initialize  --user=whl  --basedir=/apps/xwsoft/mysql  --datadir=/apps/xwsoft/mysql/data

四、查看初始化密码

grep "password" /apps/xwsoft/mysql/log/mysqld.log

五、启动mysql，输入启动指令，等一会回车即可

[whl@node01 mysql]$ bin/mysqld_safe --defaults-file=/apps/xwsoft/mysql/my.cnf --user=whl &

5.1查看进程，端口号

[whl@localhost mysql]$ ss -utlanp | grep 3306
[whl@localhost mysql]$ ps -ef | grep mysql

5.2登录数据库，使用初始化密码