On Mon, Jan 14, 2002 at 11:56:39AM +0200, Richard Ward wrote: > The short: > > Is it possible to do replication from server a and server b to > server c. ie. have two data collection points (a and b) both > replicating data to server c where queries and reports are created.
A slave can only have one master. You can run multiple instances of MySQL on the slave, and then have each one be the slave of a different master. But that's probably not what you want. You *might* be able to have both slaves share the same data directory, but that'd be rather tricky. You'd need to make sure they use external locking, and there'd be a fair amount of other stuff to get Just Right before it'd work reliably. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 11 days, processed 268,338,993 queries (266/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
