Netxms HA with Galera Cluster

Started by sushantd, September 03, 2019, 12:45:58 PM

Previous topic - Next topic

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 Kirhenshtein

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 Kirhenshtein

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