Am 29.07.2012 06:52, schrieb Zhigang Zhang: > Hi >> If there are additional events beyond that, it > retrieves those in sequence after it writes the current statement into > the relay logs. > > I have a question about this: > Whether the slave is sent a signal whenever the master generates each event?
they are speaking to each other what you can easily see with "show prcoesslist" and since you can restart the master at any time and the slave will reconnect withut any interaction it is clear how it works _______________________ master: | 2060363 | replication | 10.0.0.106:40047 | NULL | Binlog Dump | 1363 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL | _______________________ slave: | 1 | system user | | NULL | Connect | 4 | Slave has read all relay log; waiting for the slave I/O thread to update it | NULL | | 2 | system user | | NULL | Connect | 1399 | Waiting for master to send event
signature.asc
Description: OpenPGP digital signature