Database support for MariaDB

[Paul Norman]

> From: joni [mailto:joni at kurrola.dy.fi]
> Sent: Tuesday, February 04, 2014 5:44 AM
> To: rails-dev at openstreetmap.org
> Subject: Fwd: Database support for MariaDB
> 
> hi,
> 
> Nominatim as well OpenStreetMap project is useing data at such manner
> it could benefit MariaDB ( drop in replacement for mysql ) whit
> tokudb engine.
> 
> Why? It support SDD, it's x5-25 faster, it dose databse compression
>  good level's, MariaDB can do parallel SELECT,.. yes replication!
> 
> I saw github something about mysql,..., but instruction at
> 
> http://wiki.openstreetmap.org/wiki/Nominatim/Installation#PostgreSQL
> 
> and whit software speak's only ProstGres,...
> 
> 
> MariaDB will be stabile at this spring, I hope,
> I can do some,(at spare time), test installations at cluster kurrola
> if you have code available !
> 
> MariaDB + 64GB SSD whit replication allready installed x2.

This mailing list is for the rails port, the software that runs the OSM
website, not Nominatim. The rails port used to run on MySQL, but hasn't
for a long time, and only works on PostgreSQL now.

Just for reference, the nominatim.openstreetmap.org database is on SSDs,
and is approximately 1.1TB, while the main api.openstreetmap.org database
is on 15k SAS drives + SSDs for cache and is 3.6TB.