Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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???

share|improve this question
Have you manually run the procedure on the slave? – randy melder Jun 22 '12 at 1:13

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.

For more information: Determination of Safe and Unsafe Statements in Binary Logging

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.