Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.