MySQL/MariaDB Consultancy

MySQL and MariaDB have a common heritage,  MariaDB being a fork of MySQL 5.1.

The reasons for the split (which followed the acquision of MySQL by Oracle Corporation in 2009) include licencing and commercial concerns – a web serch will tell you more than we can here…

Upgrade from MySQL to MariaDB is generally not complex although we have found the odd easily fixed issue.  For more see MariaDB/MySQL compatibility

Under the hood,  there are now many differences between the two,  including functionality and performance.  Although a detailed comparison is out of scope for this page,  we would point to Temporal Tables and Columnstore as examples of MariaDB’s innovations which may be of interest.

Either can be an excellent free alternative to commercial databases such as Oracle or DB2.   We offer a variety of consultancy solutions:

 

Installation

A complete installation service including configuration, documentation, training and handover.

Potential platforms include Centos, RHEL (bare metal, VMWare, Xenserver, AWS etc) or RDS

Optimisation

We are highly experienced in helping our customers get the best performance from their Postgres installation. Amongst other things we includea  deep dive into server configuration and optimisation, database tuning, infrastructure review, indexing and query optimisation

DBA (Database Administration)

We can provide DBA services either on site or online. Either on a one-off basis or on a long term contract

Application Development

Our expertise includes SQL, Java, PHP, Web applications, data warehouses, PostGIS, low impact data integration

Database Migration

We have extensive database migration experience including MySQL to MariaDB

Database upgrade

Upgrade to the latest version of MySQL or MariaDB.  We have extensive experience including performing upgrades with minimum downtime

Temporal Tables

Temporal tables  can be used to store, access and change past data, find what/when changes have been made and can be used to rollback data to a prior point in time

These are available as a native MariaDB feature (could be implemented in MySQL as a bespoke addition with a lot of work!)

 

Columnstore

MariaDB provides Columnstore which is a columnar storage engine that uses a massively parallel distributed data architecture.

Data is stored in columns rather than rows (eg like Redshift) and enables us to embed OLAP/Analytical features in an OLTP database.

In our experience,  even with a single database node, columnstore offers exceptional performance and could offer a cost effective alternative to traditional OLTP databases

MySQL – MariaDB functional Differences

See here for MariaDB claimed benefits,  including more storage engines, speed improvements, extensions, new features etc