Support for SQL Server scaling features

  • This article provides information about the support for various database-level SQL Server scaling, high-availability, and failover features.

    The information is intentionally simplified to provide a general overview of compatibility. For additional details about the technologies that are outlined, please refer to documentation from Microsoft. 

  • The table below describes various SQL Server technologies and information about their compatibility with the Sitecore platform [1].

    Support by Sitecore Standby category Automatic failover Readable secondaries Writable secondaries
    Replication
    Snapshot Replication cold
    Transactional Replication Experimental [4] warm
    Peer-to-Peer Replication warm
    Merge Replication [5] warm
    Azure Geo-Replication Experimental [4] warm
    High-availability
    Log Shipping warm
    Database Mirroring [2] Sitecore 6.6—8.1 warm, hot
    AlwaysOn Availability Groups [3] Sitecore XP 8.2 and later warm, hot
  • For the purpose of this article, the following definitions are used:

    High-availability categories

    Defines the risk of data loss and expected recovery time when using corresponding technology.

    Cold Standby Warm Standby Hot Standby
    Data Loss Likely Possible No
    Recovery Time Hours Minutes/Hours Minutes

    Automatic failover

    Defines whether the setup allows Sitecore instances to automatically switch to failover/secondary SQL Database instance in case of an outage.

    Readable secondaries

    Defines whether the setup allows Sitecore instances read data from secondary SQL databases, effectively enabling a content delivery scenario.

    Writable secondaries

    Defines whether the setup allows Sitecore instances write data to secondary SQL databases, effectively enabling a content editing scenario.

Applies to:

CMS 6+

October 10, 2016
January 27, 2020

Keywords: 

  • CMS,
  • Scaling