Re: Mast-Master Replication
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]
Re: Mast-Master Replication
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]
Re: Mast-Master Replication
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]
RE: Mast-Master Replication
You can do it if you can handle primary key violations and don't have auto_increment columns in your tables. Race conditions can occur. -->-Original Message- -->From: Sanya Shaik [mailto:[EMAIL PROTECTED] -->Sent: Wednesday, August 20, 2003 6:11 AM -->To: [EMAIL PROTECTED] -->Subject: Re: Mast-Master Replication --> -->Well , what I want is the second server to take the place of the first -->one in case of any problems with the master without having to come to a -->stand still --> -->Jeremy Zawodny <[EMAIL PROTECTED]> 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. --> -->If the second server is merely standby, you probably want master/slave -->rather than master/master. -->-- -->Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! -->| http://jeremy.zawodny.com/ --> -->MySQL 4.0.13: up 18 days, processed 911,623,980 queries (570/sec. avg) --> --> -->- -->Do you Yahoo!? -->The New Yahoo! Search - Faster. Easier. Bingo. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Mast-Master Replication
I think you also want what ever the standby master gets a write /*assuming that the primary master where to go down or some other reason*/ the submaster needs to replicate that insert so In /etc/my.cnf Use log-bin server-id= log-slave-updates replicate-* = -->-Original Message- -->From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] -->Sent: Tuesday, August 19, 2003 10:38 PM -->To: Sanya Shaik -->Cc: [EMAIL PROTECTED] -->Subject: Re: Mast-Master Replication --> -->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. --> -->If the second server is merely standby, you probably want master/slave -->rather than master/master. -->-- -->Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! --><[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ --> -->MySQL 4.0.13: up 18 days, processed 911,623,980 queries (570/sec. avg) --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Mast-Master Replication
You're going to need to architect more than just a master-slave relationship to do what you want to do. All replication does is copy commands from one MySQL server to the other; it does not create a failover environment by itself. Creating a failover environment is beyond the scope of MySQL; you'll need to handle things like fault detection of the master server, redirecting traffic from the master to the slave when a fault occurs, and ensuring that you don't "flap" connections between master and slave (i.e. when you switch over to the slave, you don't switch back to the master without bringing the master back up to date first). You also need to take care of the double failure case and probably many other corner cases I haven't listed. In short, MySQL's failover is *not* a multiple-master replicated database system like Oracle Parallel Server. There's a reason why the latter is so pricey. :-) --Michael > -Original Message- > From: Sanya Shaik [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 20, 2003 6:11 AM > To: [EMAIL PROTECTED] > Subject: Re: Mast-Master Replication > > > Well , what I want is the second server to take the place of > the first one in case of any problems with the master without > having to come to a stand still > > Jeremy Zawodny <[EMAIL PROTECTED]> 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. > > If the second server is merely standby, you probably want > master/slave rather than master/master. > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > | http://jeremy.zawodny.com/ > > MySQL 4.0.13: up 18 days, processed 911,623,980 queries (570/sec. avg) > > > - > Do you Yahoo!? > The New Yahoo! Search - Faster. Easier. Bingo. > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mast-Master Replication
Well , what I want is the second server to take the place of the first one in case of any problems with the master without having to come to a stand still Jeremy Zawodny <[EMAIL PROTECTED]> 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. If the second server is merely standby, you probably want master/slave rather than master/master. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! | http://jeremy.zawodny.com/ MySQL 4.0.13: up 18 days, processed 911,623,980 queries (570/sec. avg) - Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo.
Re: Mast-Master Replication
Sanya Shaik <[EMAIL PROTECTED]> 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. Master-master? Do you mean circle replication A <---> B or what ? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mast-Master Replication
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. If the second server is merely standby, you probably want master/slave rather than master/master. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 18 days, processed 911,623,980 queries (570/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
