MariaDB read replicas Binary Log

wcalove — Thu, 21 May 2020 22:04:54 GMT

I wanted to see if anyone has or knows if Attunity can pick up changes from a read-replica copy of a MariaDB Instance. For example, our in case we have our Master OLTP (INSTANCE 1) Being replicated to a read reaplica instance (INSTANCE RR). We want to just have Qlik DI (Replicate) run against INSTANCE RR and see if those binary logs are populating data. Let me know if you have seen this or if you think this will work.

Re: MariaDB read replicas Binary Log

Steve_Nguyen — Fri, 22 May 2020 12:30:16 GMT

Qlik Replicate can read from Slave Replica, only if you can set

To replicate changes from a slave (CDC), the binary logging parameter log_slave_updates needs to be set to true (1).

log_slave_updates¶

Description: If set to 0, the default, updates on a slave received from a master during replication are not logged in the slave's binary log. If set to 1, they are. The slave's binary log needs to be enabled for this to have an effect. Set to 1 if you want to daisy-chain the slaves.
Commandline: --log-slave-updates
Scope: Global
Dynamic: No
Data Type: boolean
Default Value: OFF

topic MariaDB read replicas Binary Log in Qlik Replicate

MariaDB read replicas Binary Log

Re: MariaDB read replicas Binary Log