# Master Slave Replication - Object Definitions mismatch

**URL:** <https://forums.percona.com/t/master-slave-replication-object-definitions-mismatch/5571>\
**Category:** Other MySQL® Questions\
**Created:** [April 25, 2017, 5:24am UTC](https://forums.percona.com/t/master-slave-replication-object-definitions-mismatch/5571 "2017-04-25T05:24:59Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Regith](https://avatars.discourse-cdn.com/v4/letter/r/d07c76/32.png) [@Regith](https://forums.percona.com/u/Regith)\
**Post date:** [April 25, 2017, 5:24am UTC](https://forums.percona.com/t/master-slave-replication-object-definitions-mismatch/5571/1 "2017-04-25T05:24:59Z")

</div>

I am having a Master Slave Replication scenario working on MySQL 5.5 server (OS-Suse Linux Enterprise 11 SP1), with 5 databases for different applications. Issue is that, 4 (db1, db2, db4, db5) databases are replicating to the slave server correctly without any error and are consistent. One (db3) is getting the error “Object Definitions do not match” using the mysql utility mysqldbcompare. I have reconfigured the entire setup as a method to remove the mismatch in object definitions. At the beginning, all the 5 databases were consistent, but after some time, object definitions do not match error is getting with the database db3. My.cnf does not include anything to block the replication to the slave.  
Thanks in advance for the help.

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [April 27, 2017, 1:37am UTC](https://forums.percona.com/t/master-slave-replication-object-definitions-mismatch/5571/2 "2017-04-27T01:37:22Z")

</div>

Can you please share my.cnf file from master and slave. Also, exact command used for mysqldbcompare

---

<div class="post-metadata">

**Author:** ![Regith](https://avatars.discourse-cdn.com/v4/letter/r/d07c76/32.png) [@Regith](https://forums.percona.com/u/Regith)\
**Post date:** [May 5, 2017, 8:02am UTC](https://forums.percona.com/t/master-slave-replication-object-definitions-mismatch/5571/3 "2017-05-05T08:02:23Z")

</div>

Attaching the cnf files and the mysqldbcompare command.  
Also some additional info which I forgot to mention in the previous quote.  
Both PRD and SLAVE servers are running on vmware. SLAVE server is taken as a clone of the PRD server thereafter changing the physical address(MAC-id).

[Master.cnf.txt](https://forums.percona.com/uploads/short-url/bNsUmnwFeVnDGyL09oGZTf3ifFt.txt) (236 Bytes)

[Slave.cnf.txt](https://forums.percona.com/uploads/short-url/akqgLW1wRf1jon0IRhkIovCxR9L.txt) (204 Bytes)

[mysqldbcompare.txt](https://forums.percona.com/uploads/short-url/5H75qJZa4XYwBdZx8rKG7gWinjr.txt) (135 Bytes)

---

<div class="post-metadata">

**Author:** ![jrivera](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jrivera/32/13_2.png) [@jrivera](https://forums.percona.com/u/jrivera)\
**Post date:** [May 9, 2017, 2:23am UTC](https://forums.percona.com/t/master-slave-replication-object-definitions-mismatch/5571/4 "2017-05-09T02:23:33Z")

</div>

what mysql utilities version are you using? can you try with latest mysql utilities 1.6.x ? Can you share full output of mysqldbcompare here as well.

---

<div class="post-metadata">

**Author:** ![Regith](https://avatars.discourse-cdn.com/v4/letter/r/d07c76/32.png) [@Regith](https://forums.percona.com/u/Regith)\
**Post date:** [May 12, 2017, 12:22pm UTC](https://forums.percona.com/t/master-slave-replication-object-definitions-mismatch/5571/5 "2017-05-12T12:22:03Z")

</div>

Using Mysql Utilities 1.6  
Attaching the query used and the output obtained.

[dbcompare.txt](https://forums.percona.com/uploads/short-url/cWbieG6Qcu0Zoamuq4Sig8tfaeW.txt) (12.7 KB)