You can configure an SQL repository so it does not automatically update the das_gsa_subscriber
table, by setting the SQL Repository component’s autoUpdateSubscribers
property to false
. In general, you do this in order to protect a live site from updates that are liable to degrade performance.
When updates to das_gsa_subscriber
are disabled, the Oracle Commerce Platform does not add or remove items from the das_gsa_subscriber
table. In this case, it only prints warnings when an event server:
Tries to send a cache invalidation event and cannot find itself in the table.
Cannot send a cache invalidation event to a server that is listed in the table.
You can confirm that cache invalidation events are distributed correctly if you can modify items that use distributed TCP caching on each server and avoid any warnings.
Populating das_gsa_subscriber
A site that prohibits updates to das_gsa_subscriber
assumes that the table is fully populated with valid caching data. However, this table can only be populated if updates are initially enabled. In order to populate the das_gsa_subscriber
and disable it for subsequent updates, follow these steps:
On each participating Oracle Commerce Platform instance, set the event server component’s
port
property to an available port.For each repository that uses distributed TCP caching mode, make sure that its SQL Repository component’s
autoUpdateSubscriber
property is set to true (the default).Start all Oracle Commerce Platform instances in the cluster.
After all Oracle Commerce Platform instances start, the contents of
das_gsa_subscriber
should be populated with unique port numbers.Dump the contents of
das_gsa_subscriber
to a backup file, so the data can be restored later.Stop all Oracle Commerce Platform instances that participate in distributed TCP caching.
For each repository that uses distributed TCP caching mode, reset its SQL Repository component’s
autoUpdateSubscriber
property to false.Insert the dumped output into
das_gsa_subscriber
.Restart the Oracle Commerce Platform instances.