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