使用二进制安装MySQL5.7.26_二进制安装MySQL5.7.26

mysql5.7.26二进制安装

总结

· 搭建主从后添加新的从库，发现无法进行同步

· 搭建主从同步使用为gtid方式，可无需对主库的一个值记录，这样主要方便ansible使用

二进制方式安装数据库

# 0.基础猪呢比：创建mysql存放目录和删除centos7自带软件，创建mysql用户

yum -y remove mariadb*

mkdir -p /application/

useradd mysql -M -s /sbin/nologin -u 1111

[[email protected] /application]# mkdir /data/mysql/data -p

yum install -y libaio-devel

yum install perl-DBD-MySQL -y

yum install -y dos2unix

# 1. 使用二进制方式安装

mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz将此安装包上传

# 2. 解压安装包

[[email protected] ~]# tar xf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz -C /application/

# 3. 将安装包重命名

[[email protected] /application]# mv mysql-5.7.26-linux-glibc2.12-x86_64/ mysql-5.7

# 4. 创建软连接

[[email protected] /application]# ln -s mysql-5.7/ mysql

# 5. 环境变量

[[email protected] /application]# echo "export PATH=/application/mysql/bin:$PATH" >> /etc/profile

[[email protected] /application]# source /etc/profile

# 6.授权目录

[[email protected] /application]# chown -R mysql.mysql /application/*

[[email protected] /application]# chown -R mysql.mysql /data/mysql/data

# 7. 初始化

[[email protected] /application]# cd /application/mysql/support-files && mysqld --initialize-insecure --user=mysql --basedir=/application/mysql --datadir=/data/mysql/data

# 8. 支持使用service方式启动mysql

cp mysql.server /etc/init.d/mysqld

# 9. 授权

mkdir -p /data/binlog/

chown -R mysql.mysql /data

# 8.书写配置文件(主)

[mysqld]

basedir=/application/mysql/

datadir=/data/mysql/data

socket=/tmp/mysql.sock

server_id=51

port=3306

secure-file-priv=/tmp

autocommit=0

log_bin=/data/binlog/mysql-bin

binlog_format=row

gtid-mode=on

enforce-gtid-consistency=true

log-slave-updates=1

[mysql]

prompt=db01 [\\d]>

###从1：

[mysqld]

basedir=/application/mysql

datadir=/data/mysql/data

socket=/tmp/mysql.sock

server_id=52

port=3306

secure-file-priv=/tmp

autocommit=0

log_bin=/data/binlog/mysql-bin

binlog_format=row

gtid-mode=on

enforce-gtid-consistency=true

log-slave-updates=1

[mysql]

prompt=db02 [\\d]>

### 从2：

[mysqld]

basedir=/application/mysql

datadir=/data/mysql/data

socket=/tmp/mysql.sock

server_id=52

port=3306

secure-file-priv=/tmp

autocommit=0

log_bin=/data/binlog/mysql-bin

binlog_format=row

gtid-mode=on

enforce-gtid-consistency=true

log-slave-updates=1

[mysql]

prompt=db02 [\\d]>

# 从3

[mysqld]

basedir=/application/mysql

datadir=/data/mysql/data

socket=/tmp/mysql.sock

server_id=53

port=3306

secure-file-priv=/tmp

autocommit=0

log_bin=/data/binlog/mysql-bin

binlog_format=row

gtid-mode=on

enforce-gtid-consistency=true

log-slave-updates=1

[mysql]

prompt=db03 [\\d]>

# 9. 启动服务

[[email protected] /application]# service mysqld start

原文：https://www.cnblogs.com/tcy1/p/13295158.html