Switchover process

For administrative reasons, automatic switchovers happen in a controlled, planned manner during the scheduled maintenance. However, data is preserved during a switchover.

During a switchover, the IP address of the primary server is moved to the promoted replica server. Meanwhile, the client is signaled about the switchover by closing the TCP connection on the server. The client automatically closes the connection and reconnects to the database.

Failover process

IONOS DBaaS MariaDB has an automatic failover enabled by default. A failover can occur when the primary node fails. As a result, one of the replicas is chosen and promoted to be the new primary node. When the old primary node returns, it is added as a replica to the cluster.

Although IONOS DBaaS does not grant superuser access to MariaDB services, you may still view database clusters and perform administrator-level activities.

DBaaS services offered by IONOS Cloud

All back-end tasks necessary to keep your database operating at peak efficiency are handled by the IONOS platform. You can perform the following:

• Database installation via the DCD or the DBaaS API.

• Pre-set database configuration and configuration management options.

• Automated backups for seven days with point-in-time restore.

• Regular patches and upgrades during maintenance.

• Service monitoring both for the database and the underlying infrastructure.

Database administration

Tasks related to the optimal health of the database remain your responsibility. These include:

• Optimization

• Data organization

• Index creation

• Statistics modification

• Query optimization by reviewing access plans

Calculate disk requirements

The requested disk space stores all the data that MariaDB is working with, including database logs and binary log files. Each MariaDB instance contains storage of the configured size. IONOS manages and stores the applications and operating system independently from the configured storage.

MariaDB rejects further write requests if the disk exceeds the storage limit. Ensure that you order enough storage to keep the MariaDB cluster operational. You can monitor the storage utilization in the DCD.

You can also verify if the tables are oversized. For more information, refer to the MariaDB Documentation. Bloated tables can consume space, so we recommend diagnosing the cause and reclaiming the free space. For more information, see Diagnose Table Bloating.

Log files

Database log files and binary log files are stored on the same disk as the database. DBaaS deletes older log files automatically with the expire_logs_days in a typical operation mode. The older files are deleted after a retention period of seven days. For more information, refer to the MariaDB Documentation.

IONOS Cloud updates and patches your database cluster to achieve high standards of functionality and security. This includes minor patches for MariaDB and patches for the underlying operating system. Generally, these updates are unnoticeable and do not interrupt your operation. However, occasionally, IONOS restarts your MariaDB instance to allow the changes to take effect.

Prerequisites

• Prepare for a downtime during the version upgrade.

• Ensure the database cluster has enough available storage. While the upgrade is space-efficient (because it does not copy the data directory), some temporary data is written to the disk.

Currently, MariaDB only supports minor upgrades. IONOS replaces the mariadb executable binaries with those from a newer version, followed by the execution of the mariadb-upgrade command.

The process replicates data from the old version to the new version and the database switches to the new version. For more information about the upgrade process, refer to the MariaDB Documentation.

All changes that may cause service interruption (like upgrades) are executed within the maintenance window, which is a weekly four-hour window. During the maintenance window, you may experience uncontrolled disconnections and an inability to connect to the database cluster. Such disconnections are destructive for any ongoing transactions and we recommend you reconnect. For more information about how to configure maintenance windows for MariaDB, see Set Up a MariaDB Cluster.

Features

• ACID Compliance: MariaDB ensures data integrity and reliability through the support of Atomicity, Consistency, Isolation, and Durability (ACID) properties.

• Triggers and Stored Procedures: MariaDB allows the creation of database triggers to automatically perform actions based on specified events and stored procedures for executing sets of SQL statements.

• User Management and Security: Database access can be restricted to authorized users only. Role-based access control, robust encryption support, and user management tools ensure secure access and data protection.

• Indexes and Storage Engines: MariaDB supports various types of indexes to enhance query performance. In addition, it supports storage engines such as InnoDB, MyISAM, and Aria, thus offering flexibility and performance optimization for different use cases.

• Query Optimizer and Performance Tuning: MariaDB's query optimizer and performance tuning capabilities help improve database efficiency and query execution speed.

• Full-Text Search: Integrated full-text search support enables efficient and flexible text searching within large volumes of data.

• Data Compression: Data compression techniques reduce storage requirements and improve query performance.

• Columns Support:

  • Virtual (Computed) Columns enable column definitions based on expressions, thus enhancing data retrieval capabilities.

  • Dynamic Columns capability allows storing different column sets for each row, thus enabling flexible schema design.

• Transactional Support: Comprehensive transaction support, allowing complex operations with rollback capabilities for data integrity.

• SQL Support: Full support for standard SQL and JSON functionalities, facilitating seamless integration with existing applications and tools.

IONOS DBaaS Features

• Upgrades: IONOS DBaaS supports user-defined maintenance windows with minimal service disruption. The database may be unreachable for a few seconds when necessary for restarts or switching to another replica. Single-node clusters temporarily gain a second node when it is necessary to replace the old one. Hence, maintenance downtime is the same for multi-node and single-node clusters.

