mysql主從資料庫操作

主：

show master status;

+-----------------+------------+-------------------+-----------------------+

| File                |
Position     | Binlog_Do_DB   | Binlog_Ignore_DB |

+-----------------+------------+-------------------+-----------------------+

|    log.000003
|           98  | repl                 |
mysql                    |

+-----------------+------------+-------------------+-----------------------+

從：

slave stop;

change master to
master_host='192.168.1.222',master_user='repl',master_password='123456',
master_log_file='log.000003' ,master_log_pos=98;

slave start;

show slave
status/G;

 

其它基本配置google一片