Each slave can only have one master. If you want to have one box be a slave to multiple masters, you have to set up a mysqld for each master on the slave box, each with a different port and socket.
Now, if this is on Linux, you also can't have the multiple servers share data on this one box, since MySQL doesn't support file locking on Linux. The servers have to be completely independent from one another. james montebello On Fri, 22 Feb 2002 [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
