CentOS8.2安装mysql8.0双主

 systemctl stop firewalld
 systemctl disable firewalld
 setenforce 0
 sed -i 's/^SELINUX=.*/SELINUX=disabled/' /etc/selinux/config

 timedatectl set-timezone Asia/Shanghai

 安装如下四个包即可:
mysql-community-client-8.0.20-1.el8.x86_64.rpm
mysql-community-common-8.0.20-1.el8.x86_64.rpm
mysql-community-libs-8.0.20-1.el8.x86_64.rpm
mysql-community-server-8.0.20-1.el8.x86_64.rpm

[mysqld]
server-id=54
port=36604
character-set-server=utf8mb4
default-time_zone='+8:00'
lower_case_table_names=1


max_connections=3000
max_connect_errors=100000


default_authentication_plugin=mysql_native_password
datadir=/opt/mysql/data
socket=/opt/mysql/mysql.sock

log-error=/opt/mysql/logs/mysqld.log
pid-file=/opt/mysql/mysqld.pid

binlog_format=ROW
log_bin=/opt/mysql/data/mysql-bin-54.log
binlog_expire_logs_seconds=2592000

long_query_time=1
slow_query_log = 1
slow_query_log_file=/opt/mysql/logs/slow.log

[client]
port=36604
default-character-set=utf8mb4
socket=/opt/mysql/mysql.sock

[mysql]
no-auto-rehash
default-character-set=utf8mb4


第二台配置:

[mysqld]
server-id=56
port=36604
character-set-server=utf8mb4
default-time_zone='+8:00'
lower_case_table_names=1


max_connections=3000
max_connect_errors=100000


default_authentication_plugin=mysql_native_password
datadir=/opt/mysql/data
socket=/opt/mysql/mysql.sock

log-error=/opt/mysql/logs/mysqld.log
pid-file=/opt/mysql/mysqld.pid

binlog_format=ROW
log_bin=/opt/mysql/data/mysql-bin-56.log
binlog_expire_logs_seconds=2592000

long_query_time=1
slow_query_log = 1
slow_query_log_file=/opt/mysql/logs/slow.log

[client]
port=36604
default-character-set=utf8mb4
socket=/opt/mysql/mysql.sock

[mysql]
no-auto-rehash
default-character-set=utf8mb4


mkdir /opt/mysql/logs
chown mysql.mysql /opt/mysql/logs
touch /opt/mysql/logs/mysqld.log
chown mysql.mysql /opt/mysql/logs/mysqld.log


使用logs/mysqld.log中初始化的临时密码登录mysql -uroot -p,修改本地root密码,
alter user'root'@'localhost' IDENTIFIED BY 'PWpw!@12'; 


//创建复制用户
create user 'repl'@'10.110.2.%' identified by 'reple_password';
grant replication slave on *.* to 'repl'@'10.110.2.%';


//在第一台查看binlog状态
show master status;


修改第二台备库:
mysql> change master to
    -> master_host='10.110.2.71',
    -> master_port=36604,
    -> master_user='repl',
    -> master_password='reple_password',
    -> master_log_file='mysql-bin-71.000002',
    -> master_log_pos=979 ;
mysql>start slave;

show slave status\G; //查看从库状态


同样在第二台查看binlog状态,修改第一台从库配置:
show master status;
start slave;
show slave status\G;


mysql远程访问设置:
CREATE USER 'root'@'10.xx.xx.%' IDENTIFIED BY 'newpasswd';
ALTER USER 'root'@'10.xx.xx.%' IDENTIFIED WITH mysql_native_password BY 'newpasswd';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.xx.xx.%' WITH GRANT OPTION;
flush privileges;


status //查看版本

  • 0
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值