View Issue Details

IDProjectCategoryView StatusLast Update
0006839VALENTINA SERVERDatabasepublic2019-11-06 11:42
ReporterAntonis Vakondios Assigned To 
PrioritynormalSeverityfeatureReproducibilityhave not tried
Status newResolutionopen 
Platformx86OSWindowsOS Version8 STD
Target VersionTODO_FEATURES 
Summary0006839: Feature Request - Active/Standby Server
DescriptionFR: 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 InformationI 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.
TagsNo tags attached.


There are no notes attached to this issue.

Issue History

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