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.
To create an In-Memory DB cluster, follow these steps:
Log in to the DCD with your username and password.
Go to Menu > Databases > In-Memory DB.
Click Create cluster to create a new In-Memory DB cluster.
Enter the following details in the Create In-Memory DB Cluster window:
Result: Estimated costs are calculated based on the values and displayed. It is exclusive and certain variables like traffic and backup are not considered.
Click Save to create the In-Memory DB cluster.
Result: Your In-Memory DB Cluster is now created. The STATE is set to Busy when the cluster is in creation and Available after creation.
To define cluster properties, specify the following:
Cluster name: Enter an appropriate name for your In-Memory DB cluster.
Version: The value is set to 7.2, by default.
Instances: Enter the number of In-Memory DB nodes you want in the cluster. You can create a maximum of five nodes within a 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.
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.
Location: Select a location of your preference from the drop-down list. The drop-down list displays the server locations where you can create clusters.
CPU Type: The CPU type is set to Dedicated Core, by default.
Persistence: Select one of the following persistence modes: In-Memory, AOF (Append Only File), RDB (Redis Database File), or RDB and AOF. For more information, see Data Persistence.
To select the number of resources that you want to associate with the In-Memory DB cluster, specify the following:
Number of CPUs (per instance): Increase or decrease the number of CPUs using the slider.
RAM Size (per instance): Increase or decrease the size of the RAM using the slider to suit your needs.
You can also click Finding Your Private IP Address section on the right side of the window to know how to retrieve a private IP address.
Datacenter: The data center is set to Germany/Berlin, by default.
Datacenter LAN: Select a LAN from the drop-down list for the data center.
Private IP address: Enter the private IP address or subnet using the available Private IPs.
Note: To know your Private IP address/Subnet, refer to the instructions listed beneath Finding Your Private IP Address on the DCD.
Your chosen start time (UTC) plus four hours is the maintenance time.
Day: Select a day from the drop-down list to set a day for maintenance.
Note: We recommend choosing the day and time appropriately because the maintenance occurs in a 4-hour-long window.
The credentials of any user who has previously been created in the backup will be overwritten.
Username: Enter a username to provide access to the In-Memory DB cluster for the respective user.
Password: Enter a password for the respective user.
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.
After cluster creation, you can view the list of In-Memory DB clusters, delete them if they are no longer required, or restore a specific cluster backup, if needed.
If you have already defined clusters, the In-Memory DB cluster overview window displays the resources allotted to your contract and the number of used and unused resources.
To view a list of the clusters, follow these steps:
Log in to the DCD with your username and password.
Go to Menu > Databases > In-Memory DB.
Result: A list of all In-Memory DB clusters is displayed. You will see the following details: — NAME: Displays the name of the cluster. — STATE: Displays the state of the respective In-Memory DB cluster. — BUSY: When the cluster is in the creation mode or it is being updated. — AVAILABLE: When the cluster is available and healthy. — DESTROYING: When the cluster is being deleted. — FAILED: An error occurred. — LOCATION: Displays the location where the In-Memory DB cluster is located. — INSTANCES: Displays the number of nodes. — VERSION: The version is set to 10.6 by default. — OPTIONS: Select to perform the following: — View details: Select this option to view the details of the respective cluster. — Delete: Select this option to delete the corresponding cluster. In the confirmation dialog box, select Delete to confirm deletion. For more information, see Delete an In-Memory DB Cluster.
To view the details of each cluster in the Details window:
Log in to the DCD with your username and password.
Go to Menu > Databases > In-Memory DB.
You can navigate to the Details window using either of these options:
Select the name of the cluster.
Using the View details option from the OPTIONS column.
You can view the following:
Properties: Displays the cluster's UUID, DNS name, its version, state, the number of instances created, and the data center location where it is located.
Instance configuration: Displays the number of CPU cores utilized and the RAM size used.
Maintenance: Displays the stipulated day of the week and the time scheduled for the maintenance window.
Estimated price: Displays the cost for the resources used.
Backups: Click to display the number of In-Memory DB backups available for restoration. Select Restore to restore a specific backup.
Select Restore in the confirmation dialog box.
Result: The chosen backup is restored.
Note: Select Delete cluster to delete the respective cluster. In the confirmation dialog box, select Delete to confirm deletion. For more information, see Delete an In-Memory DB Cluster.
To delete an In-Memory DB cluster, follow these steps:
Log in to the DCD with your username and password.
Go to Menu > Databases > In-Memory DB. You will see the list of all In-Memory DB clusters.
Click in the OPTIONS column and select Delete.
Alternatively, you can also click on the In-Memory DB cluster that must be deleted and select Delete cluster on the Details window.
Select Delete in the dialog box to confirm deletion.
Result: The respective In-Memory DB cluster is set to DESTROYING before it is completely deleted.
