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]

Reply via email to