Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm doing mysql replication (master - slave). There are a few questions

  • Can I assign replication for some databases and not all databases that are on master (for example, ON master server there are db's: a, b, c, d I want to do replication on a, b, c only)
  • When I lock the table in the master server and export data. After exporting the data, I unlock the table on the master, After some time (three days) to start configuring the slave, then import data to master .I have a question: can this replication process be active ?
  • Question on backup data mysql: if the mysql DB is too large, can I use mysqldump to export long, the way I was not.
share|improve this question
add comment

1 Answer

I can assign replication for some database not all on master (for example, ON master server have db: a, b, c, d now just replication a, b, c only) -

Sure, you can. Take a look at --replicate-do-db option.

When I lock the table in the master server and export data .After export data finish. I unlock table on the master . After a time (three days) to start configuring the slave, then import data master .I have question: can this replication process is active ?

Because it based on master status when exporting data.

Question on backup data mysql: mysql DB if too large, use mysqldump to export long, the way I was not.

You can do it at the midnight.

share|improve this answer
    
Why midnight is less-busy? ;) –  Korjavin Ivan Sep 21 '11 at 10:04
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.