> -----Original Message----- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 14, 2003 4:00 PM > To: Ross Davis - DataAnywhere.net > Cc: [EMAIL PROTECTED] > Subject: Re: Design feature or bug > > > 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.
I stand corrected. In a production environment a stopped server is as good as crashed. > > > 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. They are logically seperated. The only problem is that we have to occasionally do a mass update from the other table and that is when it all messes up. I know why things work they way they do, but it would be nice to have an option to change the replication scheme on certain databases/tables so that things like this could occur. The big table on the master that I don't want at the slave is very large and the slave only needs a bit of the data and it connects over dialup! Replicating the whole thing would be to much bandwidth for my dialup line. I will just have to be very careful. Ross > > 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
