Comparing HA Architecture Options
for Oracle Database on Azure VMs
When selecting a high availability architecture for Oracle Database on Azure VMs, it is important to consider technical requirements, costs, and resources available for implementing and maintaining it. This comparison aims to provide information to help select an architecture that best suits all the requirements.
|
Self-built DB Server with Data Guard FSFO |
||||
|---|---|---|---|---|
|
Target uptime SLA |
>99.99% |
99.95% |
99.95% |
Impossible to |
|
High availability |
Active-Active |
Active-Passive |
Active-Passive |
Active-Passive |
|
Load balancing |
Yes |
No |
No |
No |
|
Failover time |
Zero |
Up to several |
Up to several |
Up to several |
|
Database instance |
Oracle Clusterware |
Oracle Clusterware |
Data Guard Broker |
Data Guard Broker |
|
Downtime required for |
No downtime with |
May be needed |
May be needed |
May be needed |
|
Disk i/o failure isolation |
Yes |
Yes |
Yes |
No |
|
Out-of-memory failure |
Yes |
Yes |
Yes |
No |
|
Max storage IOPS |
260K per node |
260K |
260K |
260K |
|
Max storage |
8 GBPS per node |
8 GBPS |
8 GBPS |
8 GBPS |
|
Comprehensive testing |
Performed by |
Performed by |
Customer’s |
Customer’s |
|
Validation of |
Performed by |
Performed by |
Performed by |
Customer’s |
|
Validation of |
Performed by |
Performed by |
Performed by |
Customer’s |
|
Validation of |
Performed by |
Performed by |
Performed by |
Customer’s |
|
Validation of |
Performed by |
Performed by |
Performed by |
Customer’s |
|
Validation of database |
Shared |
Shared |
Shared |
Customer’s |
|
FlashGrid 24×7 support |
Yes |
Yes |
Yes |
No |
|
Operations resources |
Database |
Database |
Database |
Database |
|
Engineering resources |
none |
none |
Database Engineer |
Azure Engineer |