Multiple Strapi instances with one MySQL database - losing data

System Information
  • Strapi: 4.15.5
  • OS: Windows Server 2016
  • DB: MySQL 5.7
  • Node: 20.11.1
  • NPM: 10.2.4

We started with strapi with 1 webserver and 1 MySQL server. Then recently we upgraded it to 2 webservers (for redundancy) which host strapi, single DB server remained unchanged. After the upgrade it happens that sometimes content changes (relations) get erased from the database. I should also mention we use only 1 of those webservers to do any content changes and there is a single person editing one content item at a time. What could be the cause? Are there any special settings with strapi to run it in multi-server mode? Thanks!

We started with strapi with 1 webserver and 1 MySQL server. Then recently we upgraded it to 2 webservers (for redundancy) which host strapi, single DB server remained unchanged. After the upgrade it happens that sometimes content changes (relations) get erased from the database. I should also mention we use only 1 of those webservers to do any content changes and there is a single person editing one content item at a time Next Care Urgent Care. What could be the cause? Are there any special settings with strapi to run it in multi-server mode? Thanks!

The issue of data loss in your multi-server Strapi setup might be due to synchronization problems or configuration settings. Ensure proper database transaction management, verify Strapi configurations for multi-server environments, and check for any errors in logs. Refer to Strapi’s documentation for guidelines on running in multi-server mode.

Regards,
Diana P.