MySQL Forums
Forum List  »  Replication

How to setup another slave without '--dump-slave' option?
Posted by: feng guo
Date: June 01, 2014 07:54PM

Yes,I knew with mysqldump's '--dump-slave' option things will be much easy,but I wonder how could I setup another slave just by 'show slave status'?
When using 'show slave status',it will print out these useful:
-----------------------------------------------------------------
Master_log_file:F1
Read_Master_Log_Pos:N1
.........................
Relay_Master_log_file:F2
...........................
Exec_Master_Log_Pos:N2
.......................
-----------------------------------------------------------------
My question is:When I run command--“change master to” in new slave,which binlog file and position will I use as listed above? F1 or F2?N1 or N2?

I just do one thing all my life--do things interesting me!
Blog: www.leafonsword.org

Options: ReplyQuote


Subject
Views
Written By
Posted
How to setup another slave without '--dump-slave' option?
1755
June 01, 2014 07:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.