I need to fetch data from multpiple masters to one slave and I have a
few theoretical questions...

What if I will do "slave stop" query during transfer of data?

Is "Has read all relay log; waiting for the I/O slave thread to update
it" status reliable? If I will depend on it and I will do "slave stop"
after getting this status will there be a possibility to broke the
integrity?

(basic loop lookes like "change master to $1" "slave start", wait for
proper status from processlist, "slave stop", "change master to $2",
"slave start"........ and so on for all off the slaves and the loop
is starting again with remembered values of binlogname and binlogpos
after each "slave stop".

--
Irek Slonina

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to