• Backups: Base backups are carried out daily, with Point-in-Time recovery for one week, ensuring data integrity and quick recovery in case of data loss.

• Database Monitoring and Reporting: MariaDB provides tools for performance monitoring, query analysis, and reporting to help optimize database usage and identify potential issues.

• Self-restore a MariaDB cluster: IONOS DBaaS for MariaDB allows you to automatically restore your MariaDB clusters to a prior state or point in time. In unanticipated circumstances, this dependable feature minimizes data loss and reduces downtime. For more information, refer to the instructions for restoring via the DCD or the API.

Benefits

• Easy Configuration: Configure your MariaDB instance in compliance with IONOS DBaaS's specifications. You can quickly create databases and tables, define user roles, and assign permissions similar to a physical database using SQL commands, IONOS's graphical interface, or API commands.

• Scalable: Because of MariaDB's horizontal scalability, new nodes, storage, memory, and cores may be added to match the growing demand for greater processing power for data.

• High availability: Automatic node failure handling for multi-node and single-node clusters.

• Security: The communication between clients and databases is secured using TLS for secure data transmission if your MariaDB database is set up to use it.

• Programmatic Resource Management: Easy deployment and management in cloud environments through APIs, SDKs, and configuration management tools.

• Resources: It is offered on Enterprise VM, with a dedicated CPU, storage, and RAM. Currently, SSD is the only supported storage option for MariaDB.

• Network: DBaaS supports private LANs only.

• JSON and GIS Support: Effectively storing and querying spatial data and JSON documents is possible with native support for Geographic Information System (GIS) and JSON functions.

Cluster options

Single-node cluster: A single-node cluster only has one "primary node". This node accepts customer connections and performs read and write operations. It is a single point of truth and a single point of failure.

Multi-node cluster: A multi-node cluster contains one "primary node" and one or more "secondary nodes" replicating data from the primary node. The secondary nodes always attempt to keep up-to-date with the primary, but they may lag due to the asynchronous replication. If the current primary node fails, a secondary node elevates to the primary node. The old primary node is automatically fixed and turned secondary.

Database scaling

You can scale the existing database clusters using "horizontal" and "vertical" scaling.

Replication modes

The synchronization_mode determines how transactions are replicated between multiple nodes before a transaction is confirmed to the client. IONOS DBaaS supports only the asynchronous (default) replication mode for MariaDB, wherein the first transaction commit is always on the master, followed by replication to the standby node(s).

Asynchronous replication sends a transaction confirmation back to the user immediately after the transaction is written to disk on the primary node without waiting for the standby. Replication takes place in the background. The cluster can lose some committed (not yet replicated) transactions during a failover to a secondary node in an asynchronous mode. The performance penalty of asynchronous replication depends on the workload.

MariaDB uses an asynchronous replication mechanism. The primary node's binary log needs to be enabled to save data and make structural changes in the binary log. For more information, refer to the MariaDB Documentation.

Synchronization mode considerations

Please note that the synchronization mode can impact DBaaS in several ways:

MariaDB supports both automatic and manual backups. In addition, you can also use the self-restore function via the API to restore MariaDB clusters from a backup.

Automatic backups

IONOS, by default, performs automatic backups, which are full backups that run regularly at a specific hour based on the value set in the DBaaS component. Automatic backups are created in either of the following instances:

• During the creation of a cluster.

• Upon upgrading the current version of MariaDB to a higher version.

• When a Point-In-Time-Recovery operation is conducted.

Manual backup

IONOS facilitates the "logical" backup option using mariadb-dump. Alternatively, you can also use the mariadb-dump client to back data to a different location. For more information, refer to the MariaDB Documentation.

Self-Restore MariaDB Clusters from the Backup

IONOS DBaaS offers a self-restore feature to restore MariaDB clusters, which allows an efficient restoration of your clusters from a backup to a previous state or point in time without manual intervention. It reduces downtime and minimizes data loss in case of unforeseen events. You can either use the DCD or the API to self-restore your MariaDB clusters.

The following are some of the features and benefits of self-restore:

• Point-in-Time Recovery: You can restore your MariaDB clusters to a specific point in time. For example, you can roll back the cluster to a state before data corruption, accidental deletions, etc.

• Automated Process: The automated process significantly streamlines and reduces the time and effort required to restore a MariaDB cluster. You can initiate the restore process through the API.

• Data Consistency: It ensures that the restored MariaDB cluster is consistent and matches the data state at the specified point in time. It helps maintain data integrity and coherence across applications interacting with the respective MariaDB cluster.

• User Control: You have complete control over the restoration process, allowing you to select a specific point in time for the restoration process and monitor its progress.

IONOS DBaaS for MariaDB is fully integrated into the Data Center Designer and has a dedicated API. You may also launch it via automation tools like Ansible and Terraform.

