From: Reindl Harald
Date: July 29 2012 10:42am
Subject: Re: How often the slave to pull data from master?
List-Archive: http://lists.mysql.com/mysql/227906
Message-Id: <5015137E.7050206@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enigE63DE66AA23BA66EE0208D6C"

--------------enigE63DE66AA23BA66EE0208D6C
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



Am 29.07.2012 06:52, schrieb Zhigang Zhang:
> Hi=20
>> If there are additional events beyond that, it=20
> retrieves those in sequence after it writes the current statement into =

> the relay logs.
>=20
> I have a question about this:
> Whether the slave is sent a signal whenever the master generates each e=
vent?

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 a=
ll relay log; waiting for the slave I/O
thread to update it | NULL             |
|  2 | system user |           | NULL | Connect | 1399 | Waiting for mast=
er to send event


--------------enigE63DE66AA23BA66EE0208D6C
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAlAVE34ACgkQhmBjz394AnnV8gCfeciMuB1frGzoMrS81DIAz++X
en8AniPETxCxNo45GkqBnv2rOD6Ys1O8
=FOHs
-----END PGP SIGNATURE-----

--------------enigE63DE66AA23BA66EE0208D6C--