Arne Blankerts on Nostr: Is there a way to replicate changes in an append-only fashion to a secondary/backup ...
Is there a way to replicate changes in an append-only fashion to a secondary/backup mysql/mariadb server? So pretty much, only INSERT statements.
This is an event store, so once written, events will never change.
For added security and data protection, I want to ensure that the backup can not ever loose anything by accident or due to an attack.
I know about "replication-with-restricted-privileges", but that will break when checks fail. I'm not sure I want this, or do I?
/cc npub1slyc6w2fy6t7sk7e5caxclu2dn629l35n4tkjyxzrqndkpq86x2sfut8j7 (npub1sly…t8j7)
This is an event store, so once written, events will never change.
For added security and data protection, I want to ensure that the backup can not ever loose anything by accident or due to an attack.
I know about "replication-with-restricted-privileges", but that will break when checks fail. I'm not sure I want this, or do I?
/cc npub1slyc6w2fy6t7sk7e5caxclu2dn629l35n4tkjyxzrqndkpq86x2sfut8j7 (npub1sly…t8j7)