Database Provisioning on nodes

Feature Overview

Previously when creating a node we could integrate outside databases but CAT-BM would not managed them, now we also added the option for CAT-BM to provision it’s own Highly available PostgreSQL database

Architecture overview

Architecture view
Figure 1. Architecture overview

When adding a node with provisioned database two additional components are deployed, a stateless Database Pool that forwards database connections, and stateful database replicas, one leader and a number of follower defined by the user when creating a node.

How to use

1. When creating a node select Provisioned PostgreSQL in Database configuration.

Database config
Figure 2. Database config

2. Select the amount of replicas to deploy and the resources for each replica and the database pool

Replicas
Figure 3. Replicas

3. Check the summary to see what resources are spent

Resources are spent in addition to the node resources
Reources
Figure 4. Reources

4. The rest of node creation steps can be followed normally