Replication

Databases creation:

Set DATABASE_NUMBER in config.conf to 1, then launch

python ./base_scripts/db_create.py

Then set DATABASE_NUMBER to 2 and refresh other required settings(such as DB_USER_NAME, DB_PASSWORD, DB_HOST, DB_PORT, DB_NAME) and run db_create.py again.

For migration using GoldenGate application, it is necessary not to replicate LINK_SEQUENCE and UNLINK_SEQUENCE: their start values in different instances must have different parity. Each of two instances changes only it’s own generator, with step equals to 2, to exclude the intersection possibility of values between instances.

It guarantees conflict-free work with list_face and unlink_attributes_log tables.

If you used one database instance and need to use two instances, it needs to create new index in database using sql CLI by running next commands:

CREATE INDEX link_key_func_index ON list_face (list_id, mod(link_key, 2), link_key)