MySQL Forums
Forum List  »  NDB clusters

Re: Distributed database - when will this be possible?
Posted by: Mikael Ronström
Date: February 14, 2006 04:35AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Distributed database - when will this be possible?
1439
February 14, 2006 04:35AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.