Comments - mysqlbinlog --read-from-remote-server --host=localhost mariadb-bin.000001 -p --raw --stop-never
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
sync_binlog=1 (MDEV-16589 requests this to be the default) is required to ensure that the binlog is on disk in sync with the state of MariaDB.
Incomplete binary logs will have the error you have described.
my server.cnf
server_id = 1 report_host = master log_bin = /var/lib/mysql/mariadb-bin log_bin_index = /var/lib/mysql/mariadb-bin.index relay_log = /var/lib/mysql/relay-bin relay_log_index = /var/lib/mysql/relay-bin.index sync_binlog=1 binlog-format=MIXED
MariaDB [(none)]> show variables like 'sync_binlog%'; +---------------+-------+
+---------------+-------+
+---------------+-------+ 1 row in set (0.001 sec)