[opencms-dev] Can different installations of OpenCms connect to the same db schema?

[Achim Westermann]

Hi Shency,

regarding point 2: That is not possible I think. One problem is that caches are cleared inside the webapp when something is published. The 
other opencms instance would not know it. There must not be more than one workplace log in for the same database
If you try to scale up your architecture consider using ocee cluster to connect several opencms instances. The database could use ocee 
replication or mysql cluster.

kind regards,

Achim

shency wrote:
> Hi All,
> 
> We have an OpenCms 6 application.
> 
> Currently there exist multiple installations (using sites/default) for
> different brands, connecting to separate db schema. Now we are thinking of
> using single db schema by using separate sites for each brand (i.e.,
> sites/brandA, sites/brandB etc.)
> 
> I can see two options to do this
> 
> 1) Have a single installation connecting to common db schema and keep the
> content under separate sites (i.e., sites/brandA, sites/brandB etc.) for
> each brands. As per the opencms documentation, this is supported.
> 
> 2) Here is my Qn, Is it possible to keep multiple installation of openCms,
> each using its on separate sites for content (i.e., sites/brandA,
> sites/brandB etc.) and connect to the same underlying opencms db schema? If
> yes, does the openCms admin console behave consistently across the
> installations to support concurrent content customisation of each site (off
> course with controlled user privileges)
> 
> Please let me know If my description is confusing, so that I will try to be
> more clear
> Thanks in advance for help in this regard,
> Shency