[Geocoding] Database support for MariaDB

[Glenn Plas]

On 04-02-14 14:32, joni wrote:
>
> 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.
>

I'm a big fan and early adopter of MariaDB, it's awesome, my blog is 
full of it.  I hardly know postgresql, and there is a reason: I almost 
never need to touch it to make it work stable.  Tune it once (before 
import, 'untune' it for import/index) and live hapily ever after.

If it comes down to performance, I think postgresql still beats mariadb 
on performance but I've never truly benchmarked it.   I wish more sites 
used postgresql.  We should try to benchmark it.  MariaDB should replace 
all mysql stock installs, GIS or NOGIS.

/// Glenn
http://byte-consult.be/