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'm working on MySQL database, well i have a master instance and slaves, and i need to add a new slave to Master. I adopt a simple strategy to do so: Stop slave, import data to new slave, and finally start new slave.

Well i get a dump using mysqldump, and import data even i get lot of lock. Some queries have the state update, so i did not know if it is a innodb lock or input/ouput error.

Finally, i imported the hole of data, but i suspect later that the binary log was missing on master, because the rotation log was for 1 day.

My question is how to do a good replication master->slave?

share|improve this question

migrated from Feb 2 '12 at 13:06

This question came from our site for system and network administrators.

For setting a good Master- Slave Replication please visit this link What is the Best Way to create MySQL Master-Slave Replication Setup and Troubleshoot it?

You can read it's a good answer.

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.