On Thu, Sep 06, 2001 at 10:44:28AM -0700, Duc Chau wrote:
>
> Hi, can someone tell me how the index number on the bin logs are
> incremented?
They are incremented by adding one to the extension.
001 -> 002 -> 003 -> 004
and so on.
> When i update my master machine the changes are still going to
>
> $machine-name-bin.001
"update" in what way?
> on my slave
>
> its looking for Log_file
>
> $machine-name-bin.002
The slave is expecting .002 on the master? Or is the slave also
logging to a binary log of its own, but with a different name?
> can someone tell me how these number are incremented? the .00# how
> often, what causes them to increment?
Causes:
* Server Restart
* FLUSH LOGS
* The current log hits the max log size (in my.cnf)
There may be others, but those jump to mind.
> also another question is:
>
>
> what happends when the slave machine is rebooted? when it (slave)
> comes back up does the slave update the database with all the
> inserts, deletes that happended in the time it took to boot up?
Yes, it catches up.
> I tried rebooting the slave and updating the master and when the
> slave came back up it was just in a state of waiting for new
> changes.......it did not populate the missing data. Did i do
> something wrong?
Maybe you did something wrong, yes. It normally works. Did you check
the error log on the slave to see what (if anything) happened?
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 1 days, processed 18,969,193 queries (191/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
