You are here

Compare

The Ops Center compare tool is made to compare different MySQL schema either in structure or in content:

Compare tool

As a next step you have to select the databases (instances) which you want to compare:

Compare tool instance selection

In a third step you have to select the schema you would like to compare:

Compare tool schema selection

Structure compare

In the structure compare you can see the tables which are missing and the differences of the tables:

Structure compare differences

Content compare

In the content compare you can see if the tables have different or if they have equal content:

Content compare differences

Important: If you have traffic on those tables it might be that the content is reported differently even it is equal. For performance reasons big tables are not compared at the moment yet.