Troubleshooting the replication issues
To see the CLI commands, type:
admin: utils dbreplication ?
Most commonly used 4 commands are:
utils dbreplication status
(checks each table on all servers, sees if tables out of synch)
utils dbreplication repair
(use to sync tables, run it on the pub. Can be run for a sub, or all.
“utils dbreplication repair <nodename>” will sync one sub.
“utils dbreplication repair all” will sync all.)
utils dbreplication stop
(use this command on sub and pub before a “utils dbreplication reset” .
Run the “stop” locally on sub, then pub. If you are going to reset all, run stop on each sub, then on the pub)
utils dbreplication reset
(use to restart replication on one sub or all nodes.
Use “utils dbreplication reset <nodename>” to reset replication on one sub.
Use “utils dbreplication reset all” to reset replication on pub and all subs.)
