MySQL Master-slave replication

0. Common commands

12345678

删除表中所有数据truncate 表名;reset master; 清除所有的bin-log日志show master status;查看授权用户show grants for[email protected];重启Mysqlpkill mysqld

1.Mysql Licensing

12	grant all on *.* to ‘user1‘@192.168.10.2 identified by ‘pass‘;selectuser,host,password from mysql.user;

2.Mysql master-slave replication

123	change master to master_host=‘192.168.10.1‘, master_user=‘slave‘, master_password=‘test.com‘, master_log_file=‘mysql-bin.000007‘, master_log_pos=334;start slave;show slave status\G

3.Mysql Manual Backup

1	/usr/local/mysql/bin/mysqldump-uroot -p123 test-l -F ‘/tmp/test.sql‘

4.Mysql bin-log Log Manual recovery

1	/usr/local/mysql/bin/mysqlbinlog--no-defaults mysql-bin.000002 | /usr/local/mysql/bin/mysql-uroot -p123 test

5.Mysql Database Recovery

1	/usr/local/mysql/bin/mysql-uroot -p123 test</tmp/test.sql

MySQL Master-slave replication