Working with MariaDB?

MariaDB stuck on an old release? We bring it current.

Most MariaDB servers that reach us were installed as the default database by some other piece of software and then left alone for years. We work out exactly which version is running, what it is incompatible with, and what it will take to bring it forward without losing a byte.

  • Since 2015Fixing technology
  • FreeEstimates
  • US teamReal engineers

mariadb.err

still failing

What it is

MariaDB at a glance

MariaDB is an open-source fork of MySQL that was started in 2009 by Monty Widenius, the original author of MySQL, after Oracle acquired Sun (and MySQL with it). It is developed today by the MariaDB Foundation and the MariaDB Corporation, and it is the default MySQL replacement on many Linux distributions including Debian, Red Hat and Fedora, as well as most cPanel hosting installs.

Beyond being a drop-in for MySQL, MariaDB adds its own storage engines such as Aria and ColumnStore, built-in Galera multi-master clustering, and various extensions to SQL. The 10.x branches are the long-term stable line that most production deployments still run, while MariaDB 11.x is the current release series.

Type
Relational database, MySQL fork
First released
2009
License
GPL v2 for the server
Maintained by
MariaDB Foundation and MariaDB Corporation
Typically used for
LAMP stack sites, WordPress, Drupal, cPanel hosting, cloud-managed databases where MySQL compatibility matters

The honest version

MariaDB pros and cons

No technology is all upside. This is where MariaDB earns its place and where it tends to cause trouble.

Where MariaDB is strong

  • Drop-in for MySQL in most casesFor a typical PHP application using everyday SQL, you can point it at MariaDB and it simply works. The wire protocol and most client libraries are shared.
  • Free under the GPL, with no Oracle contractThe server is distributed under GPL v2 with no commercial tier required, and no vendor sitting between you and the code you depend on.
  • Extra storage engines in the boxAria is the crash-safe replacement for MyISAM, and ColumnStore handles analytical workloads, alongside the usual InnoDB for transactions.
  • Galera multi-master clustering built inSynchronous replication across three or more nodes ships with the server, rather than needing a separate product to bolt on top.
  • Features ship faster on some frontsThings like window functions, sequences and system-versioned tables arrived here before the Oracle-led MySQL releases picked them up.
  • Available on every major cloudManaged MariaDB offerings run on AWS RDS, Azure Database for MariaDB (where still offered), GCP and most smaller providers, so you are not locked to one vendor.

Where MariaDB bites

  • The fork keeps drifting from MySQLEvery year the gap widens: JSON_TABLE, common table expression behaviour, authentication plugins and CHECK constraint handling now differ in ways that bite real applications.
  • Tooling that assumes MySQL misbehavesORMs, backup utilities and GUI clients written against a recent MySQL sometimes report the wrong version, produce incompatible dumps, or quietly skip features.
  • Galera demands disciplineMulti-master looks easy on a slide, but one long transaction or a schema change done the wrong way can desync a node and take out write traffic.
  • Major upgrades are a project of their ownMoving between 10.x releases means running mariadb-upgrade, re-testing applications, and handling table format changes that only show up under load.
  • End-of-life versions are still everywhereMariaDB 10.3, 10.4 and 10.5 are past or near their support end dates, yet they are still running under cPanel installs and old virtual machines across the internet.
  • ColumnStore support shiftsThe columnar engine has changed hands and packaging several times, and the path for existing ColumnStore data has to be checked against the release you are heading to.

Sound familiar?

Common MariaDB problems we fix

The MariaDB problems that bring people to us, and what you have once each one is fixed.

version 10.3.39 · EOL

The server is on a version nobody supports

A MariaDB 10.3 or 10.4 install that has been running since it was installed by cPanel or a hosting template, with no security fixes arriving any more.

Upgraded to a current release

mysqldump output rejected by MySQL 8

We can't move the data back to MySQL

Dumps produced by a recent MariaDB include syntax and options that MySQL refuses to import, and the application now depends on behaviour that differs between them.

A clean, portable export

