[opencms-dev] Any experience with huge sites?

[Roman Uhlig Maxity.de]

Hi Christian,

we are running several OpenCms servers on MySQL 5.0.x as well as on PostgreSQL 8.4.x. So far we didn't notice any noteworthy differences regarding performance. In terms of large amounts of (binary) resources I'd tend to recommend PostgreSQL >= 8.4. Compare the features regarding this field of use and I guess you'll come to the same conclusion. ;)

Beside the DBMS you should have in mind is that the OpenCms database is growing very fast when heavily working with many resources. Also the tools and features for handling large amounts of resources are limited. Of course you can write your own scripts using the really great OpenCms API, but out of the box you won't have much fun when reaching 2000+ resources per folder. On the other hand we never had serious performance issues in serving these resources to the end user. OpenCms has several features to aid you in this (cached image scaling, Lucene indexing of PDF and other non-XML resources etc.). You can also configure individual behaviour for every resource type regarding caching, export and the like.

If you don't fear getting into the OpenCms API and writing quite some scripts and stuff to help you handling large amounts of resources, you should be fine. Else you might want to have a look at more integrated solutions like Liferay.

The choice is yours ;)

Roman

-----Ursprüngliche Nachricht-----
Von: opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org] Im Auftrag von Christian.Weber at Bertelsmann.de
Gesendet: Freitag, 6. November 2009 11:18
An: opencms-dev at opencms.org
Betreff: [opencms-dev] Any experience with huge sites?

Hi

I wonder how OpenCms and MySql scale with huge sites having more than 500.000 pages, many large binaries (images, mp3 and pdf) and database size > 10 GB. 

Are there any known limitations or issues with the vfs regarding performance and stability? 

Has someone experience with alternative databases like Oracle or Postgres which might scale better for such large sites?

Thank you for any hint.

Regards
Christian



> -----Ursprüngliche Nachricht-----
> Von: opencms-dev-bounces at opencms.org 
> [mailto:opencms-dev-bounces at opencms.org] Im Auftrag von Carol Manchó
> Gesendet: Freitag, 6. November 2009 08:07
> An: The OpenCms mailing list
> Betreff: Re: [opencms-dev] Multisite: Editor transforms the links
> 
> Hi,
> 
> Are users with Workplace manager role who create the links 
> with the FCKeditor and this happens with all links, any idea?
> 
> Thanks!
> 
> Carol
> 
> En/na Christoph P. Kukulies ha escrit:
> > On Thu, Nov 05, 2009 at 01:44:26PM +0100, Carol Manch? wrote:
> >   
> >> Hi all,
> >> We use OpenCms 7.0.5 to handle multiple sites. In 
> opencms-system.xml 
> >> we have defined sites as follows:
> >>
> >> <sites>
> >>     <workplace-server>http://www.siteA.com</workplace-server>
> >>     <default-uri>/sites/siteA/</default-uri>
> >>     <site server="http://www.siteA.com" uri="/sites/siteA/"/>
> >>     <site server="http://www.siteB.com" uri="/sites/siteB/"/> 
> >> </sites>
> >>
> >> Our problem appears when we include a link from a page of 
> the siteB 
> >> to a page of the siteA. We add a link like this <a 
> >> href="http://www.siteA.com/page1.html"> and the editor transforms 
> >> this
> >>     
> >
> >
> > Have you tried to enclose the URL by <cms:link> tags?
> >
> >  
> >   
> >> link to <a href="/page1.html"> after saving the page.
> >> We need to link siteB with siteA but this is not possible with our 
> >> configuration, any idea what could be the problem?
> >>
> >>
> >> Thanks
> >>
> >>     
> > --
> > Chris Christoph P. U. Kukulies kukulies (at) rwth-aachen.de
> >
> > _______________________________________________
> > 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
> 

_______________________________________________
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