On Wed, Mar 20, 2002 at 11:51:47AM -0000, Rob Moore wrote: > Jeremy > > >>You can set it up so that the slave only gets updates to certain > >>databases. Have you looked at the replication docs in the manual yet? > > Yes I did, but what put me off slightly was the concept of a master > and slave. My requirement is per sql database not per sql server. > Am I being stoopid or is this configuration possible:- > > > Web Server Local Server > > DB1 >>>>>>>>>>>> copy of DB1 > copy of DB2 <<<<<<<<<<<< DB2
That will work. Each server just needs to be a slave of the other. 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.47-max: up 41 days, processed 1,236,930,317 queries (346/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