[server]

log-bin=1

wsrep_gtid_mode=1

server-id=777

podman run -dt --rm -v /opt/MDEV-29785:/etc/mysql/conf.d --name mariadb-master -e MYSQL_ROOT_PASSWORD=root mariadb:10.4

podman run -dt --rm --name mariadb-slave -e MYSQL_ROOT_PASSWORD=root mariadb:10.4

# Start slave

change_master="

CHANGE MASTER TO MASTER_HOST=\"$(podman inspect mariadb-master -f '{{ .NetworkSettings.IPAddress }}')\",

MASTER_USER=\"root\",

MASTER_PASSWORD=\"root\",

MASTER_USE_GTID=slave_pos;

START SLAVE;"

podman exec -it mariadb-slave mysql -uroot -proot -e "$change_master"

# Do something on master

podman exec -it mariadb-master mysql -uroot -proot -e "create database derp"

# verify replication is OK

podman exec -it mariadb-slave mysql -uroot -proot -e "show databases"

# This works : bump gtid seq no and create a database

podman exec -it mariadb-master mysql -uroot -proot -e "SET SESSION gtid_seq_no=1000; CREATE DATABASE derp_also;"

# This works : bump gtid seq no and create a table

podman exec -it mariadb-master mysql -uroot -proot -e "SET SESSION gtid_seq_no=2000; CREATE TABLE derp.duh (id int unsigned auto_increment primary key);"

# This doesn't work : bump gtid and INSERT

podman exec -it mariadb-master mysql -uroot -proot -e "SET SESSION gtid_seq_no=3000; INSERT INTO derp.duh (id) VALUES (null);"

# Slave stoppped

podman exec -it mariadb-slave mysql -uroot -proot -e "show slave status \G"

# Binlogs show duplicate event for GTID 0-777-3000 trans

podman exec -it mariadb-master /bin/bash -c "/usr/bin/mysqlbinlog /var/lib/mysql/\$(tail -n1 /var/lib/mysql/1.index)"