Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

Buffering and High Availability

TABLE OF CONTENTS

Load balancing with mirrored SQL Servers

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
  • Last UpdatedJan 22, 2025
  • 1 minute read

It is common practice to deploy AF servers so that each server uses a separate SQL Server, and mirroring is set up between the SQL Servers, as shown in the figure, below. The mirrored SQL Server is initially configured as read only. If the primary SQL Server fails, the "witness" server can automatically place the secondary SQL Server into write mode.

Note also that all load-balanced AF servers must connect to the same SQL Server. Upon failover, you can use the witness server to ensure that all AF servers successfully fail over to the same SQL Server.

Typical configuration using SQL mirroring

Typical configuration with SQL mirroring: AF SDK connects via a load balancer to primary/secondary PI AF Servers, linked to mirrored SQL Servers.

TitleResults for “How to create a CRG?”Also Available in