Netxms HA with Galera Cluster

[sushantd]

Hi I want to enable HA of Database in Netxms using Galera Cluster Replication. I have successfully configured Cluster but Database is not updating on Slave node "For Example when I add a device through Netxms Console on Master Server it is not replicated to Slave Server in fact its get replicated only after restarting netxmsd service on the Slave Server"

Kindly help.

Thank you
Sushant D

[victor]

Hi,

you cannot have two running NetXMS servers connected to the same database. It should be either active/passive cluster, or two separate instances.

Best regards,
Victor

[sushantd]

Hi Victor,

I have 2 Sever with separate Database service on each Server. I am using multi master replication between both Server.

Thank you
Sushant D

[victor]

That won't work either - server caches lot of information (including all objects) for performance reasons and does not expect direct modifications to database.

Best regards,
Victor

[sushantd]

Hi Victor,

Could you please guide us on setting up Netxms replication using Mariadb Galera. We want to use both Synchronous and Asynchronous replication with one Master Server and multiple Slave Server.

Thanks
Sushant