<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Texto sin formato Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.5pt;
font-family:Consolas;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Texto de globo Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EstiloCorreo17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.TextodegloboCar
{mso-style-name:"Texto de globo Car";
mso-style-priority:99;
mso-style-link:"Texto de globo";
font-family:"Tahoma","sans-serif";}
span.TextosinformatoCar
{mso-style-name:"Texto sin formato Car";
mso-style-priority:99;
mso-style-link:"Texto sin formato";
font-family:Consolas;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=ES link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Thanks for the comments,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US>@Hernan, the current setup is 1 Apache acting as load balancer on top of 3 Jboss, who share a same database instance. In this setup the Apache server does not handle any static content, everything is served by the JBoss instances.<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US>So changing the role of the Apache server, from balancer to web server, and using one together with each JBoss to serve the exported content sounds good. We will have to decide what to export to begin with.<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US>@Arash, thanks for suggesting a HAProxy as balancer instead of Apache. That rounds the setup. So, it could be something like:<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US>1xVarnish (optional) <- 1xHAProxy <- 3x(Apache<-JBoss)(Tomcat recommended) <- 1xDatabase<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US>How about the <b>shared database</b> instance? Is it safe to use it without OCEE for a site that generates every single page dynamically (at the moment, because it clearly is unnecessary to regenerate every page everytime, since they are constant, though this would be also solved by the varnish cache)? The performance hit could be related to be using specifically Oracle combined with the fact that 3 jboss are accessing the same instance?<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US>@Marc, Hi. In other projects we have used extensively the static export feature in the way you describe. In my experience the weight of each rsync operation depends on the OpenCMS version too (of course, the volume and frequency of publishing matters most, and it seems that case is a big one). But earlier versions used to export everything every time, thus causing that rsync synced all the export folder every time. From version 7.5 and above (that I know) it has given to me good results, being an incremental relatively weightless syncing. I think this would be optimal in any case in which there is only dynamic page generation through templates (exportable), not based on user input or other “runtime” variables, or also using a cache like varnish, as mentioned above.<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Thanks,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Jose<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>De:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> opencms-dev-bounces@opencms.org [mailto:opencms-dev-bounces@opencms.org] <b>En nombre de </b>Marc Johnson<br><b>Enviado el:</b> jueves, 1</span><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>2 de septiembre de 2013 3:29<br><b>Para:</b> The OpenCms mailing list<br><b>Asunto:</b> Re: [opencms-dev] 3xOpenCMS sharing one Database, yes or no ?<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal style='margin-bottom:12.0pt;background:white'><span style='color:black'>Used to work in a place where opencms was the content mgmt running a site with many hundreds of pages. It was heavily customized and integrated with a lot of other technology, but we had apache on machines in datacenters in both the east and west coast and a we did a publish to a server here in the midwest and synced the content out to the servers every ten minutes or something in cron with rsync.<br><br>the caveat is that our heavy customization meant that all the dynamic content was built out statically to the server in the midwest when we published and that's what got synced out to the apache servers. So tomcat was for the workplace users to make content changes and to view what they'd look like internally but when published it all became static content and our dynamicness was all ajax including a lot of xslt not backend technology. <br><br>One problem we had is that we ran the rsync in cron (every 5 or 10 minutes and the whole directory was taking right up to the end to get through meaning that the rsync was running perpetually and would sometimes overlap which wasn't acceptable), <br><br>we made those rsync scripts cover smaller and smaller portions of the doc root so they'd consistently get done in the time limit but it got to be a bit of headache if you multiply setting up 6 servers per coast times x scripts per server in cron.<br><br>At some point after I left they may've gotten that going on demand versus in cron and they were also working on getting an addition to the db to track and run through anything that'd change in the publishing queue.<o:p></o:p></span></p><div><p class=MsoNormal style='background:white'><span style='color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='color:black'><o:p> </o:p></span></p></div><div><div><div><div class=MsoNormal align=center style='text-align:center;background:white'><span style='color:black'><hr size=1 width="100%" align=center></span></div><p class=MsoNormal style='background:white'><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>From:</span></b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'> Arash Kaffamanesh <<a href="mailto:ak@cloudssky.com">ak@cloudssky.com</a>><br><b>To:</b> The OpenCms mailing list <<a href="mailto:opencms-dev@opencms.org">opencms-dev@opencms.org</a>> <br><b>Sent:</b> Wednesday, September 11, 2013 1:38 PM<br><b>Subject:</b> Re: [opencms-dev] 3xOpenCMS sharing one Database, yes or no ?</span><span style='color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='color:black'><o:p> </o:p></span></p><div id=yiv2727321463><div><div><div><p class=MsoNormal style='background:white'><span style='color:black'>Hi Jose,<br><br>1 Apache + 1 JBoss or Tomcat per node and HAProxy in front might be the right solution.<br><br>In genral static export could be a good solution if you don't have any dynamic content elements / apps and server your content statically.<br>If you would need only static content , you can have only one workplace and sync your static content to your multiple JBoss Portal nodes and use any loadbalancing technics such as HAProxy. If you don't need JBoss Portal, then use Tomcat.<br><br>But if you have any dynamic content / apps, then you have to use OCEE or some other cluster ready technologies such as OCCX (Metamesh's OpenCms Cloud eXtensions), which we are going to present on OpenCms Days in 3 weeks.<o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='color:black'><o:p> </o:p></span></p></div><p class=MsoNormal style='background:white'><span style='color:black'>Kind Regards,<o:p></o:p></span></p></div><p class=MsoNormal style='background:white'><span style='color:black'>Arash<o:p></o:p></span></p><div><div><div><div><p class=MsoNormal style='background:white'><span style='color:black'><br></span><span style='color:blue'><a href="http://www.cloudssky.com/en/events/opencms-days-2013.html" target="_blank">Visit us at OpenCms Days Conference (free tickes available)</a><br><a href="http://cloudssky.com/en/cloud_products/cloudsites.html" target="_blank">CloudSites empowered by Metamesh's OpenCms Cloud eXtensions (OCCX</a></span><span style='color:black'>)<o:p></o:p></span></p></div></div><div><p class=MsoNormal style='background:white'><b><span style='color:black;background:white'>____________________________ </span></b><span style='color:#222222'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><b><span style='color:black;background:white'>Arash Kaffamanesh</span></b><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black;background:white'><br>Clouds Sky GmbH</span></b><span style='color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black;background:white'>Im Mediapark 4C</span></b><span style='color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black;background:white'>50760 Köln</span></b><span style='color:black'><o:p></o:p></span></p></div><p class=MsoNormal style='background:white'><span style='font-family:"Arial","sans-serif";color:black;background:white'><span class=MsoHyperlink>+49 221 379 90 680</span></span><span style='color:black;background:white'><br><a href="http://www.cloudssky.com/" target="_blank">www.cloudssky.com</a><b><br>____________________________</b></span><span style='color:black'><o:p></o:p></span></p><div><p class=MsoNormal style='margin-bottom:12.0pt;background:white'><span style='color:black'><o:p> </o:p></span></p><div><p class=MsoNormal style='background:white'><span style='color:black'>On Wed, Sep 11, 2013 at 5:43 PM, Jose Ignacio Yarza <<a href="mailto:jiyarza@opensistemas.com" target="_blank">jiyarza@opensistemas.com</a>> wrote:<o:p></o:p></span></p><p class=MsoNormal style='background:white'><span style='color:black'>Thank you for your comments Hernan.<br><br>I agree with using Varnish or Nginx, that is a first aid that will improve things a bit.<br><br>When you say:<o:p></o:p></span></p><div><p class=MsoNormal style='background:white'><span style='color:black'><br>"We got much better results using 1 APACHE /JBOSS per box and not a 3 to 1<o:p></o:p></span></p></div><p class=MsoNormal style='background:white'><span style='color:black'>combination."...<br><br>You mean you got better results with a standard setup (1 Apache + 1 JBoss/Opencms + 1 database) than with @subject, or anything else?<br><br><br>Regards,<br>Jose<br><br>-----Mensaje original-----<br>De: <a href="mailto:opencms-dev-bounces@opencms.org" target="_blank">opencms-dev-bounces@opencms.org</a> [mailto:<a href="mailto:opencms-dev-bounces@opencms.org" target="_blank">opencms-dev-bounces@opencms.org</a>] En nombre de HERNAN - TFSLA<br>Enviado el: miércoles, 11 de septiembre de 2013 14:28<br>Para: <a href="mailto:opencms-dev@opencms.org" target="_blank">opencms-dev@opencms.org</a><o:p></o:p></span></p><div><div><p class=MsoNormal style='margin-bottom:12.0pt;background:white'><span style='color:black'>Asunto: Re: [opencms-dev] 3xOpenCMS sharing one Database, yes or no ?<br><br><br>Hi Jose,<br><br>I assuming you already go trough Flexcache fine tuning, so, I think the<br>answer you are looking is IT DEPENDS. If you have a static site with very<br>low publication frequency (a couple a day) static option is certainly the<br>best option. Complement that with Varnish or Nginx and you will never see a<br>performance issue again.<br><br>If you have a very dynamic site (comments, login, counters, personalization,<br>etc) OR a high publication frequency the Flexcache will not be enough and<br>you will be needing OCEE Accelerator or some sort of cache.<br><br>That said, we typically used both, parts of the site are static and part<br>dynamic. We generate some of the HTML blocks calling the jsp from a cron on<br>the RFS and the consume it using Ajax.<br><br>Another couple of things. We experimented with the scenario you described.<br>We got much better results using 1 APACHE /JBOSS per box and not a 3 to 1<br>combination. That said, we also got MUCH MUCH better results with Tomcat7<br>than Jboss.<br><br>I hope that helps.<br><br><br><br>jiyarza wrote:<br>><br>> Excuse me for the triple post, but I wanted to link another recent post<br>> with<br>> good info, in the same thread from Stephan Hartmann:<br>><br>><br>><br>> <a href="http://permalink.gmane.org/gmane.comp.cms.opencms.devel/38170" target="_blank">http://permalink.gmane.org/gmane.comp.cms.opencms.devel/38170</a><br>><br>><br>><br>> If all this does relate with the setup at hand, and none has anything to<br>> add, I’d take it as official for me: Either OCEE or static export.<br>><br>><br>><br>> Thanks.<br>><br>><br>><br>> De: <a href="mailto:opencms-dev-bounces@opencms.org" target="_blank">opencms-dev-bounces@opencms.org</a><br>> [mailto:<a href="mailto:opencms-dev-bounces@opencms.org" target="_blank">opencms-dev-bounces@opencms.org</a>]<br>> En nombre de Jose Ignacio Yarza<br>> Enviado el: miércoles, 11 de septiembre de 2013 11:22<br>> Para: 'The OpenCms mailing list'<br>> Asunto: Re: [opencms-dev] 3xOpenCMS sharing one Database, yes or no ?<br>><br>><br>><br>> Excerpt from here:<br>><br>><br>><br>> <a href="http://comments.gmane.org/gmane.comp.cms.opencms.devel/38158" target="_blank">http://comments.gmane.org/gmane.comp.cms.opencms.devel/38158</a><br>><br>><br>><br>> Achim Westermann wrote this a month ago:<br>><br>><br>><br>> “(…)My current company spent again<br>><br>> and again and again and again and again efforts to circumvent buying<br>><br>> ocee. We set up cronjobs to delete static export files on slave servers<br>><br>> (which costs additional performance), I - as a former OpenCms developer<br>><br>> with some insight on the internals - coded a jsp to flush the caches on<br>><br>> the slave instances. And on a weekly turn someone passes by to let me<br>><br>> request that special jsp to have the cache flushed. And then they tried<br>><br>> to deactivate the OpenCms cache and ran into performance issues. Putting<br>><br>> an external cache in front of a clustered OpenCms will even get you<br>><br>> deeper into the mud.<br>><br>> And then some editor did forget or not know (as they were new to our<br>><br>> company) that an OpenCms cluster slave will not know about changes<br>><br>> witout ocee. Did not contact me and had troubles because changes were<br>><br>> not propagated. And again and again and again and again and again and<br>><br>> again I keep on manually flushing the cache on the slave cluster servers<br>><br>> if some editor knew that we had this "cluster - issue".<br>><br>> Sum up: Those 3500 bucks spent on ocee cluster... we already lost a lot<br>><br>> more of money to circumvent buying that. And we will never achieve a<br>><br>> better solution because Alkacon did work on that for many years and<br>><br>> constantly is fixing bugs concerning ocee cluster. This is not a fanboi<br>><br>> advertisement. It's just my opinion: You will never save money by trying<br>><br>> to implement your own OpenCms cluster. The only thing you will achieve<br>><br>> is to increase your level of maintenance and time to web.<br>><br>> In case you don't know what problems will arise when running OpenCms in<br>><br>> a cluster without ocee feel free to answer.<br>><br>> “<br>><br>><br>><br>> What Achim says, which I can completely identify with, would be aligned<br>> with<br>> the official word?<br>><br>><br>><br>> Thanks<br>><br>><br>><br>><br>><br>> De: <a href="mailto:opencms-dev-bounces@opencms.org" target="_blank">opencms-dev-bounces@opencms.org</a><br>> [mailto:<a href="mailto:opencms-dev-bounces@opencms.org" target="_blank">opencms-dev-bounces@opencms.org</a>]<br>> En nombre de Jose Ignacio Yarza<br>> Enviado el: miércoles, 11 de septiembre de 2013 11:13<br>> Para: 'The OpenCms mailing list'<br>> Asunto: [opencms-dev] 3xOpenCMS sharing one Database, yes or no ?<br>><br>><br>><br>> Hi List,<br>><br>><br>><br>><br>><br>> This is an important issue that I would like to share with and if possible<br>> get from you some valuable and informed feedback.<br>><br>><br>><br>> We have setup in a production environment three opencms (8.5) instances<br>> over<br>> three independent JBoss (not clustered), sharing one same Oracle (11g)<br>> database. There is an Apache web server balancig between the three JBoss<br>> instances. This environment is read-only, there is not content management<br>> concurrency, only dynamic page generation for a website.<br>><br>><br>><br>> The issue is that there is a performance degradation that does not happen<br>> in<br>> our other single-instance environments, which are setup in the standard<br>> way<br>> (named development and test).<br>><br>><br>><br>> I know about the potential problems with the data access parts managed<br>> inside the three JBoss instances, where we'd find three different<br>> connection<br>> pools, Solr indexes not in sync, flex cache,...<br>><br>><br>><br>> Question: So, Is it an affordable task to tune up this setup and make it<br>> work fine? Do we need OCEE? Is the pain worth it being a read only<br>> environment? Wouldn't be a much better solution, in this read-only<br>> scenario,<br>> using static export altogether?<br>><br>><br>><br>> I know this is a recurrent matter, and have read good information but<br>> also<br>> some divagation about it. I have my own opinion (go static), but it seems<br>> not enough for politicians, that’s why I am asking here. Any official<br>> advice<br>> on the overall idea is also very welcome. Thank you for your suggestions.<br>><br>><br>><br>><br>><br>><br>><br>> Jose Ignacio Yarza<br>><br>> Open Sistemas<br>><br>> Tel: 649 157 537<br>><br>><br>><br>> logo_open<br>><br>><br>><br>><br>><br>> _______________________________________________<br>> This mail is sent to you from the opencms-dev mailing list<br>> To change your list options, or to unsubscribe from the list, please visit<br>> <a href="http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev" target="_blank">http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev</a><br>><br>><br>><br>><br>><br>--<br>View this message in context: <a href="http://old.nabble.com/3xOpenCMS-sharing-one-Database%2C-yes-or-no---tp35930968p35931584.html" target="_blank">http://old.nabble.com/3xOpenCMS-sharing-one-Database%2C-yes-or-no---tp35930968p35931584.html</a><br>Sent from the OpenCMS mailing list archive at Nabble.com.<br><br>_______________________________________________<br>This mail is sent to you from the opencms-dev mailing list<br>To change your list options, or to unsubscribe from the list, please visit<br><a href="http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev" target="_blank">http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev</a><br><br><br><br><br>_______________________________________________<br>This mail is sent to you from the opencms-dev mailing list<br>To change your list options, or to unsubscribe from the list, please visit<br><a href="http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev" target="_blank">http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev</a><br><br><br><o:p></o:p></span></p></div></div></div><p class=MsoNormal style='background:white'><span style='color:black'><o:p> </o:p></span></p></div></div></div></div></div><p class=MsoNormal style='margin-bottom:12.0pt;background:white'><span style='color:black'><br>_______________________________________________<br>This mail is sent to you from the opencms-dev mailing list<br>To change your list options, or to unsubscribe from the list, please visit<br><a href="http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev" target="_blank">http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev</a><br><br><br><br><br><o:p></o:p></span></p></div></div></div></div></div></body></html>