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

migrated from serverfault.com Feb 2 '12 at 13:06

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

1 Answer

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