0

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.
user
  • 1,418
  • 8
  • 10
user86187
  • 33
  • 1
  • 5

1 Answers1

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.

quanta
  • 51,413
  • 19
  • 159
  • 217