WSREP: node desynced

A Galera node keeps dropping out

One cluster member is falling behind, usually because of a long-running query, a schema change applied the wrong way, or network jitter between availability zones.

Cluster stable under write load

Seconds_Behind_Master: 14821

Replication keeps falling behind

A single-threaded replica that cannot keep up with a busy primary, or a workload full of large transactions that serialise on the replica.

Replica keeping up in real time

slow log: 1200 queries > 2s

Queries that used to be quick now crawl

Statistics that have gone stale after bulk loads, indexes that no longer match how the app reads, or buffer pool sized for a much smaller database.

Measured, indexed, tuned

last verified restore: never

There is no tested backup

Nightly mysqldump files that nobody has restored, or Mariabackup output sitting on the same server it would need to rescue.

Off-server backups with tested restores

handover from previous team

We inherited MariaDB from someone else

No documentation, root passwords in a text file, and a mix of application accounts with privileges nobody can explain.

Access and inventory back in your hands

What we do

MariaDB help, from upgrade to upkeep

Call us for one stuck upgrade, or hand us the whole fleet.

Upgrades
Moving from EOL 10.x releases to a supported version, rehearsed against a copy of your data before touching production.
MySQL compatibility
Working out whether an application will survive a jump between MariaDB and MySQL, and fixing the SQL that will not.
Galera clustering
Design, provisioning and recovery of multi-master clusters, including the schema change procedures that keep them healthy.
Performance
Buffer pool, query cache, slow query review and index work, with before-and-after numbers rather than guesses.
Backup and recovery
Mariabackup, logical dumps, point-in-time recovery and restores that have been run end to end on real hardware.
Managed Tech
Server patches tested on a staging copy, replication lag watched, buffer-pool and query-cache tuning reviewed each quarter, and someone on the phone when a cluster node drops.

How it works

From first message to fixed

  1. Look Free estimate

    Tell us what's going wrong. We look at it, then tell you plainly what's wrong and what it will cost.

  2. Fix

    We fix the cause, not the symptom. If something is down, getting it back up comes first.

  3. Harden

    Backups, monitoring, updates and access, so the same problem can't quietly come back.

  4. Hand back or stay on

    You get a plain-language write-up. Or we stay on for hosting, upkeep and new work.

Often found together

Running MariaDB alongside something else?

We work on the whole stack, so the problem can be wherever it actually is.

Questions

MariaDB questions

Something else? Call+1 737 727 7327

Should we move from MySQL to MariaDB (or back)?

It depends on which features the application uses and which release of each you are comparing. For a basic LAMP site either works; for anything using JSON functions, CTEs, authentication plugins or specific replication features, we test the application against both and tell you plainly which is the better fit.

Can you upgrade our MariaDB 10.3 or 10.4 server to a current release?

Yes. Those versions are past end of life and no longer get security fixes. We rehearse the upgrade on a copy of your data first, run mariadb-upgrade, test the application against the new release, and only then schedule the real cutover.

Can you set up MariaDB Galera cluster for us?

Yes, and we will also be honest about whether you actually need one. Galera brings synchronous multi-master writes and real high availability, at the cost of operational discipline. For many workloads a primary with a read replica is a better fit.

Why is our MariaDB replica falling behind?

Usually it is a single-threaded replica trying to keep up with a multi-threaded primary, a workload dominated by long transactions, or disk on the replica that is slower than on the primary. Parallel replication, binlog format changes and hardware changes are the common fixes.

Can you take over MariaDB databases from a previous team?

Yes. We inventory the servers, document the versions, replication topology and accounts, rotate credentials, and put monitoring and backups in place before anything else.

How much does MariaDB help cost?

Estimates are free. Describe the version, the hosting and the problem and you get a price before any work begins.

Free estimate

MariaDB giving you trouble?

Tell us what you're running and what's going wrong. A person reads it and comes back with an estimate.

  • No charge to find out what it will take
  • If it's urgent, say so

Replies come from a person. By sending, you authorize us to email you back. No marketing.