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]