FAQ about the replication between HFSQL servers
When implementing a replication between HFSQL servers, why are the automatic identifiers coded on 8 bytes?
When the primary key is an automatic identifier, the server must check the uniqueness of the identifiers on all the servers taking part in the replication.
To do so, each replication server uses a range of different values for the automatic identifiers of the created records.
In order for the range of automatic identifiers used by each server to be wide enough, the automatic identifiers must be coded on 8 bytes.
Why are the values of automatic identifiers added once the server replication was implemented so high?
Each server taking part in the replication is using a different range of automatic identifiers based on the identifier of replication server.
The first range of automatic identifiers (the one that starts from 0) will not be used by any server taking part in the replication: this range of identifiers is reserved to the existing data when implementing the first replication.
Therefore, as soon as a new record is created in a server replication, if an automatic identifier is assigned to the file, the value of this identifier will be a high value.
The structure of files was modified in the analysis (addition, modification or deletion of items). How to apply the modifications to the files found on HFSQL servers with a server replication?
All you have to do is apply the modification of structure (automatic data modification) to the master replication server. This automatic data modification can be run:
- from the data model editor,
- when installing the application
- by programming.
During the next data synchronization between servers, the modification of the file structure will be automatically applied to the subscriber HFSQL servers. The stored procedures and the server triggers will also be updated during this synchronization.
Replication of servers: Are the transactions managed on the HFSQL servers?
When records are modified, added or deleted in transaction on a HFSQL server in replication mode, the records are replicated on the subscriber servers only when the transaction is validated.
If the transaction is canceled (rollback), no replication will be performed for the relevant records.
If the transaction is validated, all the operations in transaction will be transmitted to the replicated servers.
Replication of servers: Which security for the replication of servers?
The communication between servers is authenticated. It is not encrypted. We recommend that you use a VPN connection between servers. The communication between servers is authenticated. It is also encrypted.
Replication of servers : How are the server triggers run?
A server trigger associated with a file update is run on the HFSQL server for which the function that activates the trigger is called.
All the modified records are synchronized by server replication.
Therefore, if a server trigger makes modifications in the data, these modifications will be automatically applied to the replicated servers without having to run the triggers on the replicated servers.