topic Re: Application and DB in different Servers in Alfresco Archive

Application and DB in different Servers

jlabuelo — Thu, 24 Jun 2010 08:16:54 GMT

Good MorningWe are tryting to set up an Alfresco V3.2 application following this architecture MySQL DB will be in server A, and the Alfresco application will run in a different server B. Installing it and launching it works 100% fine, however the performance of this archicture it is very slow (well

Re: Application and DB in different Servers

mrogers — Thu, 24 Jun 2010 08:44:29 GMT

I suspect you have a networking issue here. Are your servers connected together with a good fast network?

Re: Application and DB in different Servers

jlabuelo — Thu, 24 Jun 2010 08:56:16 GMT

Hi, thanks for the quick answer.

Yes they are, they are even in the same rack both servers, hub and router. Do you think the architechture is ok or to get this to work we should apply any specific configuration ?. To install it we just followed the normal steps of the installation wizard.

I have found another post

http://forums.alfresco.com/en/viewtopic.php?f=9&t=26791&p=90140&hilit=remote+db#p90140
where problem seems to be similar

Thanks again

Re: Application and DB in different Servers

jlabuelo — Tue, 29 Jun 2010 07:50:10 GMT

Hi Rogers

Could you please share with us your thoughts about this issue? We have found in other posts that when people runs an installation of Alfresco having the application in one server and the MySQL DB instance in another one, performance gets slowed down too much making it useless like we are having.

Is Alfresco available to work this way for just a simple non clustered configuration (and if so what do you think we could be doing wrong), or if we do not want to get a cluster configuration we should have both DB and Application instances in the same physical machine?

Your thoughts will be very appreciated.

Regards

Re: Application and DB in different Servers

mrogers — Tue, 29 Jun 2010 09:42:09 GMT

I think we need some help from a mysql administrator here.

And what OS are you running mysql on since that may also have an effect?

I'd anticipate that most of the bigger instances of alfresco will have a separate db server so someone out there must be able to get it to work.

Re: Application and DB in different Servers

jlabuelo — Tue, 29 Jun 2010 10:07:45 GMT

Hi Rogers

Both machines are running over the linux distribution Suse 10.

Hope someone got it to work or can let us know if this is possible or not 🙂

Thanks once more