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 |
+------------------------------------------------------------------+
