Consistency checks for heterogeneous topologies

[GoogleCodeExporter]

1. To which tool/application/daemon will this feature apply?

Tungsten Replicator.

2. Describe the feature in general

I. Heterogeneous checks.

Current MySQL-oriented consistency checks are not enough. We need ways of 
checking consistency for the following topologies:

a. MySQL->Oracle
b. MySQL->Verdica (PostgreSQL) - consistency check SQL were translated into PG 
dialect, needs recertification.
c. Oracle -> MySQL

II. Fast non-locking checks.

Current checks are very slow for big tables and they can lock tables for long. 
We need faster checks, working in a sharded fashion.

III. Simple but fast checks.

Simple but fast checks (like COUNT) would be also useful.

3. Describe the feature interface

Should be accessible:
a. On user's request via ./trepctl check
b. Automatically/periodically from within Replicator.

Replicator reaction (warn, go OFFLINE:ERROR, notify) should be configurable.

Original issue reported on code.google.com by 777...@gmail.com on 5 Mar 2012 at 5:47

[GoogleCodeExporter]

Original comment by linas.vi...@continuent.com on 5 Mar 2012 at 5:48

• Changed state: Accepted