mysql主从架构设置,mysqlbackup在线配置MySQL主从架构

3.2 进行授权，并打开数据库

[root@MySQL02 data]# chmod -R 777 mysql

[root@mysql02 data]# service mysqld start

Starting MySQL [确定]

3.3 从库连接到主库

mysql> CHANGE MASTER TO MASTER_HOST='mysql01',MASTER_USER='server01',MASTER_PASSWORD='server01', MASTER_LOG_FILE='mysql-bin.000003',MASTER_LOG_POS=107;

3.4 启动从库服务

mysql> start slave;

Query OK, 0 rows affected (0.00 sec)

mysql> show slave status\G;

*************************** 1. row ***************************

Slave_IO_State: Waiting for master to send event

Master_Host: mysql01

Master_User: server01

Master_Port: 3306

Connect_Retry: 60

Master_Log_File: mysql-bin.000005

Read_Master_Log_Pos: 1082

Relay_Log_File: mysql02-relay-bin.000003

Relay_Log_Pos: 253

Relay_Master_Log_File: mysql-bin.000005

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

Replicate_Do_DB: john

Replicate_Ignore_DB:

Replicate_Do_Table:

Replicate_Ignore_Table:

Replicate_Wild_Do_Table:

Replicate_Wild_Ignore_Table:

Last_Errno: 0

Last_Error:

Skip_Counter: 0

Exec_Master_Log_Pos: 1082

Relay_Log_Space: 1532

Until_Condition: None

Until_Log_File:

Until_Log_Pos: 0

Master_SSL_Allowed: No

Master_SSL_CA_File:

Master_SSL_CA_Path:

Master_SSL_Cert:

Master_SSL_Cipher:

Master_SSL_Key:

Seconds_Behind_Master: 0

Master_SSL_Verify_Server_Cert: No

Last_IO_Errno: 0

Last_IO_Error:

Last_SQL_Errno: 0

Last_SQL_Error:

Replicate_Ignore_Server_Ids:

Master_Server_Id: 1

1 row in set (0.00 sec)

3.5 经过以上检查主从同步已经没有问题了，需要再验证相应的表数据；

mysql> select * from wzq;

+-------+

| name |

+-------+

| qiang |

| wu |

| zhi |

| 1 |

| 2 |

| 3 |

+-------+

8 rows in set (0.00 sec)

1. 总结：经过验证通过msyqlbackup搭建主从的数据库，可以实现不停机进行搭建，整个过程也是挺简单的，但是是在测试环境中进行的，真正的生产环境还要再考虑详细的步骤。