数据库的备份方式:
1.逻辑备份
2.物理备份(暴力备份)
3.冷备份
4.热备份
在做主从梳理实际项目的过程:
1.开启_主库binlog日志
vi etc/mysql/mysql.conf.d/mysqld.cnf
server-id=1#自定义
log-bin=mysql-bin
2.配置_主库复制账号
/*
创建账号sql:
create user 'username'@'localhost' identified by 'password';
授权
grant [权限] on *.* to 'username'@'localhost' identified by 'password';
*/
mysql> create user 'repl_131'@'%' identified by 'repl_131';
Query OK, 0 rows affected (0.04 sec)
mysql> select user,host from mysql.user;
mysql> grant replication slave on *.* to 'repl_131'@'%' identified by 'repl_131';
Query OK, 0 rows affected, 1 warning (0.00 sec)
3.停止服务-停止写操作开始数据备份(锁住数据库)
flush tables with read lock
开始备份
导出
mysqldump -h 172.10.0.2 -u root -p laravel-shop>/home/laravel-shop.sql
导入
mysql -f -uroot -p laravel-shop</home/laravel-shop.sql
备份建议使用工具 mydumper
4.备份之后,启动服务释放锁
unlock table;
5.从库配置
6.制定ip,port,user
7.启动
8.还原同步主库数据