Shulou(Shulou.com)06/01 Report--

1. Launch instances 3306 and 3307

2. Check the master library configuration

[root@client 3306]# egrep "log-bin|server|sock" my.cnf

socket = /data/3306/mysql.sock

socket = /application/mysql-5.5.32/tmp/mysql.sock

#socket = /data/3306/mysql.sock

log-bin = /data/3306/mysql-bin

server-id = 1

Check if the configuration works

[root@client 3306]# mysql -S /application/mysql-5.5.32/tmp/mysql.sock -e "show variables like 'log_bin'"

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

| Variable_name | Value |

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

| log_bin | ON |

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

3. Check the slave library configuration

[root@client 3307]# egrep "log-bin|server|sock" my.cnf

socket = /data/3306/mysql.sock

socket = /application/mysql-5.5.32/tmp/mysql.sock

#socket = /data/3306/mysql.sock

log-bin = /data/3306/mysql-bin

server-id = 1

4. Main library configuration

mysql>grant replication slave on *.* to 'rep'@'%' identified by 'oldboy123'

mysql>flush privileges

mysql>flush table with read lock

mysql> show master status;

mysqldump -S /application/mysql-5.5.32/tmp/mysql.sock -A -B --events --master-data=2 > /tmp/rep1.sql

mysql>unlock tables

5. Restore slave library

mysql -S /data/3307/mysql.sock

show slave status \G;

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

Slave_IO_State: Waiting for master to send event

Master_Host: 192.168.12.200

Master_User: rep

Master_Port: 3306

Connect_Retry: 60

Master_Log_File: mysql-bin.000016

Read_Master_Log_Pos: 421

Relay_Log_File: relay-bin.000002

Relay_Log_Pos: 253

Relay_Master_Log_File: mysql-bin.000016

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

Replicate_Do_DB:

Replicate_Ignore_DB: mysql

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: 421

Relay_Log_Space: 403

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.