You can use the following command line scripts to examine and resolve replication conflicts between the servers in a cluster:
rereplicate
copy-db
dump-outgoing-batches
dump-outgoing-conflicts
forget
NOTE:To view all the applicable command line parameters, run the following command:
/opt/penv/bin/au-replica --help
For more information, see the README.txt file located in the /opt/Aucore/aucore/scripts/db-sync/ path.
You can run the following command on the server from where you want to enforce the replication of all tables to the peer servers in the cluster:
/opt/penv/bin/au-replica /opt/AuCore/production.ini rereplicate
To enforce the replication process for a specific table in a server, run the following command in the respective server:
/opt/penv/bin/au-replica /opt/AuCore/production.ini rereplicate [–table <table_name>]
For example, /opt/penv/bin/au-replica /opt/AuCore/production.ini rereplicate [–table <1087>]
To copy the database from specified server to the current server, run the following command:
/opt/penv/bin/au-replica /opt/AuCore/production.ini copy-db [–-host HOST [-p PASSWORD]]
Where HOST is Global Master Server by default. PASSWORD is read from Server table by default.
For example, /opt/penv/bin/au-replica /opt/AuCore/production.ini copy-db -–host aaf1.samplecompany.com -p test123
To view the list of the outgoing batches, run the following command:
/opt/penv/bin/au-replica /opt/AuCore/production.ini dump-outgoing-batches
To view the list of outgoing conflicts that are detected by the server, run the following command:
/opt/penv/bin/au-replica /opt/AuCore/production.ini dump-outgoing-conflicts
To forget a particular outgoing batch, run the following command:
/opt/penv/bin/au-replica /opt/AuCore/production.ini forget-outgoing-batch <batch_id>
For example, /opt/penv/bin/au-replica /opt/AuCore/production.ini forget-outgoing-batch 24
This script is similar to Forget option available in the administration console.