The NETx Server does not synchronize the data that is stored within the SQL database. This includes trending values and test results of the NETx LaMPS module. However, it is possible to use synchronization features of the SQL database to provide a synchronization of the SQL data.
| Info |
|---|
Please keep in mind that NETxAutomation is not responsible for setting up a synchronization environment of SQL databases. It is within the responsibility of the user. However, NETxAutomation will provide some guidelines that will help to set up such environment. In general it is recommended to consult IT experts for this task. |
In principle, there are 2 possible scenarios for using an SQL database with a main / backup solutions.
...
Using synchronization mechanisms of SQL database provider
Within the second scenario, two SQL instances are synchronized using the synchronization mechanism of the SQL provider. The following figure shows the basic principle:
| Drawio | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Within this scenario, two physical SQL instances are synchronizing the SQL data. If one instance fails, the other takes over. After recovery, the data is synchronized again.
The advantage of this solution is that there is also a full redundancy for the SQL data. From the NETx Server point of view, it looks like a single instance. Therefore, no special configuration efforts are necessary within the NETx Servers. The drawback is the time and effort to set up such an SQL cluster. Furthermore, additional license cost from the SQL provider may occur.
At the time of writing this document, successful tests with MS SQL Server synchronization have been done. However, for MS SQL Server synchronization, additional license costs from Microsoft will occur. For MariaDB, no information is available, yet.
| Info |
|---|
Please keep in mind that NETxAutomation is not responsible for setting up a synchronization environment of SQL databases. It is within the responsibility of the user. However, NETxAutomation will provide some guidelines that will help to set up such environment. In general it is recommended to consult IT experts for this task. |