List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:July 29 2012 10:42am
Subject:Re: How often the slave to pull data from master?
View as plain text  

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


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
How often the slave to pull data from master?Zhigang Zhang26 Jul
  • Re: How often the slave to pull data from master?Johan De Meersman26 Jul
  • Re: How often the slave to pull data from master?Keith Murphy26 Jul
    • RE: How often the slave to pull data from master?Rick James26 Jul
      • Re: How often the slave to pull data from master?Shawn Green26 Jul
        • RE: How often the slave to pull data from master?Zhigang Zhang29 Jul
          • Re: How often the slave to pull data from master?Reindl Harald29 Jul
          • Re: How often the slave to pull data from master?Shawn Green30 Jul
            • RE: How often the slave to pull data from master?David Lerer30 Jul
              • Re: How often the slave to pull data from master?Shawn Green30 Jul
                • RE: How often the slave to pull data from master?David Lerer31 Jul
                • RE: How often the slave to pull data from master?Rick James1 Aug
                  • Re: How often the slave to pull data from master?Shawn Green1 Aug
                    • RE: How often the slave to pull data from master?Rick James1 Aug
  • Re: How often the slave to pull data from master?Keith Murphy29 Jul