[gold-users] Same gold database and Multiple Server

[Dheeraj Kv]

Hi


        Thanks for your valuable information. I have one more query regarding the same.
Currently the setup is a production one without Innodb, so when i enable Innodb in my.cnf, should I again recreate gold database or will it run with the currently running database itself.


Dheeraj KV




-----Original Message-----
From: Scott Jackson <scottmo at adaptivecomputing.com>
To: Gold Users Mailing List <gold-users at supercluster.org>
Sent: Mon, Dec 19, 2011 4:52 pm
Subject: Re: [gold-users] Same gold database and Multiple Server


Yes, you can do that. This is according to design. There should not be any inconsistency since Gold uses transactions. Make sure if you are running mysql that it is using a Transaction-enabled engine such as InnoDB. Postgres enables transactions by default. There should be no problem with the transaction id for the same reason.

Scott




From: "Dheeraj Kv" <dheerajkv at aol.com>
To: gold-users at supercluster.org
Sent: Monday, December 19, 2011 1:02:43 AM
Subject: [gold-users] Same gold database and Multiple Server

Hi


            I have two different clusters. Both is running gold as accounting software with two different gold database and gold server.
Now I want a centralized database  for Gold. Is it possible for me to shift database  to a central server and have two gold servers (goldd)  updating the same database. I need to know whether will there be any  inconsistency in the data uploaded by different servers on the same database.
I could find out a g_transaction_id in the database, which increments on each update. Will this id get  mismatch  or duplicated if two gold servers update on the same database. Any help is much appreciated. 


Regards

Dheeraj KV


_______________________________________________
gold-users mailing list
gold-users at supercluster.org
http://www.supercluster.org/mailman/listinfo/gold-users



 
_______________________________________________
gold-users mailing list
gold-users at supercluster.org
http://www.supercluster.org/mailman/listinfo/gold-users

 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.supercluster.org/pipermail/gold-users/attachments/20111221/c1177fa9/attachment.html