MariaDB read replicas Binary Log

[wcalove]

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.

[Steve_Nguyen · Accepted solution]

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