topic Re: Extend Node Service in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/extend-node-service/m-p/305658#M258788 <HTML><HEAD></HEAD><BODY><SPAN>I'd strongly advise you to reconsider and explore your requirements more.&nbsp;&nbsp;&nbsp; Possibly have one normal database and then ETL the subset of the node data?</SPAN><BR /><BR /><SPAN>You are going to have to use distributed transactions for your multiple databases.&nbsp;&nbsp;&nbsp; It can be done, but its not a casual decision.&nbsp;&nbsp; </SPAN><BR /><BR /><SPAN>And nodes are not defined in isolation,&nbsp; they won't move neatly move from one database to another.&nbsp;&nbsp; There are things like associations which obviously can't link to nodes on different databases.&nbsp;&nbsp;&nbsp; You will probably need a "placeholder" node in the master database.</SPAN><BR /><BR /></BODY></HTML> Thu, 27 Feb 2014 12:04:00 GMT mrogers 2014-02-27T12:04:00Z Extend Node Service https://connect.hyland.com/t5/alfresco-archive/extend-node-service/m-p/305657#M258787 I have a requirement, that stands that I need to store node information in different MySQL DBs. Lets say I have nodes of type A, B and C. so A nodes have to be stores in A's MySQL, and so on finally other kind of nodes that are not A, B or C have to be stored in default alfresco's MySQL.I have a cou Wed, 26 Feb 2014 16:33:03 GMT https://connect.hyland.com/t5/alfresco-archive/extend-node-service/m-p/305657#M258787 llicon 2014-02-26T16:33:03Z Re: Extend Node Service https://connect.hyland.com/t5/alfresco-archive/extend-node-service/m-p/305658#M258788 <HTML><HEAD></HEAD><BODY><SPAN>I'd strongly advise you to reconsider and explore your requirements more.&nbsp;&nbsp;&nbsp; Possibly have one normal database and then ETL the subset of the node data?</SPAN><BR /><BR /><SPAN>You are going to have to use distributed transactions for your multiple databases.&nbsp;&nbsp;&nbsp; It can be done, but its not a casual decision.&nbsp;&nbsp; </SPAN><BR /><BR /><SPAN>And nodes are not defined in isolation,&nbsp; they won't move neatly move from one database to another.&nbsp;&nbsp; There are things like associations which obviously can't link to nodes on different databases.&nbsp;&nbsp;&nbsp; You will probably need a "placeholder" node in the master database.</SPAN><BR /><BR /></BODY></HTML> Thu, 27 Feb 2014 12:04:00 GMT https://connect.hyland.com/t5/alfresco-archive/extend-node-service/m-p/305658#M258788 mrogers 2014-02-27T12:04:00Z