Create a MariaDB service
MariaDB is the open source relational database loved by developers all over the world. Created by MySQL’s original developers, MariaDB is compatible with MySQL and guaranteed to stay open source forever.
Zerops provides the MariaDB Community Server edition as a managed database service.
Create MariaDB using Zerops GUI
First, set up a project in Zerops GUI. Then go to the project dashboard page and choose Add new service in the left menu in the Services block. Then add a new MariaDB service:
// TODO screenshot (add a new service page)
Parameter | Description | Limitations |
---|---|---|
hostname | A unique service identifier like mariadb ,sql , db etc. | - duplicate services with the same name in the same project are forbidden - maximum 25 characters - must contain only lowercase ASCII letters (a-z) or numbers (0-9) |
The hostname is fixed after the service is created. It can't be changed later.
Choose MariaDB service mode
Zerops provides MariaDB service in two modes: Highly available and Single container.
Highly available
Creates a MariaDB cluster with 3 database containers and 2 free database proxies. This mode is suited for production.
Zerops always keeps the 3 database containers on different physical machines. All your data is stored redundantly in 3 identical copies. In case of a failure of a container or the underlying physical machine, Zerops automatically disconnects the failed container from the cluster, creates a new container and syncs all data from the remaining 2 copies. Finally the broken container is automatically deleted.
Learn more about specific behaviour and technical limitations of the MariaDB cluster.
Single container
A MariaDB database installed in a single container is created. Useful for non-essential data or dev environments.
Your data is stored only in a single container. If the container or the underlying physical machine fails, your data since the last backup are lost. Zerops doesn't provide any automatic repairs of single node MariaDB services.
The MariaDB service mode is fixed after the service is created. It can't be changed later.
Choose MariaDB version
Currently only MariaDB 10.4 version is available.
Set auto scaling configuration
Zerops scales the MariaDB services automatically by raising or lowering the hardware resources of each database container.
CPU Mode
Shared Your application gets a full physical CPU core, but it is shared with up to 10 other applications. In this mode the power your application gets is depended on other applications running on the same CPU core. At best case scenario your application gets 10/10 of CPU core power and 1/10 at worst case scenario.
Dedicated The CPU core is dedicated to your application.
See the pricing for the difference between CPU modes.
Choose the CPU mode when starting a new service or change it later. The CPU mode doesn't change automatically.
Vertical auto scaling
Vertical auto scaling has following default configuration:
Minimum resource | Maximum resource | |
---|---|---|
CPU cores | 1 | 5 |
RAM | 0.5 GB | 32 GB |
Disk | 1 GB | 100 GB |
For most cases, the default parameters will work without issues. If you need to limit the cost of the MariaDB service, lower the maximal resources. Zerops will never scale above the selected maximums.
When you are experiencing problems with insufficient MariaDB performance or capacity, increase the minimal resources. Zerops will never scale below the selected minimums.
Learn more about how to fine tune the auto scaling to fit your application needs.
You can change the auto scaling parameters later.
Learn more about MariaDB auto scaling.
Create MariaDB using zCLI
zCLI is the Zerops command-line tool. To create a new MariaDB service via the command-line, follow these steps:
- Install & setup zCLI
- Create a project description file
- Create a project and a MariaDB service
Create a project description file
Zerops uses a yaml format file to describe the project infrastructure.
Basic example
Create a directory my-project
. Create a description.yml
file inside the directory with the following content:
The yaml file describes your future project infrastructure. The project will contain one MariaDB 10.4 service in the single container mode with default auto scaling configuration. Hostname will be set to mariadb1
.
Full example
Create a directory my-project
. Create a description.yml
file inside the directory with the following content:
# basic project data
project:
# project name
name: my-project
# optional: project description
description: A project with a MariaDB database
# optional: project tags
tags:
- DEMO
- ZEROPS
# array of project services
services:
- # first service hostname
hostname: mariadb1
# service type and version number in mariadb@{version} format
type: mariadb@10.4
# mode of operation "HA"/"NON_HA"
mode: HA
# optional: vertical auto scaling customization
verticalAutoscaling:
cpuMode: DEDICATED
minCpu: 2
maxCpu: 5
minRam: 2
maxRam: 24
minDisk: 6
maxDisk: 50
startCpuCoreCount: 3
minFreeRamGB: 0.5
minFreeRamPercent: 20
- # second service hostname
hostname: mariadb2
# service type and version number in mariadb@{version} format
type: mariadb@10.4
# mode of operation "HA"/"non_HA"
mode: NON_HA
The yaml file describes your future project infrastructure. The project will contain two MariaDB 10.4 services.
The hostname of the first service will be set to mariadb1
. The high availability mode will be chosen and the custom auto scaling configuration will be set.
The hostname of the second service will be set to mariadb2
. The single container mode will be chosen and the default auto scaling configuration will be set.
Description of description.yml parameters
The project:
section is required. Only one project can be defined.
Parameter | Description | Limitations |
---|---|---|
name | The name of the new project. Duplicates are allowed. | |
description | Optional. Description of the new project. | Maximum 255 characters. |
tags | Optional. One or more string tags. Tags do not have a functional meaning, they only provide better orientation in projects. |
At least one service in services:
section is required. You can create a project with multiple services. The example above contains only MariaDB services but you can create a description.yml
with [different types] of services.
Parameter | Description |
---|---|
hostname | The unique service identifier. The hostname of the new database will be set to the
Limitations:
|
type | Specifies the service type Set type:
Limitations: Currently only MariaDB 10.4 is available. |
mode | Defines the operation mode of MariaDB service. HA Zerops will create a MariaDB cluster with 3 database containers and 2 free database proxies. This mode is suited for production. Zerops always keep the 3 database containers on different physical machines. All your data is stored redundantly in 3 copies. In case of a failure of a container or the underlying physical machine, Zerops automatically disconnects the failed container from the cluster, creates a new container and syncs all data from the remaining 2 copies. Finally the broken container is automatically deleted. Limitations: Learn more about specific behaviour and technical limitations of the MariaDB cluster. NON_HA Zerops will create a MariaDB database installed in a single container. Useful for non-essential data or dev environments. Your data is stored only in a single container. If the container or the underlying physical machine fails, your data since the last backup are lost. Zerops doesn't provide any automatic repairs of single node MariaDB services. |
verticalAutoscaling | Optional. Defines custom vertical auto scaling parameters . |
- cpuMode | Optional. Accepts |
- minCpu/maxCpu | Optional. Set the minCpu or maxCpu in CPU cores (integer). |
- minRam/maxRam | Optional. Set the minRam or maxRam in GB (float). |
- minDisk/maxDisk | Optional. Set the minDisk or maxDisk in GB (float). |
The MariaDB service hostname and mode are fixed after the service is created. They can't be changed later.
Create a project based on the description.yml
When you have your description.yml
ready, use the zcli project project-import
command to create a new project and the service infrastructure.
Usage:
zcli project project-import importYamlPath [flags]
Flags:
-h, --help the project import command.
--orgId string If you have access to more than one organization, you must specify the org ID for which the
project is to be created.
--workingDie string Sets a custom working directory. Default working directory is the current directory. (default "./")
Zerops will create a project and one or more services based on the description.yml
content.
Maximum size of the description.yml
file is 100 kB.
You don't specify the project name in the zcli project project-import
command, because the project name is defined in the description.yml
.
If you have access to more than one client, you must specify the client ID for which the project is to be created. The clientID
is located in the Zerops GUI under the client name on the project dashboard page.
Add MariaDB service to an existing project
Example
Create a directory my-project
if it doesn't exist. Create an import.yml
file inside the my-project
directory with following content:
The yaml file describes the list of one or more services that you want to add to your existing project. In the example above, one MariaDB 10.4 service in the single container mode with default auto scaling configuration will be added to your project. Hostname of the new service will be set to mariadb1
.
The content of the services:
section of import.yml
is identical to the project description file. The import.yml
never contains the project:
section because the project already exists.
When you have your import.yml
ready, use the zcli project service-import
command to add one or more services to your existing Zerops project.
zCLI commands are interactive, when you press enter after zcli project service-import importYamlPath
, you will be given a list of your projects to choose from.
Maximum size of the import.yml
file is 100 kB.