Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [MYSQLD]
- binlog-format=ROW
- log-bin=binlog
- server-id=1
- CREATE USER 'rep'@'ip slave' IDENTIFIED BY 'pass';
- GRANT REPLICATION SLAVE ON *.* TO 'rep'@'ip slave';
- FLUSH PRIVILEGES;
- [MYSQLD]
- binlog-format=ROW
- log-bin=binlog
- server-id=2
- CHANGE MASTER TO MASTER_HOST='ip master',MASTER_USER='rep', MASTER_PASSWORD='pass', MASTER_LOG_FILE='binlog.000003';
- MariaDB [(none)]> SHOW SLAVE STATUS G;
- *************************** 1. row ***************************
- Slave_IO_State: Waiting for master to send event
- Master_Host: 192.168.231.102
- Master_User: repp
- Master_Port: 3306
- Connect_Retry: 60
- Master_Log_File: binlog.000014
- Read_Master_Log_Pos: 3728
- Relay_Log_File: db2-relay-bin.000017
- Relay_Log_Pos: 552
- Relay_Master_Log_File: binlog.000014
- Slave_IO_Running: Yes
- Slave_SQL_Running: Yes
- Replicate_Do_DB:
- 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: 3728
- Relay_Log_Space: 1155
- 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
- Master_SSL_Crl:
- Master_SSL_Crlpath:
- Using_Gtid: No
- Gtid_IO_Pos:
- Replicate_Do_Domain_Ids:
- Replicate_Ignore_Domain_Ids:
- Parallel_Mode: conservative
- SQL_Delay: 0
- SQL_Remaining_Delay: NULL
- Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
- 1 row in set (0.00 sec)
Add Comment
Please, Sign In to add comment