All pages
Powered by GitBook
1 of 3

Loading...

Loading...

Loading...

MariaDB - Features

Description

MariaDB Community Edition is available in two self-service topologies:

  • A standalone instance (with a GTID replica on request)

  • A Galera cluster based on 3 active/active instances

For more information on MariaDB architecture :

MariaDB instances are accessible on port 3306 by default.

Regions

MariaDB is available in the following cegedim.cloud data centers:

  • EB4 (Boulogne-Billancourt, France)

  • ET1 (LabΓ¨ge, France)

In some cases, when a third node is deployed (Galera cluster), nearby secondary data centers may also be used to ensure maximum resilience:

  • EB5 (Magny-les-Hameaux, France)

  • ET2 (Balma, France)

Resources

The MariaDB Platform as a Service is hosted on the Linux Debian 10 distribution.

Minimum system requirements are 2 CPUs and 4GB RAM.

Storage can be configured during provisioning and subsequently increased on request.

Topologies

Standalone instance

This is a single instance deployed in a single data center.

Active/passive replication

Two MariaDB instances are deployed in the same data center: the main node with a read-only replica.

Only deployed on request!

Galera cluster

A MariaDB Galera cluster is a virtually synchronous multi-primary cluster for MariaDB. A cluster based on 3 active/active instances can be deployed in any cegedim.cloud data center.

Supported versions

The supported version is the latest LTS (long term support) currently available. For more information, please consult MariaDB versions.

Restrictions

This section is to list which feature / capabilities are available to customer, and how to request / perform them :

Feature
Self service
On request
Comments

Default settings

Some default MariaDB parameters configured by cegedim.cloud :

Setting
Value
Description

Backup

Backup policy for MariaDB is configured like so :

  • Full backup every weekend (online)

  • Differential backup every day (online)

  • Binlog backup every two hours

Default backup retention for the full backups and dependent backups is two weeks.

Security

Authentication

MariaDB's authentication is internal user based.

Authorizations

An administration user is provided to the customer when the provisioning is over.

The password of this user is not stored nor saved by cegedim.cloud. Please be sure to save it in your own vault.

Monitoring

As part of our Managed Databases offer, MariaDB is specifically monitored on top of the underlying system to ensure service uptime and performances.

The following key MariaDB indicators are monitored and tracked :

  • Number of aborted client connections

  • Number of failed server connection attempts

  • Number of refused connections due to internal server errors

  • Maximum number of simultaneous connections opened

Self Service

Customer can perform action autonomously.

On Request

Customer can request for the action to be done to cegedim.cloud support team.

SSH access

SSH access is disabled and reserved to cegedim.cloud administrators.

Change configuration file

On request via ticket. Review by the cegedim.cloud team.

transaction_isolation

READ-COMMITTED

Type of transaction

max_connections

1000

Max allowed connections to the instance

innodb_buffer_pool_size

50% of RAM

Innodb buffer memory allocated to the instance

slow queries

disabled

Standard Replication with GTID
MariaDB Galera clusterMariaDB Galera cluster
MariaDB Galera cluster

Slow queries are not logged by default

MariaDB - Get started

Request a read-only MariaDB replica

To request the addition of a MariaDB read-only replica, you need to create a request ticket via ITCare.

In the Support section of the left-hand side menu, click on the Make a request button. In the Database category, then MariaDB, select and fill in the form: Setting up passive MariaDB replication.

A support ticket will be created upon submission.

Please allow up to 10 working days for your request to be processed.

MariaDB

Managed MariaDB

Description

MariaDB is an open-source database management system created by the original developers of MySQL. MariaDB uses tables to store data in an organized way, and it is possible to interact with the database using SQL queries.

It supports concepts such as primary keys, indexes and relationships between tables. MariaDB is widely used for data storage and management in a variety of applications, from websites to enterprise systems. It is a popular choice due to its reliability, performance and open-source nature.

Platform as a Service

MariaDB is deployed on-premise in cegedim.cloud's data centers. The long term support (LTS) can be deployed in self-service using ITCare

The same level of service as the Compute offer is guaranteed : deployment of instances, maintenance in operational condition, flexibility, security and monitoring are thus ensured by our experts.

Two topologies are available in self-service :

  • Standalone (replica can be added on request)

  • Galera cluster (3 nodes)

Galera cluster is production ready with at least 3 nodes spread over all Availability Zones of a target Area.

Sizing can be configured according to your needs.

Standalone
Galera

For more information, please visit .

Billing

Billing is processed monthly and based on the number of instances plus supplementary costs for storage, backup, 24x7 monitoring.

Cost estimation for a MariaDB instance is available via your Service Delivery Manager.

Monitoring

βœ… Option

βœ… Option

24x7 Monitoring

βœ… Option

βœ… Option

Backup

βœ… Option

βœ… Option

Data replication (DRP)

βœ… Option

βœ… Option

Availability

99.8%

99.9%

Multi-AZ deployment

❌

βœ…

Self-service

βœ…

βœ…

Instances

1

3

CPU (per node)

2 - 16 vCPU

2 - 16 vCPU

RAM (per node)

4 - 384 GB

4 - 384 GB

Supported version(s)

10.6

10.6

MariaDB - Features
Understanding MariaDB Architecture | Server | MariaDB Documentationmariadb.com
Logo
https://mariadb.com/kb/en/release-notesmariadb.com
Global Transaction ID | Server | MariaDB Documentationmariadb.com
Logo
What is MariaDB Galera Cluster? | Galera Cluster | MariaDB Documentationmariadb.com
Logo
MariaDB FoundationMariaDB.org
MariaDB Documentationmariadb.com
Logo
Logo