List:General Discussion« Previous MessageNext Message »
From:sasha Date:May 9 2000 11:41pm
Subject:Re: Multi-Master (Was: Replication Capabilities)
View as plain text  
Matthew Costello wrote:
> 
> sasha@stripped wrote:
> 
> > Craig Vincent wrote:
> > >         What about bi-directional updating?  For example I'm in the exact
> same boat
> > > as the original poster.  My necessities for the mirrored databases is that
> > > query load can be split amongst all of them...and more or less the
> databases
> > > keep in constant communication with each other making sure all of them are
> > > up to date with the most recent information regardless of where the
> initial
> > > query went to.  Is that something planned for the future?
> > >
> > > Sincerely,
> > >
> > > Craig Vincent
> >
> > You will probably be able to hack it by telling both servers to slave off each
> > other, but I'll have to think about this one. Eventually it would be nice to
> > have a clean solution for this...
> 
> I've got several databases running multi-master here using 3.22.32 and
> our own version of real-time replication.
> 
> The big problem is that it is not possible to use the AUTO_INCREMENT
> feature of MySQL, and most of our databases use it at least once.
> The alternatives are 1) using a unreplicated sequence table, or 2) an
> external sequence number file; both have limitations.
> 
>     /matthew costello

Try 3.23.15 - it supports replication internally.
-- 
Sasha Pachev

+------------------------------------------------------------------+
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sasha Pachev            |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sasha@stripped  |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Provo, Utah, USA        |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                         |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                        |
|             /*/             \*\ Developers Team                  |
+------------------------------------------------------------------+
Thread
Replication CapabilitiesGary Johnson13 Apr
  • Re: Replication Capabilitiessasha13 Apr
    • Re: Replication CapabilitiesStefan Powell13 Apr
      • Re: Replication Capabilitiessasha13 Apr
        • RE: Replication CapabilitiesCraig Vincent13 Apr
          • Re: Replication Capabilitiessasha13 Apr
            • Re: Replication CapabilitiesStefan Powell13 Apr
          • Multi-Master (Was: Replication Capabilities)Matthew Costello10 May
            • RE: Multi-Master (Was: Replication Capabilities)indrek siitan10 May
          • Re: Multi-Master (Was: Replication Capabilities)sasha10 May
          • Re: Multi-Master (Was: Replication Capabilities)Christof Damian10 May
          • Re: Multi-Master (Was: Replication Capabilities)Ondrej Sury10 May
          • Re: Multi-Master (Was: Replication Capabilities)Christof Damian10 May
        • Re[2]: Replication CapabilitiesBAUMEISTER Alexandre14 Apr
        • Re: Replication Capabilitiessasha14 Apr
          • Re: Replication CapabilitiesTim Bunce10 May
        • Re: Replication Capabilitiessasha11 May
          • Re: Replication CapabilitiesTim Bunce11 May
            • Re: Replication CapabilitiesThimble Smith11 May
          • Re: Replication CapabilitiesKyle Hayes11 May
        • Re: Replication Capabilitiessasha11 May
          • Re: Replication CapabilitiesBenjamin Pflugmann12 May
        • Re: Replication Capabilitiessasha12 May
          • Re: Replication CapabilitiesMichael Widenius13 May
Re: Replication Capabilities(David Sklar)13 Apr
  • Re: Replication CapabilitiesStefan Powell14 Apr
Re: Replication Capabilities(David Sklar)14 Apr
  • Re: Replication CapabilitiesStefan Powell15 Apr
    • Re: Replication CapabilitiesStefan Powell15 Apr
Re: Replication Capabilities(David Sklar)15 Apr
  • Re: Replication CapabilitiesDana Powers17 Apr
    • Re: Replication Capabilitiessinisa18 Apr
      • Re: Replication CapabilitiesDana Powers18 Apr
        • Re: Replication Capabilitiessinisa18 Apr
          • Re: Replication CapabilitiesSteve Ruby18 Apr
        • Re: Replication CapabilitiesScott Hess18 Apr
          • Re: Replication CapabilitiesDana Powers18 Apr
          • Re: Replication CapabilitiesThimble Smith18 Apr
      • Re: Replication CapabilitiesAndreas Vierengel19 Apr
      • Re: Replication Capabilitiessasha19 Apr
        • Re: Replication CapabilitiesDana Powers19 Apr
        • Re: Replication CapabilitiesMichael Widenius25 Apr
          • Re: Replication CapabilitiesTim Bunce25 Apr
            • Re: Replication CapabilitiesMichael Widenius27 Apr