MySQL Replication - replication issues; procedures registered on master not giving same result on slave in MySQL 5.5.20

Question

I am not able to replicate procedures registered in the Master to the Slave in MySQL 5.5.20

The Procedure is registered on the Master and can be seen on Slave. However, results fetched using the same tables are different.

Anyone know how can I debug and solve this???

Cristian Porta · Answer 1 · 2012-09-12 06:23:01Z

You have to pay attention on you replica configuration, first of all it is a statement-based o row-based replica?

Probably you run an "unsafe" statement in you master server so the slave can't apply same statement in deterministic mode.

Check the master error.log for warnings like:

[Warning] Unsafe statement written to the binary 
log using statement format since BINLOG_FORMAT = STATEMENT.

1 Answer