[opencms-dev] how to use two database instances

[David Goodenough]

On Wednesday 22 September 2010, Schliemann, Kai wrote:
> Hi David,
> this sounds very interesting. Have you tried this with OpenCms?
> If so, it would be nice, if you could tell us, how you did it (either in
> the mailing list or in the OpenCms wiki (www.opencms-wiki.org)
> 
> TIA
> Kai
I have not used it with opencms, but I have used it with other Java
webapps.  It behaves like any other JDBC driver, so you include the JAR
in the classpath, and either set up the Datasource to use the driver
or tell the webapp to use the driver (as appropriate).  I see no reason
why it should not work with opencms.

David
> 
> -----Ursprüngliche Nachricht-----
> Von: opencms-dev-bounces at opencms.org
> [mailto:opencms-dev-bounces at opencms.org] Im Auftrag von David 
Goodenough
> Gesendet: Mittwoch, 22. September 2010 10:40
> An: opencms-dev at opencms.org
> Betreff: Re: [opencms-dev] how to use two database instances
> 
> On Tuesday 21 September 2010, Achim Westermann wrote:
> > Hi Kareem, Yves,
> > 
> > On 09/22/2010 12:18 AM, Yves Glodt wrote:
> > > OpenCms can not switch from one database instance to another 
without
> > > editing opencms.properties and restarting your container.
> > 
> > Of course it cannot. If it would be able to it had to perform all write
> > operations to all switchable database instances.
> > Yves tip to use drdb / heartbeat sounds reasonable. But also a mysql
> > cluster with a load balancing jdbc driver
> > 
(http://blogs.sun.com/carriergrademysql/entry/how_to_use_jdbc_connector)
> > could do this.
> > 
> > I myself often used ocee cluster & replication with apache and mod_jk
> > load balancing in front. In that setup not only all but one db may fail
> > but also all but one application server may fail.
> > 
> > HTH,
> > Achim
> > 
> > _______________________________________________
> > This mail is sent to you from the opencms-dev mailing list
> > To change your list options, or to unsubscribe from the list, please
> > visit http://lists.opencms.org/mailman/listinfo/opencms-dev
> 
> Have you looked at HA-JDBC.  It does all this without change to the
> application, and can even handle mixed DBs (one mysql another 
postgresql).
> 
> David
> 
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
> 
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev