High Availability PI System Denis Vacher Paul Combellick Rev 5 High Availability PI System 1. The PI Server Story – Architecture Review – Features, Benefits, Best Practices – Going.
Download ReportTranscript High Availability PI System Denis Vacher Paul Combellick Rev 5 High Availability PI System 1. The PI Server Story – Architecture Review – Features, Benefits, Best Practices – Going.
Slide 1
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 2
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 3
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 4
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 5
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 6
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 7
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 8
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 9
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 10
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 11
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 12
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 13
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 14
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 15
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 16
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 2
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 3
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 4
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 5
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 6
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 7
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 8
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 9
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 10
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 11
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 12
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 13
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 14
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 15
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment
Slide 16
High Availability
PI System
Denis Vacher
Paul Combellick
Rev 5
High Availability PI System
1. The PI Server Story
– Architecture Review
– Features, Benefits, Best Practices
– Going Forward
2. AF High Availability
– AF/SQL Server Architecture
– Demo of AF 2.1
– Feature Summary
3. Closing Words
Interfaces, Server, SDK, Clients
PI HA Architecture
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Primary
PI
Server
Secondary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Time-Series
Data
Data
Heartbeat
PI Interface
Data Collection
& Buffering
PI HA Features & Benefits
System
Management Tools
PI SDK Library
ProcessBook, DataLink, RtWebParts,
Notifications, ACE, etc.
PI Server Collective
Secondary
Primary
Metadata
Replication
Secondary
Metadata
Replication
Time-Series
Data
Heartbeat
Data Collection & Buffering
PI HA Deployment, Best Practices
Site A - PCN Site A Site A - Office
Node 1
Site B
Node 3
Node 2
Node 4
WAN
Goals/Value
Node 1
Node 2
Node 3
Node 4
Interfaces
1
Simple HA
Site A
Site A
-
-
Site A
2
Security Isolation
Site A, PCN
Site A, Office
-
-
Site A
3
Load Distribution
Site A, PCN
Site A, Office
Site A, Office
-
Site A
4
Disaster Recovery
Site A, PCN
Site A, Office
Site B
5
All Combined
Site A, PCN
Site A, Office
Site B
Site A + Site B
Site B
Site A + Site B
PI High Availability FAQs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
How is PI HA different than Clustered/FT hardware?
What about VMware HA and VMotion?
How do I size the hardware for HA servers?
What is the network bandwidth required for PI HA?
Interface buffering: BufServ or Buffer Subsystem?
Are my third-party applications compatible with HA?
Can archives be shared among collective members?
Do I still need PI Server backups?
How does HA change technical support?
What about manual data entry or PI Batch replication?
PI HA Developments “HA2”
3rd Party
SDK
Application
Manual Data
Entry
PI SDK
Display,
Analysis,
Notifications,
etc.
SDK Buffering
PI SDK
PI SDK
Server Side Buffering
Secondary
Secondary
“HA2”
Batch Interfaces
PI API Interfaces
+ Buffering
Primary
AF 2.0 AF 2.1
AF 2.0 + Network Load Balancer
PI System
Explorer
AF SDK Library
SQL
AF
Server
+Server
SQL
Server
TCP/IP
Load
Balancer
AF Server
AF Server
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Clustered SQL Server
PI System
Explorer
AF SDK Library
AF Server
Clustered SQL Server
R/W
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 + Mirrored SQL Servers
PI System
Explorer
AF SDK Library
AF Server
Mirrored SQL Servers
R/W
R/W
Witness
SQL Server
License:
Express
Standard
Enterprise
AF 2.1 HA Collective
PI System
Explorer
PI Notifications, AF-based PI Clients
(WebParts, ProcessBook, DataLink, etc.)
AF SDK Library
AF Server Collective
Secondary
R/O
Primary
Secondary
Health Status
Health Status
SQL Server
Replication
SQL Server
Replication
R/W
R/O
SQL Server
(primary)
Express
Standard
Enterprise
SQL Server
(secondary)
Express
Standard
Enterprise
Setting up an AF Collective
AF 2.1/SQL Server HA Deployments
Non-HA
SQL Cluster
SQL Mirror
AF Collective (Replication)
HA Writes
No
Yes
Yes
No
HA Reads
No
Yes
Yes
Yes
Load Balanced Reads
No
No
No
Yes
N/A
tens of meters
km
thousands of km
No
Yes
Yes
Yes
No
Yes
Yes
No
Read/Write Access during
AF upgrade?
No
No
No
Not while upgrading
Primary
Special Hardware
Required?
No
Yes
No
No
Minimum SQL Server
Edition Required
Express
Standard
Standard
Primary: Standard
Secondary: Express
Max Distance between
SQL Servers
Read Access during
Upgrade?
Read/Write Access during
OS/SQL Upgrade?
HA Services
None
Good
Better
Best
High Availability Summary
• Broad Adoption of PI HA (PR1) More to Come
– Thank You!
• High Availability Coming in AF 2.1
• HA = OSIsoft Core Tenet
• Key Engineering Principles
– Install in place
– Leverage Microsoft technologies
– High value for investment