[opencms-dev] 3xOpenCMS sharing one Database, yes or no ?

HERNAN - TFSLA info at tfsla.com
Wed Sep 11 14:28:20 CEST 2013 

Hi Jose,

I assuming you already go trough Flexcache fine tuning, so, I think the
answer you are looking is IT DEPENDS. If you have a static site with very
low publication frequency (a couple a day) static option is certainly the
best option. Complement that with Varnish or Nginx and you will never see a
performance issue again.

If you have a very dynamic site (comments, login, counters, personalization,
etc) OR a high publication frequency the Flexcache will not be enough and
you will be needing OCEE Accelerator or some sort of cache. 

That said, we typically used both, parts of the site are static and part
dynamic. We generate some of the HTML blocks calling the jsp from a cron on
the RFS and the consume it using Ajax. 

Another couple of things. We experimented with the scenario you described.
We got much better results using 1 APACHE /JBOSS per box and not a 3 to 1
combination. That said, we also got MUCH MUCH better results with Tomcat7
than Jboss.

I hope that helps.



jiyarza wrote:
> 
> Excuse me for the triple post, but I wanted to link another recent post
> with
> good info, in the same thread from Stephan Hartmann:
> 
>  
> 
> http://permalink.gmane.org/gmane.comp.cms.opencms.devel/38170
> 
>  
> 
> If all this does relate with the setup at hand, and none has anything to
> add, I’d take it as official for me: Either OCEE or static export.
> 
>  
> 
> Thanks.
> 
>  
> 
> De: opencms-dev-bounces at opencms.org
> [mailto:opencms-dev-bounces at opencms.org]
> En nombre de Jose Ignacio Yarza
> Enviado el: miércoles, 11 de septiembre de 2013 11:22
> Para: 'The OpenCms mailing list'
> Asunto: Re: [opencms-dev] 3xOpenCMS sharing one Database, yes or no ?
> 
>  
> 
> Excerpt from here:
> 
>  
> 
> http://comments.gmane.org/gmane.comp.cms.opencms.devel/38158
> 
>  
> 
> Achim Westermann wrote this a month ago:
> 
>  
> 
> “(…)My current company spent again
> 
> and again and again and again and again efforts to circumvent buying
> 
> ocee. We set up cronjobs to delete static export files on slave servers
> 
> (which costs additional performance), I - as a former OpenCms developer
> 
> with some insight on the internals - coded a jsp to flush the caches on
> 
> the slave instances. And on a weekly turn someone passes by to let me
> 
> request that special jsp to have the cache flushed. And then they tried
> 
> to deactivate the OpenCms cache and ran into performance issues. Putting
> 
> an external cache in front of a clustered OpenCms will even get you
> 
> deeper into the mud.
> 
> And then some editor did forget or not know (as they were new to our
> 
> company) that an OpenCms cluster slave will not know about changes
> 
> witout ocee. Did not contact me and had troubles because changes were
> 
> not propagated. And again and again and again and again and again and
> 
> again I keep on manually flushing the cache on the slave cluster servers
> 
> if some editor knew that we had this "cluster - issue".
> 
> Sum up: Those 3500 bucks spent on ocee cluster... we already lost a lot
> 
> more of money to circumvent buying that. And we will never achieve a
> 
> better solution because Alkacon did work on that for many years and
> 
> constantly is fixing bugs concerning ocee cluster. This is not a fanboi
> 
> advertisement. It's just my opinion: You will never save money by trying
> 
> to implement your own OpenCms cluster. The only thing you will achieve
> 
> is to increase your level of maintenance and time to web.
> 
> In case you don't know what problems will arise when running OpenCms in
> 
> a cluster without ocee feel free to answer.
> 
> “
> 
>  
> 
> What Achim says, which I can completely identify with, would be aligned
> with
> the official word?
> 
>  
> 
> Thanks
> 
>  
> 
>  
> 
> De: opencms-dev-bounces at opencms.org
> [mailto:opencms-dev-bounces at opencms.org]
> En nombre de Jose Ignacio Yarza
> Enviado el: miércoles, 11 de septiembre de 2013 11:13
> Para: 'The OpenCms mailing list'
> Asunto: [opencms-dev] 3xOpenCMS sharing one Database, yes or no ?
> 
>  
> 
> Hi List,
> 
>  
> 
>  
> 
> This is an important issue that I would like to share with and if possible
> get from you some valuable and informed feedback.
> 
>  
> 
> We have setup in a production environment three opencms (8.5) instances
> over
> three independent JBoss (not clustered), sharing one same Oracle (11g)
> database. There is an Apache web server balancig between the three JBoss
> instances. This environment is read-only, there is not content management
> concurrency, only dynamic page generation for a website.
> 
>  
> 
> The issue is that there is a performance degradation that does not happen
> in
> our other single-instance environments, which are setup in the standard
> way
> (named development and test).
> 
>  
> 
> I know about the potential problems with the data access parts managed
> inside the three JBoss instances, where we'd find three different
> connection
> pools, Solr indexes not in sync, flex cache,...
> 
>  
> 
> Question: So, Is it an affordable task to tune up this setup and make it
> work fine? Do we need OCEE? Is the pain worth it being a read only
> environment? Wouldn't be a much better solution, in this read-only
> scenario,
> using static export altogether? 
> 
>  
> 
> I know this is a recurrent matter,  and have read good information but
> also
> some divagation about it. I have my own opinion (go static), but it seems
> not enough for politicians, that’s why I am asking here. Any official
> advice
> on the overall idea is also very welcome. Thank you for your suggestions.
> 
>  
> 
>  
> 
>  
> 
> Jose Ignacio Yarza
> 
> Open Sistemas
> 
> Tel: 649 157 537
> 
>  
> 
> logo_open
> 
>  
> 
> 
>  
> _______________________________________________
> 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/cgi-bin/mailman/listinfo/opencms-dev
> 
> 
> 
> 
> 
-- 
View this message in context: http://old.nabble.com/3xOpenCMS-sharing-one-Database%2C-yes-or-no---tp35930968p35931584.html
Sent from the OpenCMS mailing list archive at Nabble.com.

More information about the opencms-dev mailing list