HADR with multiple standbys

Db2 on Red Hat OpenShift supports HADR with multiple standby databases. Using multiple standbys, you can have your data in more than two sites, which provides improved data protection with a single technology.

HADR allows you to have up to three standby databases in your setup. One of these databases must be designated as the principal HADR standby database; any other standby database is an auxiliary HADR standby database.

For full documentation on this configuration, see HADR multiple standby databases.

Restrictions

• Databases must be designated during configuration as primary, principal standby, and auxiliary standby. These roles cannot be changed without re-configuration.
• Automated failover via Governor is only supported between the primary and principal standby databases.
• Failover to an auxiliary standby database must be initiated manually.
• Automatic HADR restarts are limited for pod restarts on the designated auxiliary database. HADR automatically restarts as standby only if that database was in an HADR standby role. Due to manually initiated failover, HADR does not automatically restart as primary if that database was in a primary role. This prevents a split-brain scenario, as Governor is not supported on the designated auxiliary.