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 :

Understanding MariaDB Architecture | Server | MariaDB Documentationmariadb.com

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!

Global Transaction ID | Server | MariaDB Documentationmariadb.com

Standard Replication with GTID

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.

MyISAM tables are not compatible with MariaDB Galera clusters because this storage engine does not support transactions and row-level locking, which are essential for Galera's synchronous multi-master replication. Therefore, it is necessary to convert them to InnoDB format before migrating to the cluster.

What is MariaDB Galera Cluster? | Galera Cluster | MariaDB Documentationmariadb.com

MariaDB Galera cluster

Supported versions

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

https://mariadb.com/kb/en/release-notesmariadb.com

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

MariaDB Documentationmariadb.com

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