-rw-r--r--. 1 root root 2887406 Jul 12 22:24 192.168.199.178.sql mysql> start slave; 192.168.199.177:
[root@Master-Mysql ~]# /usr/local/mysql/bin/mysql -uroot -p'' < /tmp/192.168.199.178.sql #如果主、从一致非必须
mysql> update mysql.user set password=PASSWORD('admin') where user='root';
[root@Master-Mysql ~]# cat |/usr/local/mysql/bin/mysql -uroot -p'admin' <
> MASTER_HOST='192.168.199.178', > MASTER_PORT=3306, > MASTER_USER='byrd',
> MASTER_PASSWORD='admin',
> MASTER_LOG_FILE='mysql-bin.000004', > MASTER_LOG_POS=120; > EOF
mysql> start slave;
mysql> show slave status＼G
*************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 192.168.199.178 Master_User: byrd Master_Port: 3306 Connect_Retry: 60
Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 938
Relay_Log_File: mysqld-relay-bin.000002 Relay_Log_Pos: 1101
Relay_Master_Log_File: mysql-bin.000004 Slave_IO_Running: Yes Slave_SQL_Running: Yes Last_Errno: 0 Skip_Counter: 0 Exec_Master_Log_Pos: 938 Relay_Log_Space: 1275 Until_Condition: None Until_Log_Pos: 0 Master_SSL_Allowed: No Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_SQL_Errno: 0 Master_Server_Id: 2
Master_UUID: 34d672c3-d292-11e3-9ff5-00155dc7834c Master_Info_File: /usr/local/mysql/data/master.info
SQL_Delay: 0 --phpfensi.com SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
Master_Retry_Count: 86400 测试:192.168.199.177:
mysql> use hitest;
mysql> CREATE TABLE `ces` (
-> `REL_ID` bigint(12) NOT NULL auto_increment COMMENT 'id', -> `TITLE` varchar(255) NOT NULL COMMENT 'biaoti', -> PRIMARY KEY (`REL_ID`)
-> ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; mysql> insert into ces(TITLE) values('test'); mysql> insert into ces(TITLE) values('test'); mysql> insert into ces(TITLE) values('test'); mysql> insert into ces(TITLE) values('test25'); mysql> select * from ces; +--------+-------+ | REL_ID | TITLE | +--------+-------+ | 1 | test | | 3 | test | | 5 | test | | 25 | test25| +--------+--------+
3 rows in set (0.03 sec) 192.168.199.178: mysql> use hitest;
mysql> insert into ces(TITLE) values('test26'); mysql> insert into ces(TITLE) values('test28'); mysql> insert into ces(TITLE) values('test30'); mysql> select * from ces; +--------+--------+ | REL_ID | TITLE | +--------+--------+ | 1 | test | | 3 | test | | 5 | test | | 26 | test26 | | 28 | test28 | | 30 | test30 | +--------+--------+
17 rows in set (0.00 sec)
说明:如果一主、一丛已经做好,只要知道从库位置点(show master status;)、然后之前主库执行(CHANGE MASTER)、之前主库开启slave(start slave)即可,其中数据库备份等步骤可以省略,如果主从有一些数据库不一致则同上操作.