Mysql热备份主要分为主从备份和主主备份两种,下面介绍mysql实现主从备份的方法主服务器配置[mysqld]#主从备份log-bin=mysql-binbinlog_fORMat=mixedserver-id=1read-only=0b
Mysql热备份主要分为主从备份和主主备份两种,下面介绍mysql实现主从备份的方法
主服务器配置
[mysqld]
#主从备份
log-bin=mysql-bin
binlog_fORMat=mixed
server-id=1
read-only=0
binlog-do-db=mydb
binlog-ignore-db=mysql
binlog-ignore-db=test
binlog-ignore-db=information_schema
binlog-ignore-db=performance_schema
#双主备份
#auto-increment-increment=10
#auto-increment-offset=1
从服务器配置
[mysqld]
#主从备份
#log-bin=mysql-bin
#binlog_format=mixed
server-id=2
replicate-do-db=mydb
replicate-ignore-db=mysql
replicate-ignore-db=test
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema
replicate-wild-ignore-table=mydb.000%
replicate-wild-ignore-table=mydb.tmp%
replicate-wild-ignore-table=mysql.%
replicate-wild-ignore-table=test.%
replicate-wild-ignore-table=information_schema.%
replicate-wild-ignore-table=performance_schema.%
relay_log=mysql-relay-bin
log-slave-updates=ON
在mysql中创建一个备份用户
grant replication slave on *.* to 'backup'@'192.168.0.42' identified by '123456';
在从服务器中开启主从备份
mysql> CHANGE MASTER TO
MASTER_HOST='192.168.0.41',
MASTER_USER='backup',
MASTER_PASSWord='123456',
MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=106;
主从备份开启后,重启mysql服务即可
sudo service mysql restart
--结束END--
本文标题: mysql怎么实现热备份
本文链接: https://www.lsjlt.com/news/114022.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0