Sounds very biblical. :) Wouldn't there be a way to do this with two copies of mysql that share a common data dir? I don't know if you could do that with InnoDB, but I wonder if you could with myisam? At least if you had a system where the two sets of tables came from a different master, and there was no overlap, or if the slave was just functioning as a backup, maybe it would be possible and not lead to too much horror?
Thanks, Eric At 01:59 PM 8/24/03 -0700, Jeremy Zawodny wrote: >On Sun, Aug 24, 2003 at 09:03:16PM +0000, [EMAIL PROTECTED] wrote: >> Hi, >> >> I am running MySQL V4.0.14 with replication. >> >> >> I want to replicate specified databases from 2 different masters into one >> slave. Is this possible? > >No. > >A slave may only have one master. >-- >Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! ><[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > >MySQL 4.0.13: up 23 days, processed 1,072,854,858 queries (536/sec. avg) > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > (250) 655 - 9513 (PST Time Zone) "Inquiry is fatal to certainty." -- Will Durant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]