MariaDB is a reliable, scalable, and secure Relational Database Management System (RDBMS). IONOS DBaaS assures the configured database is automatically provisioned, thus saving time and ensuring your business runs smoothly without disruption. DBaaS gives you access to the capabilities of the MariaDB database engine, ensuring you can use the same code, applications, and tools you already use in your existing databases with DBaaS.

You can order a cluster of multiple redundant nodes with automatic failover for high availability. For more information, see High Availability and Scaling.

The IONOS DBaaS for MariaDB automatically creates and stores backups of your MariaDB content regularly, which is capable of a point-in-time restore. Backups happen automatically to reduce your workload further and ensure that you can swiftly resume operations in the event of a failure.

It is mandatory to specify a periodic maintenance time window for regular maintenance. During the maintenance time window, you may encounter a short, occasional downtime, typically caused by restarting the MariaDB or switching to another replica.

The illustration shows how MariaDB can be created and managed using IONOS DBaaS.

As shown in the illustration, you can order and manage a MariaDB database cluster using the DCD or the corresponding API. Simultaneously, you can choose the LAN, the VDC, and the IP address on which the MariaDB should be available. The IONOS Cloud DBaaS Backend provisions the MariaDB cluster according to your request. The primary instance of the MariaDB cluster will be available on your LAN within the VDC and on the chosen IP address after provisioning.

Supported MariaDB Versions

IONOS Cloud supports "MariaDB Long-Term Support (LTS) versions" (example: 10.6, 10.11), starting from MariaDB 10.6.

The IONOS Cloud DBaaS takes care of minor version upgrades during maintenance windows, for example, from 10.11.6 to 10.11.7. For more information, see Upgrade and Maintenance.

Locations

DBaaS for MariaDB is offered in all IONOS Cloud locations. You can use DBaaS instances running MariaDB in the IONOS Cloud infrastructure. For more information about the regional API endpoints, see Endpoint.

Security

A MariaDB cluster comes with an x509 certificate for Transport Layer Security (TLS). You can enforce this transport encryption with the client option --ssl-verify-server-cert.

With IONOS Cloud , you can quickly set up and manage the MariaDB database engine. You can use the database engine's features, such as the flexible cloud-based scaling of the database resources, patching the database, creating backups and redundancy, and enhancing security with IONOS DBaaS.

You can initiate MariaDB via the DCD, APIs, or automation tools like Ansible and Terraform.

Product Overview

Quick Links

Developer Tools

Frequently Asked Questions (FAQs)

To get answers to the most commonly encountered questions about MariaDB, see .

Prerequisites

• 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 .

Create a Cluster

To create a MariaDB cluster, follow these steps:

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

2. Go to Menu > Databases > MariaDB.

1. Click Create cluster to create a new MariaDB cluster.

1. Enter the following details in the Create cluster window:

1. Click Save to create the MariaDB cluster.

Define Cluster properties

To define cluster properties, specify the following:

1. Cluster Name: Enter an appropriate name for your MariaDB cluster.

2. 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.

3. 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.

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

2. 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.

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 MariaDB 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.

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 Data Center with the MariaDB Cluster

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

Schedule the MariaDB 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.

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 MariaDB cluster for the respective user.

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

IONOS DBaaS stores the generated logs on the same disk as the database. Log files are rotated according to their size to conserve the disk space. Log messages are subject to a 30-day retention policy and are regularly checked to ensure they do not consume up to 175 MB of disk space.

Logs are generated for the following:

• Connections established during a session creation

• Disconnections when the session terminates

• Lock wait time

• DDL statements

• Statements that run for at least 500 ms

• Statements that result in an error

For more information, refer to the .

Binary logs

MariaDB uses for continuous archiving and replication.

The binary logs record every change to the database. MariaDB deletes older log files automatically with the expire_logs_days in a typical operation mode. It means that binary log files, regular database log files such as audit logs, error logs, and client logs are deleted. For more information, refer to the .

Password hashing

Ensure that the client library is up-to-date and supports the mysql_native_password authentication. For more information, refer to the . The following links on the MariaDB website can help you with:

Connection encryption

Certificates are issued for the DNS name of the cluster which is assigned automatically during creation and will look similar to ma-98tcp98ofe.qa.mariadb.fr-par.ionos.com. It is available via the IONOS API as the dnsName property of the cluster resource.

Here is how to verify the certificate using MariaDB with ssl option:

Quick Links

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:

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

2. Go to Menu > Databases > MariaDB.

View individual Cluster details

To view the details of each cluster in the Details window:

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

2. Go to Menu > Databases > MariaDB.

3. You can navigate to the Details window using either of these options:

• Select the name of the cluster.

• Selecting Details from the OPTIONS column.

1. 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.

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.

Prerequisites

• The backup must belong to the MariaDB cluster to be restored.

• The cluster must be in the AVAILABLE state.

