数据库： MySQL安装部署、主从

最新推荐文章于 2024-06-12 19:31:55 发布

一点博客

最新推荐文章于 2024-06-12 19:31:55 发布

阅读量165

点赞数

分类专栏：运维文章标签：数据库 mysql

本文链接：https://blog.csdn.net/qq_37740841/article/details/132383755

版权

运维专栏收录该内容

7 篇文章 0 订阅

订阅专栏

单机部署

mkdir -p /opt/soft/archive
cd /opt/soft/archive

wget -i -c https://dev.mysql.com/get/mysql80-community-release-el7-7.noarch.rpm
yum install -y mysql80-community-release-el7-7.noarch.rpm
yum-config-manager --enable mysql80-community
yum install -y mysql-community-server
systemctl start mysqld
export pw=$(grep 'temporary password' /var/log/mysqld.log | awk '{print $13}')
mysql -u root -p$pw
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
CREATE USER demo IDENTIFIED BY 'Demo@1234';
grant all on *.* to 'demo'@'%';
flush privileges;
quit;

systemctl restart mysqld

主从

主库：

set global server_id = 2;
CREATE USER 'repl'@'%' IDENTIFIED BY 'Repl@1234';
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%';
ALTER USER 'repl'@'%' IDENTIFIED WITH mysql_native_password BY 'Repl@1234';
flush privileges;

FLUSH TABLES WITH READ LOCK;

# 查看binlog file 和 position
SHOW MASTER STATUS; 


UNLOCK TABLES;

从库：

set global server_id = 33;

CHANGE MASTER TO
MASTER_HOST='123.56.192.242',
MASTER_USER='repl',
MASTER_PASSWORD='Repl@1234',
MASTER_LOG_FILE='binlog.000003',
MASTER_LOG_POS=578964;

start slave;

# 停止同步
stop slave;
reset slave all;