Modifying your cluster

Modifying your cluster

Big Animal provides you the opportunity to modify the cluster by editing its configuration settings.
You can also modify the clusters by installing Postgres extensions.

Modifying Cluster's Configuration Settings

1. Sign in to the BigAnimal portal
2. On the clusters page, You will see the list of clusters. Select the name of the cluster you want to edit.
3. From the top right corner of the Cluster Info panel select the edit cluster option.
4. You can modify some of the following settings on the tab of the edit cluster page. I have separated the settings with respect to different tabs. ### Cluster Info tab:
   • Cluster type setting: You cannot shift from a high availability cluster or a single node cluster to a distributed high availability cluster or vice versa.
   • Number of Replicas.

Cluster Settings tab:

• Instance Type: Changing instance types can lead to higher infrastructure charges.
• Volume Type: You cannot switch between the io2 and io2 Block Express volume types in an AWS cluster.
• Volume Properties: It can take up to six hours to tune IOPS or resize the disks of your cluster because AWS requires a cooldown period after volume modifications.
• Networking type: If you are using Azure and previously set up a private link and want to change to a public network you must remove the private link resources before making the change.
• Cluster Name and Password.

Data Groups tab:

• Nodes: After the creation of the cluster, you cannot change the number of data nodes.

DB Configuration tab:

• Database configuration parameters: If you are using faraway replicas, only a small subset of parameters are editable. These parameters need to be modified in the replica when increased in the replica's source cluster.

Additional Settings tab:

• Retention period for backups.
• Custom maintenance window: You can set or modify the maintenance window where maintenance upgrade occurs for the cluster.
• Read-only workloads: Enabling read-only workloads can lead to higher cloud infrastructure charges.
• PgBouncer: Enabling the feature of pg bouncer can also lead to higher infrastructure costs.
• IAM(Identity access management): Turning on the ability to log into the Postgres using IAM credentials.
• Super User access: Disabling the option removes superuser access for edb_admin but any other superusers existing in the database retain their superuser privileges.

Modify a data group:

You can modify the data groups in your distributed high-availability cluster by editing the configuration settings. You can follow the below steps to modify a data group.

1. Sign in to the BigAnimal portal.
2. On the clusters page, you will be shown a list of data groups, select the data group you want to edit.
3. Select the Edit, option next to the data group.
4. Edit the cluster settings in the Data Groups tab.
5. Select save.
6. Confirm the changes in the pop-up window.

References:

1. https://www.postgresql.org/docs/
2. https://www.enterprisedb.com/docs/biganimal/latest/using_cluster/03_modifying_your_cluster/
3. https://dev.to/talhahahae/db-configuration-and-additional-settings-tab-in-edb-biganimal-5i8
4. https://dev.to/talhahahae/cluster-settings-tab-in-biganimal-5ebp