Restore a Cluster

To restore a cluster, follow these steps:

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

2. Go to Menu > Databases > MariaDB.

1. Select a MariaDB cluster from the list by clicking on its name. Alternatively, click Details in the OPTIONS column.

1. • 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.

The request creates a new MariaDB cluster.

Prerequisite

• Only contract administrators, owners, and users with Access and manage DBaaS privilege can create and manage MariaDB clusters. Ensure that you have the necessary privilege.

Request

curl -X 'POST' \
  'https://mariadb.de-txl.ionos.com/clusters' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -d '{
  "properties": {
    "mariadbVersion": "10.6",
    "instances": 2,
    "cores": 4,
    "ram": 2,
    "storageSize": 10,
    "connections": [
      {
        "datacenterId": "5a029f4a-72e5-11ec-90d6-0242ac120003",
        "lanId": "2",
        "cidr": "192.168.1.100/24"
      }
    ],
    "displayName": "MariaDB cluster",
    "maintenanceWindow": {
      "time": "16:30:59",
      "dayOfTheWeek": "Monday"
    },
    "credentials": {
      "username": "db-admin",
      "password": "TopSecret!"
    }
  }
}'

Response

Your values will differ from those in the sample code. It may contain different IDs, timestamps etc.

You may have noticed that the metadata.state is BUSY and that the database is not yet reachable. This is because the cloud will create a completely new cluster and needs to provision new nodes for all the requested replicas. This process runs asynchronously in the background and might take up to 30 minutes.

200 Successful operation

{
  "type": "cluster",
  "id": "498ae72f-411f-11eb-9d07-046c59cc737e",
  "metadata": {
    "createdDate": "2020-12-10T13:37:50+01:00",
    "createdBy": "john.doe@example.com",
    "createdByUserId": "87f9a82e-b28d-49ed-9d04-fba2c0459cd3",
    "lastModifiedDate": "2020-12-11T13:37:50+01:00",
    "lastModifiedBy": "jane.doe@example.com",
    "lastModifiedByUserId": "87f9a82e-b28d-49ed-9d04-fba2c0459cd3",
    "state": "BUSY"
  },
  "properties": {
    "displayName": "MariaDB cluster",
    "mariadbVersion": "10.6",
    "dnsName": "ma-yourcluster.mariadb.region.ionos.com",
    "instances": 2,
    "ram": 2,
    "cores": 4,
    "storageSize": 10,
    "connections": [
      {
        "datacenterId": "5a029f4a-72e5-11ec-90d6-0242ac120003",
        "lanId": "2",
        "cidr": "192.168.1.100/24"
      }
    ],
    "maintenanceWindow": {
      "time": "16:30:59",
      "dayOfTheWeek": "Monday"
    }
  }
}

After creation, remember to validate the status of your MariaDB cluster. For more information, see Verify the Status of a MariaDB Cluster.

Follow the network specifications and resource considerations listed on this page to successfully set up a MariaDB cluster.

Network configuration

To set up a database inside an existing data center, you should have at least one server in a private LAN. You need to choose an IP address, under which the database leader should be made available.

There is currently no IP address management for databases. If you use your subnet, you may use any IP address in that corresponding subnet. You must choose the IP address of the subnet that IONOS assigns you if your servers use DHCP. The IP address of the subnet can be found in your NIC configuration.

Resource considerations

CPU, RAM, storage, and number of database clusters are counted against quotas. For more information, see Resource allocation.

Database performance depends on the storage type. Currently, IONOS supports only SSD Premium storage type, by default.

The binary log files are stored alongside the database. The amount of files can grow and shrink depending on your workload. For a reasonable performance, we recommend that you set the SSD's storage size to at least 100 GB.

Database backups

All database clusters are backed up automatically. For more information, see Automatic backups.

This topic describes connecting to MariaDB from your managed Kubernetes cluster.

Prerequisites

Ensure that the following are available before connecting to the database:

• A datacenter with the following id: xyz-my-datacenter.

• A private LAN with id 3 using the network 10.1.1.0/24.

• A database connected to LAN 3 with the following IP address: 10.1.1.5/24.

• A Kubernetes cluster with the following id: xyz-my-cluster.

• ionosctl

Connect to the database from the cluster

In this example, we use DHCP to assign IP addresses to node pools. Therefore, the database must be in the same subnet as the DHCP server.

To enable connectivity, follow these steps:

1. Connect node pools to the private LAN, which is connected to the database:

ionosctl k8s nodepool create --cluster-id xyz-my-cluster --datacenter-id xyz-my-datacenter --lan-ids 3 --dhcp=true --name=my_nodepool

1. Create a pod to test the connectivity. Schedule the pod exclusively for the node pools connected to the additional LAN if you have several node pools.

# pod.yaml
apiVersion: v1
kind: Pod
metadata:
  name: connectivity-test
  labels:
    role: connectivity-test
