On Thu, Aug 30, 2001 at 12:49:15PM -0400, Luc Foisy wrote:
>
> Has anyone tested dropping a master database?
By accident, yes.
> I have dropped the master database that was replicating just to see
> how it would affect the slave. The slave kept its data.
Was it up-to-date with the master, or was it lagging? Check it's
binary log position and compare with the master's.
> What would the proper proceedure be in this case?
The slave should drop it, too.
> I wouldnt be able to snapshot the slave and then port the snapshot
> back into the master, the bin logs would be messed up then.
But the tables would be intact.
> A note: Nothing occurs in the error log or in SHOW MASTER STATUS on
> the master when a database is dropped that it is supposed to be
> replicating.
What sort of error would you suspect. Why should you not be able to
drop and re-create a database that is being replicated? I've had
cases where that's a "normal" thing to do. It's just like dropping a
table, but you're dropping a collection of tables, right?
> Does it not realize that the database is not there?
Replication does not care. I think you just have to work with it a
bit to understand what it's "thinking" but it makes sense in the
end. :-)
> If I was only replicating one database (bin logging one database),
> could I just port in a copy from the slave, remove the bin logs and
> index(or modify it in some way) from the master, do something with
> the master.info on the slave and then let it go from there?
If you're sufficiently clever, yes, that'll work...
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 16,269,693 queries (139/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
