Hi,
Much of what you're looking for is found in the latest 5.1.6 release.
However conflict resolution for geographical replication isn't.
Rgrds Mikael
Dave Graham wrote:
> Hi,
>
> I was just wondering if this is possible with the
> latest release of MySQL, and if not when will the
> functionality be there to make this possible.
>
> I'm looking for the ability to have a database
> that is clusterable in a LAN type scenario - and
> for it to be very tight, fast (instantaneous, if
> possible) clustering. In this setup I'd like to be
> able to fire queries at ANY of the machines in
> this LAN cluster arrangement (reads & writes)
> and have the queries executed successfully and the
> machines to be kept in sync with any conflicts
> handled properly.
>
> Basically, i'd like to be able (in a LAN context)
> to have several physical database machines and
> effectively treat them an ONE single, virtual
> database. The database will be quite large (~5Gb),
> so it needs to be stored on disk (i.e. not in
> memory).
>
> OK, that seems fairly simple enough. The
> complication comes in because I'd like to set up
> several geographically dispersed (i.e. WAN)
> clusters of the arrangement described above and
> have them kept in sync with each other in a MULTI
> MASTER scenario - i.e. queries (read AND write)
> can be run at *any* of the geographically
> dispersed clusters simultaneously (i.e. all the
> WAN cluster nodes are active - this is NOT a
> failover scenario) and all the databases are kept
> in sync - obviously this would be based on some
> kind of replication model, so the syncing will be
> slow compared to that in the LAN model. The
> important thing is that any & all conflicts
> are handled properly.
>
> I want to try to eliminate any single points of
> failure in the system, so if there are any
> machines that have "elevated roles" (i.e. if a
> particular machine in the LAN cluster handles the
> WAN replication etc), then these roles must be
> switchable in the case that the elevated machine
> dies. Other than that, all machines should
> effectively be peers.
>
> Does anyone know if this is possible?
> Cheers,
> Dave
>
>
>
> Edited 1 times. Last edit at 02/13/06 07:17PM by
> Dave Graham.
Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog:
http://mikaelronstrom.blogspot.com