Implementing log-based replication: Modifying the analysis

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Help

WLanguage

Database management

Management of replication

Logged replication

Implementing the logged replication: Modifying the analysis

Overview

Managing log-based replication for a data file

Consequences of implementing log-based replication

Generating the analysis

See also

Log-based replication

Implementing log-based replication: Modifying the analysis

Available only with this kind of connection

Overview

Log-based replication can be implemented in the data model editor:

when creating a file. This file creation wizard asks if this file must manage log-based replication.
on an existing file (no matter whether the application was distributed or not).

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Managing log-based replication for a data file

To implement log-based replication on a file:

Open your analysis in the data model editor.
For all the files in replication, select "Log-based replication (for compatibility with the earlier versions)" ("Various" tab of the file description). Messages are displayed if your files do not comply with the conditions for using the replication (see the next paragraph).
Caution: the log process is automatically implemented when the log-based replication is implemented. Indeed, the log process allows you to easily find out all the operations performed on the files in order to apply them to the different databases. See The log process for more details.
Generate your analysis.

Consequences of implementing log-based replication

Required or recommended conditions

When implementing log-based replication on a data file, WINDEV and WEBDEV:

Propose to use an automatic 8-byte identifier in the files in log-based replication:
To simplify log-based replication, we recommend that you use an automatic identifier in your data files. This automatic identifier is entirely managed by WINDEV and WEBDEV. To avoid the duplicate errors during the replication, ranges of identifier numbers are allocated to each site involved in the replication.
The use of an automatic identifier is highly recommended but not mandatory. Indeed, you always have the ability to manage a custom identifier containing, for instance, an automatic identifier and the initials of the site or person creating the record.
Implement the log process for the selected data file:
Indeed, the log process allows you to easily find out all the operations performed on the files in order to apply them to the different databases. The "Log of write operations + history of accesses" log process is automatically implemented when "Log-based replication" is checked.

Directory for creating the files required by the log-based replication

Log-based replication is closely linked to the log process. The log process is automatically enabled when log-based replication is implemented in an application.

For all the files used (data files, log files or replication files), the paths of the corresponding physical files can be defined in the data model editor or by programming.

By default, the tree structure of the data files is as follows (example for the SalesMgt application):

The following table presents the default value for these different directories and their configuration mode in the data model editor or by programming.

	Default value	Where to configure it in the data model editor?	How to change the default value by programming?

Directory of data files	Directory of the executable.	For all the data files of the application: "Details" tab of the analysis description For each file: "Info" tab of the file description.	To modify the default directory for the data files of the application, use HSubstDir. When creating the files for the log process and for the replication, the created directories will be relative to this new directory. Remark: To modify the directory for one of the data files only, use HChangeDir.
Directory of the files for replication	RPL sub-directory of the default directory of the data files.	"Log\Replica" tab of the analysis description.	Specify the requested directory in HCreateMasterReplica and HCreateSubscriberReplica.
Directory of files for log process	JNL sub-directory of the default directory of data files.	For all the data files of the application: "Log\Replica" tab of the analysis description. For each file: "Various" tab of the file description.	To modify the directory of log files, use HChangeLogDir. This function is used to: change the directory of Log file (JNL file) change the directory of the JNL file and the directory of the files for the log process (JournalIdentification and JournalOpération files).

Caution: To manage log-based replication in an application, the table of log operations (JournalOpération.fic file) must be identical for all files in replication in the same analysis.

Generating the analysis

To take into account the implementation of log-based replication in the analysis, you must generate the analysis.

If the application already handles data files, this analysis generation triggers an automatic modification of the data files in order to:

take log-based replication into account,
take the log process into account (if necessary)
implement the automatic identifiers.

This modification of the data files will also have to be performed when installing the application (if the application was already deployed).

Caution: If logs already existed, these logs are automatically cleared during the automatic modification. Before starting the automatic modification, the existing logs can be saved by WDLog.