View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0006839||VALENTINA SERVER||Database||public||2014-04-23 22:16||2019-11-06 11:42|
|Reporter||Antonis Vakondios||Assigned To|
|Priority||normal||Severity||feature||Reproducibility||have not tried|
|Platform||x86||OS||Windows||OS Version||8 STD|
|Target Version||TODO_FEATURES||Fixed in Version|
|Summary||0006839: Feature Request - Active/Standby Server|
|Description||FR: Online sync between two Valentina Servers. The 1st server will work as an active database and to have the ability to failover to standby Valentina DB.|
Standby VDB will have the ability to run readonly views/reports for Reporting (execute reports). Synchronization can be done through files (sqllogs) or tcp connectivity.
|Additional Information||I have implemented the ACTIVE/Standby scenarios functionality, using Xojo programming language. Each incoming request for db action (Write/Update/Delete), forward in parallel on two Valentina Servers. In case on any failure on primary server (lost connectivity, server down, etc) , I reconnect Xojo with the second Valentina server and safe on log files, any actions on primary DB. After a user reaction on the 1st server, I am applying the changes that it happened on the secondary server. With this way, I have two Valentina servers with 100% sync. This is a solution also for online backup.|
But, I am preferring to have the upper functionality, build in on Valentina server.
|Tags||No tags attached.|