spec:
  containers:
  - name: connectivity-test
    image: mysql
    stdin: true
    tty: true
    command:
      - "/bin/bash"

Alternatively, you can also use the following commands:

1. Create the pod: kubectl apply -f pod.yaml

2. Attach the pod and test connectivity:

kubectl attach -it connectivity-test
mysql -u <USERNAME> -p -h <DNS_NAME> --execute \"SHOW DATABASES;\"

The database will be deployed in about five minutes after the creation of your first MariaDB cluster. For more information about creating a MariaDB cluster, see Create a MariaDB Cluster.

You can manually verify whether the create request is successful because the notification mechanism is not yet available. However, you can poll the API to see when the state switches to AVAILABLE. You can use the following command:

while [[ $(curl -sXGET "https://mariadb.de-txl.ionos.com/clusters/${UUID}" -H "Authorization: Bearer ${TOKEN}" | jq -r .metadata.state) != "AVAILABLE" ]]; do
  sleep 5
  clear
  echo -e "Cluster status:\n"
  kg mariadbcluster "${UUID}" -ojsonpath='{.status.conditions}' | yq -P
  echo -e "\ncluster is not available yet, waiting 5 seconds..."
done

Initialize the database and connect it to the cluster

You can connect to your MariaDB cluster soon after its creation. For example, you can connect using the ssh command as follows and the credentials that you set in the POST request:

ssh -i .ignore.id_rsa "root@${CUSTOMER_PUBLIC_IP}"

You can use the following command to set the environment:

DATABASE_IP="CUSTOMER_PUBLIC_IP"
read -p "DNS Name: " DNS_NAME

Alternatively, you can use the following commands to connect to the database:

Manage access

You can create additional users, roles, databases, and other objects via the SQL. These operations are highly dependent on your database architecture.

The PUBLIC role is a special role in which all database users inherit the permissions. This is also important if you want to have a user without write permissions, since by default PUBLIC is only allowed to write to the public schema.

For more information about managing databases, refer to the MariaDB Documentation.

Create Users

The CREATE USER statement can be used to create one or more user accounts in the MariaDB database. Only users with the global CREATE USER privilege or the INSERT privilege for the MySQL database can create users. For more information, refer to the MariaDB Documentation.

CREATE USER user@abc IDENTIFIED BY 'password';
GRANT SELECT ON table.t2 to 'user'@'%';

You can retrieve a MariaDB cluster using its UUID. It is found in the response body when a MariaDB cluster is created or when you retrieve a list of MariaDB clusters using GET.

Request

To query a single cluster, you need the id from your create response.

curl -X 'GET' \
  'https://mariadb.de-txl.ionos.com/clusters/498ae72f-411f-11eb-9d07-046c59cc737e' \
  -H 'accept: application/json'

Response

202 Successful operation

{
  "type": "cluster",
  "id": "498ae72f-411f-11eb-9d07-046c59cc737e",
  "metadata": {
    "createdDate": "2020-12-10T13:37:50+01:00",
    "createdBy": "john.doe@example.com",
    "createdByUserId": "87f9a82e-b28d-49ed-9d04-fba2c0459cd3",
    "lastModifiedDate": "2020-12-11T13:37:50+01:00",
    "lastModifiedBy": "jane.doe@example.com",
    "lastModifiedByUserId": "87f9a82e-b28d-49ed-9d04-fba2c0459cd3",
    "state": "AVAILABLE"
  },
  "properties": {
    "displayName": "MariaDB cluster",
    "mariadbVersion": "10.6",
    "dnsName": "ma-yourcluster.mariadb.region.ionos.com",
    "instances": 2,
    "ram": 2,
    "cores": 4,
    "storageSize": 10,
    "connections": [
      {
        "datacenterId": "5a029f4a-72e5-11ec-90d6-0242ac120003",
        "lanId": "2",
        "cidr": "192.168.1.100/24"
      }
    ],
    "maintenanceWindow": {
      "time": "16:30:59",
      "dayOfTheWeek": "Monday"
    }
  }
}

You can retrieve all backups of a specific MariaDB cluster using its clusterId. Specify a limit to limit the maximum number of elements returned and define pagination using offset.

Request

curl -X 'GET' \
  'https://mariadb.de-txl.ionos.com/clusters/{clusterId}/backups' \
  -H 'accept: application/json'

Response

200 Successful operation

{
  "id": "498ae72f-411f-11eb-9d07-046c59cc737e",
  "items": [
    {
      "id": "498ae72f-411f-11eb-9d07-046c59cc737e",
      "properties": {
        "clusterId": "498ae72f-411f-11eb-9d07-046c59cc737e",
        "earliestRecoveryTargetTime": "2021-10-23T01:21:10Z",
        "size": 2052,
        "baseBackups": [
          {
            "created": "2020-12-10T13:37:50+01:00",
            "size": 543
          }
        ]
      }
    }
  ],
  "offset": 200,
  "limit": 100,
  "total": 200,
  "_links": {
    "prev": "<PREVIOUS-PAGE-URI>",
    "self": "<THIS-PAGE-URI>",
    "next": "<NEXT-PAGE-URI>"
  }
}

