binrpt is a daemon that reads MySQL binlog and executes replication SQL.
binrpt is a daemon that reads MySQL binlog and executes replication SQL.
Usage of binrpt:
-config string
Config file path
-debug
Debug mode
-dryrun
Dry-run mode
-version
Print version and exit
[source]
charset = "utf8mb4"
host = "source.db.example.com"
password = "replpwd"
port = 3306
replicate_server_id = 100
username = "repl"
#binlog_buffer_num = 0
[replica]
charset = "utf8mb4"
host = "replica.db.example.com"
password = "scott"
port = 3306
replicate_do_db = "test"
replicate_ignore_tables = ["^secure_"]
username = "tiger"
#save_status = false
#table_info_from_src = false
docker compose build
docker compose up -d
make
cp config.toml.example config.toml
./binrpt -config config.toml
~$ mysql -u root -h 127.0.0.1 -P 13307 test -e 'select * from test'
+----+-----+-----+
| id | num | str |
+----+-----+-----+
| 1 | 100 | foo |
| 2 | 200 | bar |
| 3 | 300 | zoo |
+----+-----+-----+
~$ mysql -u root -h 127.0.0.1 -P 13306 test
mysql> insert into test (num, str) values (1, "abc");
mysql> update test set num = id + 1000 where id = 2;
mysql> delete from test where id = 1;
mysql> exit;
~$ mysql -u root -h 127.0.0.1 -P 13307 test -e 'select * from test'
+----+------+-----+
| id | num | str |
+----+------+-----+
| 2 | 1002 | bar |
| 3 | 300 | zoo |
| 4 | 1 | abc |
+----+------+-----+