[opencms-dev] how to use two database instances

[Schliemann, Kai]

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

-----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