Context: The Properties database table contains rows beginning with EQSTAMP which contain the instance names of the CM and CD servers.
In our master db we only have a reference to the CM server instance. In our web db we have references to the CM and both CD server instances. In our core db we only have a reference to the CM server instance.
I am led to believe that remote events are only processed when the instance name does not match the instance name of the server that the event is being executed on, and also the WFFM relies on the eventqueue within the core db in order to transfer form submissions from the website to the CM WFFM database.
So it would appear that I am missing rows from the properties table. If I remove rows from the properties table locally the appropriate rows are re-added straight away, but on higher environments (staging and production) these rows are not being added.
I am replicating the core dbs between CM and CDs using merge replication.
Questions: 1) is this the expected behaviour considering my local env is a single server and my higher envs are separate servers for CM and CDs? 2) why are the instance names not being added to the properties table in my staging & production environments?
I have noticed that user account changes are reflected across CM and CDs, but WFFM form submissions not being saved to the SQL db on production (although they are on staging).