It can be done. The slave server needs to hold mutiple slave databases corresponding to the masters. Each slave instance needs to be start separately. For example, each database wil need it's own my.cnf file holding with port the master is connecting to. I have seen this done with full databases, I am not to sure about selecting tables from MAsters to replicate
hope that helps. -chad On Fri, 22 Feb 2002 15:20:52 +0100 [EMAIL PROTECTED] wrote: > query > Is it possible to set one SLAVE to handle two or multiple MASTERS??? > For example if I want to replicate one table from one MASTER and > second table from another. > > Thanx a lot > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