You can retrieve a list of MariaDB clusters and also specify the maximum number of elements to be returned by specifying an integer for limit and defining the pagination using offset.

Additionally, you can also use a response filter (filter.name) to list only the MariaDB clusters that contain the specified name.

Request

curl -X 'GET' \
  'https://mariadb.de-txl.ionos.com/clusters?limit=100&offset=200' \
  -H 'accept: application/json'

Response

202 Successful operation

{
  "type": "collection",
  "id": "498ae72f-411f-11eb-9d07-046c59cc737e",
  "items": [
    {
      "type": "cluster",
      "id": "498ae72f-411f-11eb-9d07-046c59cc737e",
      "metadata": {
        "createdDate": "2020-12-10T13:37:50+01:00",
        "createdBy": "john.doe@example.com",
        "createdByUserId": "87f9a82e-b28d-49ed-9d04-fba2c0459cd3",
        "lastModifiedDate": "2020-12-11T13:37:50+01:00",
        "lastModifiedBy": "jane.doe@example.com",
        "lastModifiedByUserId": "87f9a82e-b28d-49ed-9d04-fba2c0459cd3",
        "state": "AVAILABLE"
      },
      "properties": {
        "displayName": "MariaDB cluster",
        "mariadbVersion": "10.6",
        "dnsName": "ma-yourcluster.mariadb.region.ionos.com",
        "instances": 2,
        "ram": 2,
        "cores": 4,
        "storageSize": 10,
        "connections": [
          {
            "datacenterId": "5a029f4a-72e5-11ec-90d6-0242ac120003",
            "lanId": "2",
            "cidr": "192.168.1.100/24"
          }
        ],
        "maintenanceWindow": {
          "time": "16:30:59",
          "dayOfTheWeek": "Monday"
        }
      }
    }
  ],
  "offset": 200,
  "limit": 100,
  "_links": {
    "prev": "<PREVIOUS-PAGE-URI>",
    "self": "<THIS-PAGE-URI>",
    "next": "<NEXT-PAGE-URI>"
  }
}

You can retrieve a list of backups for all MariaDB clusters in your contract. You can specify an integer for limit to return the maximum number of elements and define the pagination using offset.

Request

curl -X 'GET' \
  'https://mariadb.de-txl.ionos.com/backups?limit=100&offset=200' \
  -H 'accept: application/json'

Response

200 Successful operation

{
  "id": "498ae72f-411f-11eb-9d07-046c59cc737e",
  "items": [
    {
      "id": "498ae72f-411f-11eb-9d07-046c59cc737e",
      "properties": {
        "clusterId": "498ae72f-411f-11eb-9d07-046c59cc737e",
        "earliestRecoveryTargetTime": "2021-10-23T01:21:10Z",
        "size": 2052,
        "baseBackups": [
          {
            "created": "2020-12-10T13:37:50+01:00",
            "size": 543
          }
        ]
      }
    }
  ],
  "offset": 200,
  "limit": 100,
  "total": 200,
  "_links": {
    "prev": "<PREVIOUS-PAGE-URI>",
    "self": "<THIS-PAGE-URI>",
    "next": "<NEXT-PAGE-URI>"
  }
}

You can delete a MariaDB cluster using its UUID. The response body will provide details about the cluster's UUID once a MariaDB cluster has been created or when obtaining a list of clusters.

Request

curl -X 'DELETE' \
  'https://mariadb.de-txl.ionos.com/clusters/498ae72f-411f-11eb-9d07-046c59cc737e' \
  -H 'accept: application/json'

Response

202 Successful operation

  {
  "type": "cluster",
  "id": "498ae72f-411f-11eb-9d07-046c59cc737e",
  "metadata": {
    "createdDate": "2020-12-10T13:37:50+01:00",
    "createdBy": "john.doe@example.com",
    "createdByUserId": "87f9a82e-b28d-49ed-9d04-fba2c0459cd3",
    "lastModifiedDate": "2020-12-11T13:37:50+01:00",
    "lastModifiedBy": "jane.doe@example.com",
    "lastModifiedByUserId": "87f9a82e-b28d-49ed-9d04-fba2c0459cd3",
    "state": "DESTROYING"
  },
  "properties": {
    "displayName": "MariaDB cluster",
    "mariadbVersion": "10.6",
    "dnsName": "ma-yourcluster.mariadb.region.ionos.com",
    "instances": 2,
    "ram": 2,
    "cores": 4,
    "storageSize": 10,
    "connections": [
      {
        "datacenterId": "5a029f4a-72e5-11ec-90d6-0242ac120003",
        "lanId": "2",
        "cidr": "192.168.1.100/24"
      }
    ],
    "maintenanceWindow": {
      "time": "16:30:59",
      "dayOfTheWeek": "Monday"
    }
  }
}

