It is currently Tue Jul 29, 2014 2:55 pm




Post new topic Reply to topic  [ 2 posts ] 
 FactorySQL Redundancy - Setup 
Author Message
Cadet
Cadet

Joined: Mon Jan 18, 2010 10:49 am
Posts: 2
Post FactorySQL Redundancy - Setup
I just enabled redundancy on FactorySQL. It seems to be working but I’m not sure if I setup this right. I have two physical servers (A and B) running a virtual servers each with a mirrored database. I setup another two virtual servers (one in A and the other in B) running factorySQL on both. I setup redundancy on the first FactorySQL (A) pointing to the database on A and the second FactorySQL pointing to the database on B, from the second FactorySQL (B) and connected to the service in the Master which is (A). I don’t know how to establish the cross connection.

DB (A) ----------------- DB (B)
| |
FactorySQL (A) ------ FactorySQL (B)


Mon Jan 18, 2010 11:25 am
Profile
Moderator
Moderator

Joined: Sun Apr 02, 2006 3:43 pm
Posts: 2465
Post Re: FactorySQL Redundancy - Setup
If the database is mirrored, the way you have it set up should be fine. However, if the database is only mirrored one way, historical data can be a problem: when it's written to A, it will be mirrored. But if A goes down and B writes to database B, the data will not make its way back to A.

A potential solution for this is to set up a second database connection for history only that points to A from both machines. When A goes, B will continue to run status/SQLTag stuff, but will cache historical data. When database A comes back up, the cached data will be written.

Hope this helps,

_________________
Colby Clegg
Inductive Automation
Software Development


Mon Jan 18, 2010 1:11 pm
Profile
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: