The problem with Sequoia is that it doesn't support automatic recovery of cluster nodes. Let's say if you reboot one of cluster databases then it won't join cluster when it's back. Then you need to use Sequoia console to synchronize it with cluster. And it works only if you start your databases in the reverse order they were stopped. Otherwise it complains about "not last down" and refuses to start. Even more - sometimes all nodes refuses to start (complaining about wrong order) and there is no way to start your cluster.
But HA-JDBC supports automatic recovery and synchronization. I did many tests trying to break it. I had a small program inserting new records in 4 Derby databases and at the same time I powered off/rebooted some of cluster nodes. HA-JDBC always synchronized database correctly after reboot. I'd recommend using HA-JDBC. Maris -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 29 September 2008 16:31 To: Derby Discussion Subject: Re: Peer replication Donald McLean wrote: > We're working on an application where we have multiple servers and we > need to replicate transactions between the servers to allow failover > and load balancing. I think that this is different from the > replication that Derby supports because it is peer-to-peer rather than > master/slave. Has anyone worked with this sort of replication before? > > Donald > Not sure, but would Sequoia be a good fit for you? Some references, http://sequoia.continuent.org/HomePage The example in this blog uses Derby http://blogs.sun.com/JagadishPrasath/entry/using_sequoia_with_glassfish _____________________________________________________________________ This e-mail has been scanned for viruses by MessageLabs. ********************************************************************** Confidentiality : This e-mail and any attachments are intended for the addressee only and may be confidential. If they come to you in error you must take no action based on them, nor must you copy or show them to anyone. Please advise the sender by replying to this e-mail immediately and then delete the original from your computer. Opinion : Any opinions expressed in this e-mail are entirely those of the author and unless specifically stated to the contrary, are not necessarily those of the authors employer. Security Warning : Internet e-mail is not necessarily a secure communications medium and can be subject to data corruption. We advise that you consider this fact when e-mailing us. Viruses : We have taken steps to ensure that this e-mail and any attachments are free from known viruses but in keeping with good computing practice, you should ensure that they are virus free. Inspired Gaming (UK) Limited Registered in England No 3565640 Registered Office 3 The Maltings Wetmore Road, Burton On Trent, Staffordshire DE14 1SE _______________________________________________________________ This message has been checked for all known viruses by the MessageLabs Virus Control Centre.
