White paper on Replicate and Clustering

[RichardP]

Is there a white paper or help topic on how Qlik Replicate works in a clustered server environment? I'm looking for especially how Replicate keeps track of the MySQL bin log it's reading on one server then fails over to the other server and keeps its place in the bin log.

Thanks

[Harel_Barash1 · Accepted solution]

Hello,

Can you clarify if you refer to Replicate clustered server or MySQL clustered environment? 

If Replicate - you can refer to our documentation on this subject Setting up Qlik Replicate in a cluster environment

https://help.qlik.com/en-US/replicate/November2021/Content/Replicate/Main/Clusters/app_cluster.htm

If MySQL - Replicate support a MySQL clustered environment but DOES NOT support MySQL Failover of cluster nodes scenarios. You can find more information on how to set up the environment, and how to manually recover, in these pages-

Cluster prerequisites-

https://help.qlik.com/en-US/replicate/November2021/Content/Replicate/Main/MySQL/prereq_mysql_source....

Limitations and considerations-

https://help.qlik.com/en-US/replicate/November2021/Content/Replicate/Main/MySQL/limitations_mysql_so...

[RichardP]

Thank you! I was referring to a linux cluster that Replicated would run on. I'll take a look at the materials you provided. Thank you.

[Dana_Baldwin]

Hi @RichardP

Please let us know if you have any questions on the documentation that @Harel_Barash1 shared. If not, please mark his comment as a solution.

Thanks in advance!

Dana