Mysql主從搭建(2)-熱備-不鎖表

標籤：

Master上授權從庫：

```
grant replication slave on *.* to [email protected] identified by ‘password‘;
```

 

基於資料庫hotcopy備份指令碼處理:

```

[[email protected] 20150806104509]# ls
backup-my.cnf SSS  ibdata1 ib_logfile0 ib_logfile1 abc  xtrabackup_binlog_info xtrabackup_binlog_pos_innodb xtrabackup_checkpoints xtrabackup_galera_info xtrabackup_info xtrabackup_logfile

[[email protected] 20150806104509]# cat xtrabackup_binlog_pos_innodb
mysql-bin.000043774365349

```

 

```
service mysql stop
rm -rf /var/lib/mysql/ib*
rm -rf /var/lib/mysql/abc
rm -rf /var/lib/mysql/SSS

cp -r /data/20150806104509/abc  /data/20150806104509/SSS ib* /data/mysql (將備份資料scp到slave上)

chown -R mysql:mysql /data/mysql (授權mysql使用者)

service mysql start
```

 

重啟slave Mysql，進行以下操作：

```
mysql -uroot -p

change master to master_host=‘ip‘, master_user=‘slave1‘, master_password=‘password‘, master_port=3306, MASTER_LOG_FILE=‘mysql-bin.000043‘, MASTER_LOG_POS=774365349;

slave start;

show slave status\G
```

出現兩個Yes，配置成功，
Slave_IO_Running: Yes
Slave_SQL_Running: Yes

Mysql主從搭建(2)-熱備-不鎖表