MySQL Master-Slave construction (1)

Master on authorization from the library:

```
Grant Replication Slave on * * to [e-mail protected] identified by ' password ';
```

Logical Backup:

```
Mysqldump--single-transaction--master-data Database-uroot-ppassword
|gzip > Database_backup.sql.zip
```

Extract:

```
Gunzip-c database_backup.sql.zip > Database_backup.sql
```

Import the exported data into the slave server,

```
MYSQLADMIN-UROOT-P CREATE DATABASE && mysql-uroot-p database <database.sql
```

Restart slave Mysql to do the following:

```
Mysql-uroot-p

Change Master to master_host= ' IP ', master_user= ' slave1 ', master_password= ' password ', master_port=3306, Master_log_ File= ' mysql-bin.000021 ', master_log_pos=12312123123; (between Database.sql file 30-40 lines)

Slave start;

Show Slave Status\g
```

There are two yes, the configuration is successful,
Slave_io_running:yes
Slave_sql_running:yes

MySQL Master-Slave construction (1)