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/ _______________________________________________ Geocoding mailing list [email protected] https://lists.openstreetmap.org/listinfo/geocoding
