mysql 5.7 双主+主从配置
2024-08-31 14:43:30
- mysql5.7安装及赋权
wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
rpm -ivh mysql57-community-release-el7-.noarch.rpm rm -f mysql57-community-release-el7-.noarch.rpm yum -y remove mysql-libs.x86_64 yum install mysql-server -y
service mysqld start
mysql -p$(grep "password" /var/log/mysqld.log|awk '{print $NF}') SET PASSWORD = PASSWORD('Asd123.com');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
grant all privileges on *.* to root@"%" identified by "Asd123.com";
grant all privileges on *.* to root@"localhost" identified by "Asd123.com";
flush privileges;
quit service mysqld restart
- 配置文件模板
[client]
default-character-set=utf8 [mysqld]
character-set-server = utf8
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
lower_case_table_names=1
explicit_defaults_for_timestamp=true
read_only=1 server_id = 241
sync_binlog=1
log_bin = mysql-bin
binlog-format = row
log-slave-updates = 1
auto_increment_increment = 2
auto_increment_offset = 2 symbolic-links=0 log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
注意:serverid 必须不一样,auto_increment_offset 和auto_increment_increment 做双主需要配置,只做主从不需要。
- 同步配置
mysql -uroot -pAsd123.com GRANT REPLICATION SLAVE ON *.* TO 'repl'@'192.%' IDENTIFIED BY 'Asd123.com';
flush privileges; change master to
master_host = '192.168.1.240',
master_user = 'repl',
master_password = 'Asd123.com',
master_log_file = 'mysql-bin.000005',
master_log_pos = 154; change master to
master_host = '192.168.1.241',
master_user = 'repl',
master_password = 'Asd123.com',
master_log_file = 'mysql-bin.000003',
master_log_pos = 603; show slave status\G
最新文章
- 【GoLang】类型和作用在它上面定义的方法必须在同一个包里定义
- SharpGL学习笔记(十七) 立体文字和平面文字
- paper 81:HDR成像技术
- Design T-Shirt 分类: HDU 2015-06-26 11:58 7人阅读 评论(0) 收藏
- Lock锁
- js中变量的连续赋值
- dedecsm系统(企业简介)类单栏目模版如何修改和调用整理
- 剑指架构师系列-Redis安装与使用
- 【代码总结● Swing中的一些操作与设置】
- Windows服务器如何查看共享目录信息
- Linux centos yum仓库 自制
- 服务器端配置nodejs环境(使用pm2进程管理运行)
- 第17章 社区快速入门和模板 - Identity Server 4 中文文档(v1.0.0)
- 【Java多线程】线程状态、线程池状态
- 在myeclipse上发布自己的webservice
- 8.2,常用模块介绍:sys,os,time,random
- mysql中删除binlog的方法?mysql中如何删除binlog?
- c#编写远程控制的核心被控端操作类
- struts1.x和struts2.x之间的一些区别
- C# unsafe模式内存操作深入探索