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
