Geek asks and answers

Replication of the master slave MySQL server from the first binlog position

I have two live databases that require migration to a new server. These are large databases that are constantly used.

I want to configure replication using a slave on a new server and start migrating data through. However, I would like to try to avoid execution mysqldumpfor the current master data in order to get the initial position of binlog, since I do not want to lock the database for a long period of time.

Is there any way to find out the earliest master_log_posso that I can start replication from the very beginning? If not, are there any other solutions to avoid transactions (as much as possible)?

+3
source share
1 answer

If you understood correctly, I think Percona Xtrabackupwill help you.

Xtrabackup is a backup tool that allows you to back up MySQL while you work.

With it, Xtrabackupyou can quickly back up data, even if the data is large, and move the backups to the slaves.

+1

More articles:


All Articles