# Managed MariaDB on Hetzner and UpCloud

> Managed MariaDB from a German provider: GTID replication, failover, mandatory TLS and scheduled backups on Hetzner or UpCloud.

BasePilot provisions and operates MariaDB clusters on the European cloud providers Hetzner and UpCloud, in your own cloud account or on your own servers, from Germany. Operated from Germany. Billed per node and hour. No minimum term.

## MariaDB at a glance

- Versions: 11.4, 10.11
- Default version: MariaDB 11.4 LTS
- Port: 3306
- Nodes per cluster: 1 to 3
- Replication: Replication with global transaction IDs, asynchronous
- Backups: Scheduled mariadb-dump backups of all databases and user accounts
- Point-in-time restore: No
- Major version upgrades: No
- Availability: Generally available
- Connection string: `mysql://app@shop-x7k2f.mariadb.basepilot.de:3306/defaultdb`

## What managed MariaDB includes

- **Replication with global transaction IDs:** Replicas load a consistent dump of the primary and then follow it using MariaDB's global transaction IDs. In a failover the most advanced replica becomes the new primary and the others are re-pointed.
- **Encrypted connections only:** TLS is required for every TCP connection. Clients verify the server with the cluster's own certificate authority or with a certificate you supply.
- **Configuration matched to the size:** Buffer pool and connection limit follow the memory of the node, so a larger size is used without manual tuning.
- **Accounts per database:** Create SQL accounts that may read, read and write, or administer, across all databases or only the ones you select.
- **Dumps with accounts included:** Scheduled backups cover every database with its routines, events and triggers as well as the user accounts, and can be restored into a new cluster.
- **Studio for SQL:** Browse tables and run statements in the browser, read-only by default.

## Built and operated in Europe

BasePilot is a German service on European infrastructure. You decide in which data centre each cluster runs.

- **Operator in Germany:** BasePilot is developed and operated in Erfurt, Germany. Contracts are governed by German law.
- **European cloud providers:** The servers come from Hetzner (Germany) and UpCloud (Finland). You choose the data centre location for every cluster yourself, for example in Germany or Finland.
- **Data processing under the GDPR:** We process the data in your databases solely on your behalf and on your instructions. A data processing agreement under Art. 28 GDPR is available on request.
- **Analytics only with consent:** This website measures visits only if you agree; without your consent it sets no cookies. The console uses only technically necessary cookies.

## Questions about managed MariaDB

### Which MariaDB versions does BasePilot offer?

MariaDB 11.4, 10.11. New clusters use MariaDB 11.4 LTS by default.

### MySQL or MariaDB: which should I choose?

BasePilot operates both in the same way, with the same replication, failover, TLS, user management and backups. Choose the one your application is developed and tested against.

### Does managed MariaDB support point-in-time restore?

Not at present. A restore returns to the moment of a scheduled dump and always creates a new cluster. Point-in-time restore is available for PostgreSQL and libSQL.

## Links

- [BasePilot](https://basepilot.de/en.md): Managed PostgreSQL, MySQL, MariaDB, MongoDB, Valkey, libSQL and NATS from a German provider: on Hetzner, UpCloud or your own servers, billed by the hour.
- [Managed PostgreSQL](https://basepilot.de/en/managed-postgresql.md)
- [Managed MySQL](https://basepilot.de/en/managed-mysql.md)
- [Managed MongoDB](https://basepilot.de/en/managed-mongodb.md)
- [Managed Valkey](https://basepilot.de/en/managed-valkey.md)
- [Managed libSQL](https://basepilot.de/en/managed-libsql.md)
- [Managed NATS](https://basepilot.de/en/managed-nats.md)
- [Create an account](https://console.basepilot.de/sign-up)
- [Deutsch](https://basepilot.de/de/managed-mariadb.md)