Home / server / Questions / 313816
In Process
user86187
Asked: 2011-09-22 00:36:16 +0800 CST

how mysql replication

  • 772

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.
linux mysql replication database mysql-replication

1 Answers

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

    • 1