You can retrieve a specific backup of a MariaDB cluster using its ID. You can find the ID when you retrieve the list of all MariaDB cluster backups. You can specify an integer for limit to return the maximum number of elements and define the pagination using offset.

Request

curl -X 'GET' \
  'https://mariadb.de-txl.ionos.com/backups/{backupId}' \
  -H 'accept: application/json'

Response

200 Successful operation

{
  "id": "498ae72f-411f-11eb-9d07-046c59cc737e",
  "properties": {
    "clusterId": "498ae72f-411f-11eb-9d07-046c59cc737e",
    "earliestRecoveryTargetTime": "2021-10-23T01:21:10Z",
    "size": 2052,
    "baseBackups": [
      {
        "created": "2020-12-10T13:37:50+01:00",
        "size": 543
      }
    ]
  }
}

Quick Links

Endpoint

A regional endpoint is necessary to interact with the MariaDB REST API endpoints. For more information, see the API specification file.

IONOS supports the following endpoints for various locations:

• Berlin, Germany: https://mariadb.de-txl.ionos.com/clusters.

• Frankfurt, Germany: https://mariadb.de-fra.ionos.com/clusters

• Logroño, Spain: https://mariadb.es-vit.ionos.com/clusters

• London, Great Britain: https://mariadb.gb-lhr.ionos.com/clusters

• Newark, United States: https://mariadb.us-ewr.ionos.com/clusters

• Las Vegas, United States: https://mariadb.us-las.ionos.com/clusters

• Lenexa, United States: https://mariadb.us-mci.ionos.com/clusters

• Paris, France: https://mariadb.fr-par.ionos.com/clusters

Request parameter headers

To make authenticated requests to the API, the following fields are mandatory in the request headers:

Examples

The documentation contains curl examples, as the tool is available on Windows 10, Linux, and macOS. You can also refer to the following blog posts on the IONOS website that describe how to execute curl in Linux and Windows systems if you encounter any problems.

To delete a MariaDB cluster, follow these steps:

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

2. Go to Menu > Databases > MariaDB. A list of all MariaDB clusters is displayed.

3. 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.

1. Select Delete in the dialog box to confirm deletion.

The request restores a MariaDB cluster from a backup.

Prerequisites

The backup must:

• belong to the MariaDB cluster to be restored.

• be in the AVAILABLE state.

Request

Response

You will receive a 202 Successful operation when the request is complete.

A user's identity in MariaDB is determined by their username and host combination. If you have numerous users from different source hosts, you will need to reset the password for each user. To reset your database password, connect to the MariaDB cluster and run either of the following commands using the user whose password should be changed:

• SET PASSWORD = PASSWORD('<new password>');

• SET PASSWORD = '<passwordhash>';

Tables can become bloated during regular operation, meaning they consume more disk space than is required. The causes can be deletions or updating large amounts of data, resulting in the following:

• The disk of the MariaDB cluster runs out of space.

• MariaDB tables might be bloated.

Solution

To overcome the fragmentation of the tables, they have to be rewritten. This causes data to be stored in a physically optimal way. MariaDB stores the information about bloat in the data_free column of information_schema.tables.

1. Diagnose the problem by finding bloated tables. You can use the following query:

When you use InnoDB Full-Text Search, it creates additional files, consuming added space on the filesystem, but does not show up in the information_schema.tables. You can determine the size by querying information_schema.innodb_sys_tablespaces.

1. Reclaim free space. You can follow the steps for InnoDB and MyISAM accordingly:

• InnoDB To rewrite a InnoDB table, execute ALTER TABLE <table_name> ENGINE INNODB or ALTER TABLE <table_name> FORCE.

For easy generation of all ALTER TABLE statements, we recommend using the following SQL statement:

SELECT CONCAT('ALTER TABLE `', TABLE_SCHEMA, '.', TABLE_NAME, '` ENGINE InnoDB;') FROM information_schema.tables WHERE `TABLE_TYPE` = 'BASE TABLE' AND `ENGINE` = 'InnoDB'

• MyISAM You can use the OPTIMIZE TABLE command to rewrite a MyISAM table and reclaim all disk space from data_free. Example: OPTIMIZE TABLE <table_name>;

While the OPTIMIZE TABLE command is designed for the MyISAM storage engine to reorganize and optimize data files, it also supports InnoDB for compatibility reasons. Internally, when the command is executed but notices that the table uses InnoDB and not MyISAM, the command executes ALTER TABLE <table_name> FORCE instead of manually optimizing the table.

The request creates a new MariaDB cluster, which involves restoring a backup of an existing MariaDB cluster and configuring it to function as a new cluster. Ensure you have a backup of your MariaDB cluster containing all the necessary data and configuration files for appropriate functioning.

