Updation frequency of a slave ..?

[varungupta_vg81]

Hi

What is the frequency with which the data is updated by the slave from the master.Is there a time lag between the two successive reads by the slave of the master log or is the updation continuous.

In replication environment ,suppose the master goes down and now an existing slave becomes the active master.Now in this case how does one ensure that the log with the this slave is up to date with the most recent updations to carry on as the master.

[Wynder]

In the books that I have, I wasn't able to find the frequency at which the log is transfered. However, since masters are mostly unaware of their slaves, I'd think it might be a slave setting, and there would potentially be a lag inbetween them.

[varungupta_vg81]

Originally posted by Wynder
In the books that I have, I wasn't able to find the frequency at which the log is transfered. However, since masters are mostly unaware of their slaves, I'd think it might be a slave setting, and there would potentially be a lag inbetween them.

Thanx a lot sir for you response. But how does one ensure that the new server is updated with the latest log report when it takes over ??

Thnx
Varun

[Wynder]

Maybe just create a table on the database that drops a timestamp in whenever you sync. So, on the slave, the last timestamp in that table will be the last time it was updated.

It'll have to be something along those lines where each time a sync is done, there will have to be some method of notification -- whether it be emails, a textfile updated on the slave server, or a table in the database.