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.