RE: How often the slave to pull data from master?

2012-08-01 Thread Rick James
RBR.) > -Original Message- > From: Shawn Green [mailto:shawn.l.gr...@oracle.com] > Sent: Wednesday, August 01, 2012 12:07 PM > To: Rick James > Cc: David Lerer; Zhigang Zhang; mysql@lists.mysql.com > Subject: Re: How often the slave to pull data from master? > > O

Re: How often the slave to pull data from master?

2012-08-01 Thread Shawn Green
On 8/1/2012 1:13 PM, Rick James wrote: That leads to another question... Does this 'separate cache' contain an extra copy (vs the 'only' copy) of the non-transacted events? I would expect that it must be an extra copy. No. The non-transacted events are applied to the tables they belong to as

RE: How often the slave to pull data from master?

2012-08-01 Thread Rick James
That leads to another question... Does this 'separate cache' contain an extra copy (vs the 'only' copy) of the non-transacted events? I would expect that it must be an extra copy. > -Original Message- > From: Shawn Green [mailto:shawn.l.gr...@oracle.com] > ... > Beginning with 5.5.9, we c

RE: How often the slave to pull data from master?

2012-07-31 Thread David Lerer
Thanks Shawn. Very informative and useful. David. The information contained in this e-mail and any attached documents may be privileged, confidential and protected from disclosure. If you are not the intended recipient you may not read, copy, distribute or use this information. If you have rece

Re: How often the slave to pull data from master?

2012-07-30 Thread Shawn Green
Hello David, On 7/30/2012 11:46 AM, David Lerer wrote: Thanks Shawn. This is very useful. Could you shed some light on how rolled-back transactions (or not-yet-committed transactions for that matter) are treated as far as the binary logs? Are these updates actually go to the binary logs, thus

RE: How often the slave to pull data from master?

2012-07-30 Thread David Lerer
. -Original Message- From: Shawn Green [mailto:shawn.l.gr...@oracle.com] Sent: Monday, July 30, 2012 11:22 AM To: Zhigang Zhang Cc: mysql@lists.mysql.com Subject: Re: How often the slave to pull data from master? On 7/29/2012 12:52 AM, Zhigang Zhang wrote: > Hi >> If there are addition

Re: How often the slave to pull data from master?

2012-07-30 Thread Shawn Green
On 7/29/2012 12:52 AM, Zhigang Zhang wrote: 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? Ye

Re: How often the slave to pull data from master?

2012-07-29 Thread Keith Murphy
Yes, the slave oulls On Jul 26, 2012 4:17 AM, "Zhigang Zhang" wrote: > Hello: > > > > I haven't read the source code of mysql ,but as I know ,the slave get data > from master server, rather than the master push data to slave. > > > > I think there is a timer to do this. > > > > Who can tell me th

Re: How often the slave to pull data from master?

2012-07-29 Thread Reindl Harald
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 ea

RE: How often the slave to pull data from master?

2012-07-28 Thread Zhigang Zhang
awn Green [mailto:shawn.l.gr...@oracle.com] Sent: Friday, July 27, 2012 2:51 AM To: mysql@lists.mysql.com Subject: Re: How often the slave to pull data from master? Hello Rick, You nearly got it all correct. On 7/26/2012 1:21 PM, Rick James wrote: > My understanding is... > > * There is

Re: How often the slave to pull data from master?

2012-07-26 Thread Shawn Green
Hello Rick, You nearly got it all correct. On 7/26/2012 1:21 PM, Rick James wrote: My understanding is... * There is a "permanent" connection (TCP/IP socket) between the Master and each Slave. This is opened by the Slave when the slave starts (or restarts or recovers from a network glitch).

RE: How often the slave to pull data from master?

2012-07-26 Thread Rick James
n traffic. > -Original Message- > From: Keith Murphy [mailto:bmur...@paragon-cs.com] > Sent: Thursday, July 26, 2012 9:45 AM > To: Zhigang Zhang > Cc: mysql@lists.mysql.com > Subject: Re: How often the slave to pull data from master? > > Yes, the slave pulls from the mast

Re: How often the slave to pull data from master?

2012-07-26 Thread Keith Murphy
Yes, the slave pulls from the master. The slave io thread reads the information effectively as soon as it is written to the master's binary log. Keith On Jul 26, 2012 4:17 AM, "Zhigang Zhang" wrote: > Hello: > > > > I haven't read the source code of mysql ,but as I know ,the slave get data > fro

Re: How often the slave to pull data from master?

2012-07-26 Thread Johan De Meersman
- Original Message - > From: "Zhigang Zhang" > > I haven't read the source code of mysql ,but as I know ,the slave get > > I think there is a timer to do this. You have also not read the documentation, then. There is not. Replication is continuous: the slave opens a permanent connectio

Re: how often the slave to pull data from master?

2012-07-26 Thread Yanis Guenane
Please can someone correct me if I am wrong. It doesn't work with timer. On your *master*, you need to activate the binaries log. Everytime and UPDATE/INSERT/DELETE is done on the master mysql server, the event is recorded within those binaries log. On your *slave* - if it is activated to act as