[ale] MySql Replication

Christopher Fowler cfowler at outpostsentinel.com
Tue Jul 1 10:46:01 EDT 2003


I read into the documentation and it seems that now, you can not
do this sort of thing with MySQL.  You may can do it with
Oracle.  The idea is that the Buford location is in Buford of course
over a DSL line.  I would like to use it when at home instead of having
to do all my stuff using the Alpharetta database.

Another issue is a time issue.  I am using Mantis which creates a
unique id for each entry.  Mantis is not programmed for multi-database
use like I would want.  Right now, it just is not possible to
use the bose Alpharetta and Buford as editable databases.


On Tue, Jul 01, 2003 at 10:44:42AM -0400, attriel wrote:
> > ------------------------
> > | Master In Alpharetta |
> > ------------------------
> >           |
> >           |
> >           |
> >   Slaves  |
> >   ----------------------
> >   |                    |
> >   Alpharetta        Buford
> >
> >
> > Is it possible to modify data in the slaves and
> > that data be modified in the master?  I
> > think I remeber that you had to allways
> > modify the master
> 
> AFAIR, no.  You have to modify the master, the slaves basically allow you
> to distribute querying (so, if you get a LOT of requests, but no so many
> updates) ...
> 
> For some of the stuff I'm trying to do, multi-master systems would be
> useful, and I remember talking to someone last year who said it was
> possible IF you add a new field for all tables "serverid" that is
> auto-filled by each server with it's own ID, then the uniqueness of
> whatever column is extended to include the serverid as well (b/c the
> auto-inc fields won't be unique anymore, since two servers might be
> serving at the same time)
> 
> Then there was some other problem with that scheme that I didn't follow
> (being why I haven't set this up yet :/)
> 
> If you get any more tips, let us know :)
> 
> --attriel
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale
_______________________________________________
Ale mailing list
Ale at ale.org
http://www.ale.org/mailman/listinfo/ale





More information about the Ale mailing list