You may remember the first introduction of that tool here. I’ve made changes to support tables’ partition, to avoid a big lock on huge tables. The solution is to rebuild every partition one by one instead of rebuilding the whole table. This is smoother and less stressing Galera. I hope you’ll enjoy this new version (v0.2). Note: I still got issues on MariaDB 10 with such thing, I’m working on it.

Continue reading

I recently been faced on a classical problem on InnoDB which is the fragmentation, but on Galera. InnoDB engine doesn’t defragment on the fly and requires optimize maintenance sometimes to free disk space. But on Galera, which is a fault tolerance and high availability solution, it’s a problem having tables locked by an optimize procedure. Until Galera doesn’t support TokuDB and only fully support InnoDB, we had (with a colleague (Kevin aka Vinek)) to find a solution.

Continue reading

I recently played with ElasticSearch Cluster and I totally fall in love! How easy it is, everything is automatic, it works perfectly, wowwww!!! I made a little documentation on how to setup one, you can find it there. ElasticSearch is a really powerful solution and I really like working with it. If you’re searching a full text search solution, try ElasticSearch, you’ll be happy!

Continue reading

I forgot to talk about 1 meetup I’ve been regarding Neo4j. A friend (evomusic) talked to me about it and as I’m curious, I went to this meetup in July. Neo4j is a highly scalable, robust (fully ACID) native graph database. Neo4j is used in mission-critical apps by thousands of leading startups, enterprises, and governments around the world. I you don’t know what is a graph database, it’s a very good introduction and will help you to understand what it is and how it works.

Continue reading

For several years, I was wondering how to make Mediawiki search case insensitive. I didn’t really had time to look at it until I was really fed up. That’s why after a few seconds of search, I’ve found an extension for Mediawiki which is working perfectly called TitleKey. The TitleKey extension provides a case-insensitive title prefix search. It uses a separate table for the keys, so if it works cleanly it can be deployed without an expensive rebuild of core tables, and dumped when Wikimedia gets a nicer backend through Extension:LuceneSearch (pre 1.

Continue reading

All, I’m proud to announce my first book available for pre-order! I’m really happy to have finished it and see after several months of hard work that it will be soon available. Who is this book for? MariaDB High Performance is aimed at system administrators/architects or DBAs who want to learn more about how to grow their current infrastructure to support larger traffic. Before beginning with this book, we expect you to be well–practised with MySQL/MariaDB for common usage.

Continue reading

Author's picture

Pierre Mavro / Deimosfr


MySocialApp Co-Founder  •  Staff SRE Lead at Criteo

Paris - France