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 :

Self Service

Customer can perform action autonomously.

On Request

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

Feature
Self service
On request
Comments

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.

Default settings

Some default MariaDB parameters configured by cegedim.cloud :

Setting
Value
Description

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

Slow queries are not logged by default

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

Last updated