Configuring the Links Database in a scaled environment with the Publishing Service


Description

For a scaled Sitecore XP environment, it might be necessary to store the Links database in another database instead of the Core one. In this case, you must also apply additional configuration to the Publishing Service.

Before Sitecore XP 10.1, only one shared Links table was used to store all the links in the environment (in the Core or Web database). 

Starting from Sitecore XP 10.1, the Links table functionality was changed. This resulted in each database (Core, Master, Web) storing its own links. However, Publishing Service does not support multiple Link Databases. So, a customer has to reconfigure their Link database to get related items published properly.

Configuration for Sitecore 10.0 and earlier

To move the Links to the Web database:

  1. On Publishing Service host, point the Links Database to the Web database according to the Scaled environment considerations section of the Sitecore Publishing Service Installation and Configuration Guide.
  2. Restart the Publishing Service host to apply the modified configuration.

Configuration for Sitecore 10.1 and later

  1. Open App_Config\Modules\PublishingService\Sitecore.Publishing.Service.SingleLinkDatabase.config
  2. On a Sitecore server with Publishing Service Module installed, check that the Link Database is pointed to a correct database and rebuild all Link Databases from Control Panel.
  3. On Publishing Service, point the Links Database to the same database according to the "Scaled environment considerations" section of the "Sitecore Publishing Service Installation and Configuration Guide".

Note that the configuration file sitecore\Sitecore.Framework.Plugin.Publishing\Config\sc.publishing.relateditems.xml.disabled (for Publishing Service 6.0 or later) or config\sitecore\publishing\sc.publishing.relateditems.xml.disabled (for earlier versions) can be enabled and used to further tune the publishing of related items.