topic Alfresco 3.2 Community Clustering Issues in Alfresco Archive

Alfresco 3.2 Community Clustering Issues

hailpam — Sat, 20 Mar 2010 15:28:09 GMT

Hi all,I'm trying to deploy in a production environment the Alfresco Cluster Configuration.My ideas is the following:1. the use of two CentOs linux servers, named A and B;2. the use of NFS export to share SAN storage mount point (no replicated content store);3. the use of MySql Cluster;4. the use of

Re: Alfresco 3.2 Community Clustering Issues

derek — Mon, 22 Mar 2010 11:49:13 GMT

Hi,
http://wiki.alfresco.com/wiki/Cluster_Configuration_V2.1.3_and_Later#High_availability_components

NB: As of V3.1, the cluster components will only initialize if the following property is defined:

alfresco.cluster.name=<CLUSTERNAME>

Re: Alfresco 3.2 Community Clustering Issues

hailpam — Mon, 22 Mar 2010 13:34:57 GMT

Hi,
http://wiki.alfresco.com/wiki/Cluster_Configuration_V2.1.3_and_Later#High_availability_components
NB: As of V3.1, the cluster components will only initialize if the following property is defined:

alfresco.cluster.name=<CLUSTERNAME>

Hi derek,

thanks a lot for your reply: by the first tests I can observe that my problem has been resolved using your tip!

Best Regards,

- Paolo

P.S.: I'll deploy the cluster in the production environment after a set of test; I'll keep you informed!

Re: Alfresco 3.2 Community Clustering Issues

liferay01 — Fri, 02 Apr 2010 15:55:50 GMT

Hi all,

I'm trying to deploy in a production environment the Alfresco Cluster Configuration.

My ideas is the following:
1. the use of two CentOs linux servers, named A and B;
2. the use of NFS export to share SAN storage mount point (no replicated content store);
3. the use of MySql Cluster;
4. the use of a sticky load balancer in front of the two servers A and B;
in ordert to deploy an High Availability solution.
- Paolo

Hi derek,

thanks a lot for your reply: by the first tests I can observe that my problem has been resolved using your tip!

Best Regards,

- Paolo

P.S.: I'll deploy the cluster in the production environment after a set of test; I'll keep you informed!

Hi Paolo,

We are on a similar situation. We are trying to buid a high availability solution based on :

We are facing some problems with the MySQL Cluster. What we are doing is

Unfortunately, this leads to the following errors :
ERROR 1005 (HY000) at line 1126: Can't create table 'alfresco.alf_access_control_entry' (errno: 906)
by the way, "ERRNO 906" is "DMEC SE Unsupported attribute type in index"

Reading your post, It looks like you succeded using the MySQL Cluster with Alfresco. Is that rigth ?
If so, how did you manage to put the alfresco database schema in the MySQL Cluster without errors ?

Regards

Re: Alfresco 3.2 Community Clustering Issues

hailpam — Fri, 30 Jul 2010 14:54:04 GMT

Hi liferay01,

sorry for a such delayed reply to your question.

I encountered your same problem with MySql cluster DB engine (NDBcluster), but I've not been able to solve it following the solution you have proposed.
There is a persistence control at Alfresco's ORM layer that is blocking for DB schema deploy that is different from InnoDB. The error errno:906 concerning the index creation, and can be caused by the above mentioned blocking control: "Can't create table… ", Alfresco tries to create InnoDB tables that are serialized on local datafile regardless the already existing NDBcluster tables that instead are 'in-memory entities'.

Regars,

- Paolo