Prerequisite

• Only contract administrators, owners, and users with Access and manage DBaaS privilege can create and manage MariaDB clusters. Ensure that you have the necessary privilege.

Request

Response

Your values will differ from those in the sample code. It may contain different IDs, timestamps etc.

The created cluster is returned with metadata.state set to BUSY, which indicates that the cluster is not yet reachable. This is because the cloud will create a completely new cluster and needs to provision new nodes for all the requested replicas.

200 Successful operation

Following are a few limitations that you can encounter while using MariaDB.

• The total upper limit for the Number of CPUs depends on your quota. A single instance cannot exceed 16 cores. For more information, see Select the required number of resources.

• The total upper limit for RAM Size depends on your quota. A single instance cannot exceed 32 GB. For more information, see Select the required number of resources.

• The upper limit for Storage Size is 2 TB. For more information, see Select the required number of resources.

• Storing cluster backups in an IONOS S3 Object Storage is limited to the last seven days.

• The following IP ranges cannot be used with MariaDB services:

  • 10.208.0.0/12

  • 10.233.0.0/18

  • 192.168.230.0/24

  • 10.233.64.0/18

IONOS DBaaS MariaDB is a flexible database engine that is a perfect fit for facilitating enterprise-level analytics and solutions to drive online web applications for both individual use and business purposes. Due to its open-source nature, improved performance and MySQL compatibility, it is liked by developers and companies alike.

Scenario 1: Data warehousing and analytics

Precondition

The price and overhead of managing voluminous data for businesses and individuals rise as the data increases.

Solution

MariaDB can be recommended for various instances where extensive data is stored and analyzed. Its high-availability environment ensures minimized downtime and continuous availability of data. Here are some scenarios where it can be implemented:

• Web Applications: MariaDB is highly scalable, provides fast and reliable data retrieval, and can support sudden spikes in traffic. Hence, it can be used for web applications as a backend database, because it can handle the data storage needs of a dynamic website or web application.

• Healthcare Systems: It is ideally suited for the secure and scalable storage and management of healthcare information, medical records, and patient data.

• E-commerce Organizations: With its ability to manage user accounts, transactional data, and product catalogs, it is an ideal match for e-commerce platforms. Its ACID compliance ensures integrity and data consistency.

Scenario 2: Corrupted data cluster

Precondition

Restoring data to its previous state manually can become a tedious and time-consuming task.

Solution

The self-restore feature for MariaDB in IONOS DBaaS can be beneficial in various use cases where data recovery or restoration to a specific point in time is necessary. You can restore a MariaDB cluster from the backup via the DCD or using the APIs. Here are some common use cases:

• Accidental Data Deletion: In situations where critical data is accidentally deleted from the MariaDB cluster, the self-restore feature enables you to roll back the cluster to a point before the deletion occurs, helping to recover lost data effectively.

• Data Corruption: If the MariaDB cluster experiences data corruption due to software issues or hardware failures, the self-restore feature allows you to restore the cluster to a consistent state before the corruption, ensuring data integrity and minimizing the impact of the corruption.

• Human Errors: Mistakes made during operations such as incorrect updates or changes can be resolved by using the self-restore feature to revert the cluster to a state where the errors did not exist, preventing potential data inconsistencies.

• Security Incidents: In the event of a security breach or unauthorized access that compromises the MariaDB cluster, the self-restore feature can be used to restore the cluster to a secure state before the security incident occurred, protecting sensitive data.

• Testing and Development: The self-restore feature can also be useful for testing and development purposes. Developers can create snapshots of the database at different points in time and use the self-restore feature to easily revert to specific states for testing new features or debugging code.

• Compliance and Auditing: For regulatory compliance requirements or auditing purposes, the self-restore feature allows users to demonstrate the ability to restore data to a specific point in time, ensuring data retention policies and compliance standards are met.

Will DBaaS be offered on Cloud Cubes?

DBaaS is only available on Virtual Servers at this time. There may be support for Cloud Cubes in the future.

What happens when the connection reaches its limits?

Depending on the library you are using, you may see an error message similar to the following:

Too many connections

How do we prevent reaching the connection limit?

As each user has 250 connections and max_connections is set to 500, it is less probable that a user will use up all of their connections with MariaDB.

Can I scale the deployment to increase its connection limit?

Unfortunately, it is not allowed to scale the deployment for increasing connection limits.

What are the supported backup methods?

IONOS provides an automated backup within the cloud infrastructure. You can use the mariadb-dump client to back up data to a different location. For more information, refer to the MariaDB Documentation.

What are the main considerations for latency and performance?

Achieving high availability and minimal latency are the main goals of the IONOS Cloud. We recommend that you host your application servers closer to your database and in a geographic location appropriate for your user base to reduce the adverse effects of network latency on your application. For more information, refer to the MariaDB Documentation.

Get help troubleshooting common issues with MariaDB.