Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
23.08.6
-
OS = Linux maxscale-binlog-router 4.18.0-448.el8.x86_64 #1 SMP Wed Jan 18 15:02:46 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux
MaxScale = 23.08.6
MariaDB (slave) = 10.11.7
mariadbd --print-defaults = attach mariadb.defaults
-
MXS-SPRINT-213, MXS-SPRINT-214
Description
MaxScale works in binlogrouter mode.
Router = binlogrouter, Params in attach Params.json
binlog_size=1G
When rotating binlogs, maxscale does not have time to create a new file and make it writable. In this case, an error occurs when recording a portion of transactions (maxscale.log). It may be necessary to create the next binlog file in advance and keep it open. Don't wait until the current binlog file ends, but always have +1 for the next binlog file.
At the same time, the slave mariadb cannot receive transactions that remained in the write buffer (for old closed binlog file) and were written to a new binlog file (mariadb_slave.log).
Examples of searching for two transactions from the last two errors in the maria_slave.log file
(last2errors.log)