Percona Live

Percona Live MySQL Conference, London, Oct 24th and 25th, 2011

Advertisements
Image

Tailing remote Binlogs with MySQL 5.6

Been playing with 5.6 as I am looking for a way to replay binary logs from serval instances into one instance. The new mysqlbinlog options in 5.6 seem to work well at the moment –stop-never seems to be very useful.


Note: the sandbox needed bin-log and server_id set

mysqlbinlog –read-from-remote-server –host=127.0.0.1 –port=5602 –stop-never –user=msandbox –password=msandbox mysql_sandbox5602-bin.000001

Tailing remote Binlogs with MySQL 5.6