On Tue, Jan 14, 2003 at 02:43:27PM -0800, Ross Davis - DataAnywhere.net wrote: > I have a 3.23.53 server that is a slave of another 3.25.52 server. > Master has 2 databases on it. > > On the slave only only one of the databases is replicated. > > If I reference the table database that is not on the slave during an > insert or something on the server it crashes the slave!
The slave should not crash, it should merely stop. > Shouldn't the slave replicate the database and not the queries that have > been run? MySQL uses log-based replication. The slave reads a query log (known as the binary log) from the master. It contains all the queries that change any data on the master. The moral of the story is that you should logically separate your databases. If you cannot do that, replicate all related databases--not just some of them. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 30 days, processed 1,011,755,074 queries (380/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
