Welcome to OCS Inventory NG community support, where you can ask questions and receive answers from other members of the community.

Please ask questions only in English or French.

Release 2.12.3 available

The official documentation can be found on https://wiki.ocsinventory-ng.org. Read it before asking your question.

Database replication

Hi, OCS Community,

I'm using OCS Inventory 2.5 and AWS RDS MySQL 5.7.23.

Currently it is running in a single configuration, but I created a replica DB because I wanted to distribute the load.

However, replication fails.

"Could not execute Delete_rows event on table ocsweb.prolog_conntrack; Can't find record in'prolog_conntrack', Error_code: 1032; handler error HA_ERR_END_OF_FILE;"

Since the prolog_conntrack table is a memory engine, it seems that the contents are lost and inconsistent when the database is restarted.

Does anyone run the database in a primary replica configuration?

In that case, what kind of setting is it?

Since there is a part called "# Slave Database settings" in ocsinventory-server.conf, I thought that it can be operated with Master / Slave configuration. Is this correct?

Thank you.

in OCS Inventory NG server for Unix by (150 points)

1 Answer

0 votes
 
Best answer
by (24.4k points)
selected by
 
Powered by Question2Answer
...