How to sync large tables (50GB) Mysql?

Question

MySQL

There are two servers, on one working project with a 50GB innodb table, in which something is constantly being written and deleted. It is necessary to create a copy of the table on another server, maybe there are some tools? Without stopping the database server.

Answer 1

So is replication. The replica will always keep up to date http://ruhighload.com/post/How+to configure+MySQL+Mas... and https://habrahabr.ru/post/56702/