Set Up an In-Memory DB Cluster

Prerequisites

• Before setting up a database, ensure that you are working within a provisioned Virtual Data Center (VDC) that contains at least one VM from which the database will be accessed. The VM you create is counted against the quota allocated in your contract.

• Database Manager is available only for contract administrators, owners, and users with Access and manage DBaaS privileges. You can set the privilege via the DCD group privileges. For more information, see Manage User Access.

Create a cluster

To create an In-Memory DB cluster, follow these steps:

1. Log in to the DCD with your username and password.

2. Go to Menu > Databases > In-Memory DB.

Info: The In-Memory DB cluster overview section displays the resources allotted to your contract and the number of used and unused resources.

1. Click Create cluster to create a new In-Memory DB cluster.

2. Enter the following details in the Create In-Memory DB Cluster window:

   • Define cluster properties

   • Select the required number of resources

   • Connect the In-Memory DB cluster with a VDC

   • Schedule cluster maintenance

   • Define users

Result: The Estimated costs will be displayed based on the input. It is exclusive and certain variables like traffic and backup are not considered.

1. Click Save to create the In-Memory DB cluster.

Result: Your In-Memory DB Cluster is now created.

Define cluster properties

To define cluster properties, specify the following:

1. Cluster Name: Enter an appropriate name for your In-Memory DB cluster.

2. Version: Select a version from the drop-down list.

3. Instances: Enter the number of In-Memory DB nodes you want in the cluster. The primary In-Memory DB node always manages the data of exactly one database cluster. You can also use the arrows to increase or decrease the number of nodes. Replication is possible only when you define more than one node.

Note: Here, you will have a primary node and one or more secondary nodes that run a copy of the active database, so you have n-1 secondary nodes in the cluster.

1. Location: Select a location of your preference from the drop-down list.

2. Replication Type: The replication type is asynchronous by default for In-Memory DB. You will see this option only upon selecting more than one node (instance). In an asynchronous mode, the primary In-Memory DB node does not wait for a replica to indicate that the data has been written. The cluster can lose some committed transactions to ensure availability.

3. CPU Type: The CPU type is set to Dedicated Core, by default.

Select the required number of resources

To select the number of resources that you want to associate with the In-Memory DB cluster, specify the following:

1. Number of CPUs (per instance): Increase or decrease the number of CPUs using the slider.

2. RAM Size (per instance): Increase or decrease the size of the RAM using the slider to suit your needs.

3. Storage Type: Currently, IONOS supports only SSD Premium, which is selected by default.

4. Storage Size: Enter the storage size, in Gigabytes (GB), either manually or use the arrows to increase or decrease the storage size accordingly based on your needs.

Connect the In-Memory DB cluster with a VDC

You can also click How to get the IP section on the right side to know how to retrieve an IP address.

1. Datacenter: The data center is set to Germany/Berlin, by default.

2. Datacenter LAN: Select a LAN from the drop-down list for the data center.

3. Private IP: Enter the private IP or subnet using the available Private IPs.

Note: To know your private IP address/Subnet, you need to:

• Create a single server connected to an empty private LAN and check the IP assigned to the respective NIC in the selected LAN. The DHCP in that LAN always uses a /24 subnet, so you must reuse the first 3 octets to reach your database.

• To prevent a collision with the DHCP IP range, it is recommended to use IP addresses ending between x.x.x.3/24 and x.x.x.10/24 (which are never assigned by DHCP).

• If you have disabled DHCP on your private LAN, you must discover the IP address on your own.

Schedule the In-Memory DB cluster maintenance

Your chosen start time (UTC) plus four hours is the maintenance time.

1. Day: Select a day from the drop-down list to set a day for maintenance.

2. Start Time UTC: Enter a time using the pre-defined format (hh:mm:ss) to schedule the maintenance task. You can also click the icon to set a time.

Note: We recommend choosing the day and time appropriately because the maintenance occurs in a 4-hour-long window.

Define users

The credentials of any user who has previously been created in the backup will be overwritten.

1. Username: Enter a username to provide access to the In-Memory DB cluster for the respective user.

2. Password: Enter a password for the respective user.