Hi, I wish I could use that more, but load data from master locks everything all at once, then you have to wait for the transfer, making it not a great idea to use on a busy live/big database. I can do a back up localy and then transfer the data with a lot less locked time. Still, the times I have used load data from master, it is pretty cool how fast it goes. If the database isn't live and large :) it is defiantly a cool way to do your setup.
Thanks, Eric At 01:33 PM 8/20/03 -0500, Hans van Harten wrote: >Jeremy Zawodny wrote: >> On Tue, Aug 19, 2003 at 01:52:26PM -0700, Sanya Shaik wrote: >>> I am unable to find any information about master-master replication. >>> I need to replicate 1 mysql server over to other as a standby master >>> server. >It's named circular master-slave ... >http://www.mysql.com/doc/en/Replication_Features.html > >> If the second server is merely standby, you probably want master/slave >> rather than master/master. >Having a master available while rebuilding the primairy server allows 'load >data from master' to rebuild the db. > >HansH > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > >________________________________________________________________________ >This email has been scanned for all viruses by the MessageLabs Email >Security System. For more information on a proactive email security >service working around the clock, around the globe, visit >http://www.messagelabs.com >________________________________________________________________________ > >-- >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]
