Hi,
Has anyone attempted or seen any existing implementations "physical"
replication between two
MariaDB instances, where a secondary read-only instance would follow
the primary by
directly reading and applying page changes from the primary's redo logs?
The secondary instance would start (and restart if necessary) using a
full copy of the data from the primary instance, but while running
keep itself current by reading redo logs from the primary instance,
and apply pages based on the increasing LSN number. I call this
"physical" replication to distinguish it from normal logical
replication based on e.g. binlogs, and this would obviously only work
for InnoDB.
Thanks,
Otto