To delete a MariaDB cluster, follow these steps:
Log in to the DCD with your username and password.
Go to Menu > Databases > MariaDB. A list of all MariaDB clusters is displayed.
Click in the OPTIONS column and select Delete.
Alternatively, you can also choose a MariaDB cluster by clicking on its name and in the Details window, select x Delete cluster.
Select Delete in the dialog box to confirm deletion.
Result: The STATE of the respective MariaDB cluster is set to DESTROYING before it is completely deleted.
After creation, you can view the list of MariaDB clusters and delete them if they are no longer required.
To view a list of the clusters, follow these steps:
Log in to the DCD with your username and password.
Go to Menu > Databases > MariaDB.
Result: A list of all MariaDB clusters is displayed. You will see the following details: — NAME: Displays the name of the cluster. Select the name of the cluster to view its details. — STATE: Displays the state of the respective MariaDB cluster: — CREATING: When the cluster is in the creation mode. — BUSY: When the cluster is being updated. For example, after modifying its details or after restoration. — AVAILABLE: When the cluster is available and healthy. — RESTORING: When the cluster is being restored. — DESTROYING: When the cluster is being deleted. — FAILED: An error occurred. — LOCATION: Displays the location where the MariaDB 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: — Details: Select to view the details of the respective cluster. — Delete: Select to delete the corresponding cluster. In the dialog box that appears, select Delete to confirm deletion. For more information, see Delete a MariaDB 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 > MariaDB.
You can navigate to the Details window using either of these options:
Select the name of the cluster.
Selecting Details 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 CPUs utilized, RAM size and the storage used.
Datacenter connection: Displays the name of the data center, the associated LAN, and the dedicated private IP address.
Maintenance period: Displays the stipulated day of the week and the time scheduled for the maintenance window.
Point In Time Recovery: Displays the earliest backup available for restoration. For more information, see Restore a MariaDB Cluster from a Backup.
Delete cluster: Select to delete the respective cluster. For more information, see Delete a MariaDB Cluster.
Learn how to set up a MariaDB cluster. |
Learn how to view the list of MariaDB clusters. |
Learn how to restore a MariaDB cluster from its backup. |
Learn how to delete a MariaDB cluster. |
With IONOS DBaaS, you may roll back your MariaDB clusters to a previous point in time or use it to create a new cluster. This reliable function prevents data loss and downtime in unexpected situations.
For example, consider that certain values were accidentally deleted from your MariaDB cluster around 11 hours today. The easiest way to recover missing data is to restore a backup before 11 hours.
Result: You can restore only one backup at a time, and you must wait for the restoration process to finish before restoring another backup.
The backup must belong to the MariaDB cluster to be restored.
The cluster must be in the AVAILABLE state.
To restore a cluster, follow these steps:
Log in to the DCD with your username and password.
Go to Menu > Databases > MariaDB.
Select a MariaDB cluster from the list by clicking on its name. Alternatively, click Details in the OPTIONS column.
The Details window displays the necessary information of the chosen cluster. For more information, see View the list of MariaDB Clusters.
Point In Time Recovery displays the earliest backup available for restoration. Select Restore backup to choose the date and time for backup restoration.
a. In the Restore backup pop-up window, click within the text box to open the Calendar.
b. Backups are available only for those dates that are available for selection. Select a date and click Ok.
c. Select the Clock icon to set a time for restoring the appropriate backup from the chosen day. Click Ok to confirm your selection.
d. Select Restore to proceed with the restoration.
e. Select Restore to confirm the restoration.
Result: You will receive a confirmation that the cluster will be restored, and the respective cluster's STATE is set to RESTORING.
Before setting up a database, ensure that you are working within a provisioned that contains at least one VM from which to access the database. 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 .
To create a MariaDB cluster, follow these steps:
Log in to the DCD with your username and password.
Go to Menu > Databases > MariaDB.
Click Create cluster to create a new MariaDB cluster.
Enter the following details in the Create cluster window:
Result: The Estimated costs will be displayed based on the input. It is exclusive and certain variables like traffic and backup are not considered.
Click Save to create the MariaDB cluster.
Result: Your MariaDB Cluster is now created. The STATE is set to CREATING when the operation is in progress.
To define cluster properties, specify the following:
Cluster Name: Enter an appropriate name for your MariaDB cluster.
Cluster Version: Select a version of MariaDB from the drop-down list. IONOS only supports Long-Term Support (LTS) versions, starting from MariaDB 10.6.
Instances: Enter the number of MariaDB nodes you want in the cluster. One MariaDB 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 standby nodes that run a copy of the active database, so you have n-1 standby nodes in the cluster.
Location: Select a location of your preference from the drop-down list.
Replication Type: The replication type is Asynchronous by default for MariaDB. You will see this option only upon selecting more than one node (instance). In an asynchronous mode, the primary MariaDB 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.
CPU Type: The CPU type is set to Dedicated Core, by default.
To select the number of resources that you want to associate with the MariaDB 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.
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.
Datacenter LAN: Select a LAN from the drop-down list for the data center.
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.
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 MariaDB cluster for the respective user.
Password: Enter a password for the respective user.
Storage Type: Currently, IONOS supports only , which is selected by default.
Datacenter: Select a data center from the drop-down list to associate it with the MariaDB cluster. The available data centers in the drop-down list vary according to the chosen Location. For more information, see .
Private IP: Enter the private IP or subnet using the available .
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.
