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 |
| Status | new | Resolution | open | ||
| Platform | x86 | OS | Windows | OS Version | 8 STD |
| Product Version | |||||
| 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. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2014-04-23 22:16 | Antonis Vakondios | New Issue | |
| 2019-11-06 11:42 | Ruslan Zasukhin | Target Version | => TODO_FEATURES |
