A machine run MySQL5.7, want to have it binlog file, real-time (note: is A real-time synchronization to B machine, need to do? Want to use rsync;

Note: I've tested using the read - from - remote server, is bad; Will be broken;

So I want to use rsync; Don't know if you could achieve effect;

CodePudding user response:

Black hole can be used in a blackhole, engine, this engine will only produce binlog, not write data to a file, you can use this engine from a library, it is equal to the real time backup of the binlog,

CodePudding user response:

Can say you to do so under the meaning of is what?

CodePudding user response:

1, reduce the master to slave synchronization pressure;
2, the relay will only accept binlog, no writing, not only network IO, with a small machine with large network can be;
3, from the things, and then synchronization to cascade the slave does not consider the master synchronization pressure, synchronization can be directly

CodePudding user response:

In general, or build a in B above from the server, so BINLOG can come over and you can only to stop SQL THREAD, so only do BINLOG synchronization