Database Management

[johnbt29]

Hello friends,

I would like to know the technique of preforming database redundancy of my system.

I have seven fieldpoint devices cFP-2100 at different stations performing different control actions for the process. I have a HP server and 3 workstations for dataloggin and monitoring the treatment plant variables. It was designed that the server will log all the fieldpoint datas. One of the 3 workstations acts like a redundant system for the server. It means if the server fails or shutdown, one of the three workstation will take over the job of server to log the data. 

for this purpose, i have configured shared variables in server and redundant workstation to log the data continuously. so even if one machine fails, the other machine will have the data. So the other two workstations(Operator Interface system) will not log the data.

The thing which iam not clear is that, say server failed and the redundant workstation will continue to log the data. when the server is restarted or the fault is rectified, it has to synchronize database with the redudant workstation. The synchronization of database has to happen between the server and the redundant workstation.

I don't know how it has to be done.

Is there any already programmed modules available to do this operation?

Please Help me to crack this problem

Regards

John

[Justin_P]

Hi John,

When you say database are you talking about something like mySQL?  Or are you just refering to the files that you are saving the data in?  If you are talking about a database (like mySQL, Access, Oracle etc.) there are many companies that have already programmed modules that will perform this operation.  And a quick google search of the specific database you are using should turn up a couple results.

But, a far a LabVIEW is concerned, I could not find any example code posted by anyone showing what you were needing.  If you do end up writing something like this, please post it here.

[johnbt29]

Hi Justin,

Thanks for the reply...I am not using any other database...iam using the citadel database in LabVIEW. Iam shocked to know that there is no method or examples available for this redundancy. How to do the redundancy? is there any other method to do so..?

Regards

John 

[Justin_P]

Hi John,

I have created a product suggestion, asking that we create an example that shows how to synchronize databases.  You can do the same here.  All product suggestions are evaluated by our R&D team, and this is a major part of how we decide what we need to add to our products.

If you do not have the time to invest in figuring out how to program this functionality into your code, I would suggest using one of the 3rd party tools.