External Data Mart high availability

Last Updated : Feb 23, 2023 |

Avaya Oceana® supports High Availability (HA) of Context Store External Data Mart (EDM) in three scenarios: Two for Avaya Oceana® and one for a standalone Context Store:

  • For Avaya Oceana®:

    • Context Store EDM is installed co-resident with Avaya Control Manager databases on a cluster of Microsoft SQL Servers using Microsoft SQL Server Enterprise Edition and Windows AlwaysOn Advanced Availability Groups (AAG).

    • Context Store EDM is installed without the Avaya Control Manager databases (Also known as standalone EDM) on a cluster of Microsoft SQL Servers using Microsoft SQL Server Standard Edition and Windows AlwaysOn Basic Availability Group (BAG).

  • For standalone Context Store:

    • Context Store EDM is installed standalone on a cluster of Microsoft SQL Servers using Microsoft SQL Server Standard Edition and Windows AlwaysOn Basic Availability Group (BAG).

Important:

  • For a non-HA configuration in production environments, the co-resident deployment of Avaya Control Manager and EDM is not supported.

  • In an availability group, you must have a maximum of two EDM replicas.

Note:

Context Store supports the EDM database running the Microsoft SQL Server versions specified in the tables below on any supported version of the Windows Operating System.

For more information about supported version combinations on the Microsoft Documentation website, see:

Supported combinations of Avaya Control Manager and Context Store EDM co-resident deployment using AlwaysOn AAG

Note:

For more information about TDE, see the Transparent Data Encryption (TDE) on External Data Mart section of this document.

The following version combinations are tested for the co-resident deployment using AAG:

Note:

The following supported versions apply to the Context Store EDM when it is deployed as part of the Avaya Oceana solution.

Microsoft SQL Server

Microsoft SQL Server Edition

Database Encryption at REST Support

2019

Enterprise

Supported through TDE (Transparent Data Encryption)

2017

Enterprise

Supported through TDE (Transparent Data Encryption)

2016

Enterprise Edition SP2

Supported through vCenter Encryption

Supported combinations of MS SQL Server and Context Store EDM using AlwaysOn BAG

Note:

For more information about TDE, see the Transparent Data Encryption (TDE) on External Data Mart section of this document.

Note:

The following supported versions are only applicable to the Context Store EDM when it is deployed as part of the Avaya Oceana solution.

The following table displays the supported combinations for MS SQL Server and Context Store EDM using AlwaysOn Basic Availability Group (BAG):

Microsoft SQL Server version

Microsoft SQL Server Edition

Microsoft Windows Server OS

Database Encryption at REST Support

2019

Standard

2019

Supported through vCenter Encryption or TDE (Transparent Data Encryption).

2016

Standard Edition SP2

2016

Not supported

For more information on how to deploy EDM as standalone or as co-resident with Avaya Control Manager on MS SQL server, see Chapter 10: Deploy External Data Mart in the Deploying Avaya Oceana® guide.

If you are a non Avaya Oceana® user, see Database deployment for more information on how to deploy EDM within a standalone Context Store deployment. Also, see Configure Windows Server Failover Cluster to learn how to set up a cluster of two Windows OS servers, and how to configure them into a Windows Server failover cluster before installing SQL Server.