Hi,
With all the recent talk about replication, just wondering if there are
any others out there who have experience replicating BDB tables?
My experience so far has been that the slave instance of MySQL has been
crashing once in a while, when applying perfectly legitimate DELETE queries
on the replicated BDB tables.
MySQL then restarts after the crash, but not without spewing out various
BDB Log Sequence errors etc in the log when trying to recover.
On restarting, the same query causes an error on the affected table again,
and the only way to get things going again is to convert BDB -> MyISAM ->
BDB, then SLAVE START.
This of course does not bode well on a production system where the slave
acts as a hot backup just in case :)
Just sharing my experience so far :) Anyone else got anything to share?
Some other questions :
1. Does anyone know the behaviour of BDB recovery for such cases i.e. table
crashes, log sequence errors etc?
2. What happens to BDB tables on shutdown/startup i.e. is the transaction
log flushed etc?
Any comments welcome! Thanks.
Cheers,
Geoffrey
__________________________________________________
Geoffrey Soh, Software Architect
Ufinity - http://www.ufinity.com
Leading Enterprise Access Management Software!
9 Scotts Road, Pacific Plaza, #06-01, Singapore 228210
Tel : +65 830-0341
Fax : +65 737-0213
__________________________________________________
---------------------------------------------------------------------
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
