NetXMS Support Forum

English Support => General Support => Topic started by: sushantd on September 03, 2019, 12:45:58 PM

Title: Netxms HA with Galera Cluster
Post by: sushantd on September 03, 2019, 12:45:58 PM
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
Title: Re: Netxms HA with Galera Cluster
Post by: Victor Kirhenshtein on September 04, 2019, 11:00:52 AM
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
Title: Re: Netxms HA with Galera Cluster
Post by: sushantd on September 04, 2019, 12:25:07 PM
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 
Title: Re: Netxms HA with Galera Cluster
Post by: Victor Kirhenshtein on September 04, 2019, 12:57:28 PM
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
Title: Re: Netxms HA with Galera Cluster
Post by: sushantd on September 05, 2019, 08:26:07 AM
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