Galera Innoptimizer: now support tables’ partition

8 October 2014 in Databases, Developement, Hi-Tech, SQL

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.

Galera Innoptimizer: optimize tables without stress

30 September 2014 in Databases, Debian, Developement, Hi-Tech, Linux, Red Hat, SQL

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.

Hadoop meetup on monday in Paris

20 September 2014 in Databases, Events, Hi-Tech

Next Monday will take place a Hadoop meetup. I already heard of it but didn’t tested it yet. This meetup can help you more on what it is and technique usages. If you want to know more about this meetup, please follow the link.

ElasticSearch setup HA and basic usages

10 September 2014 in Databases, Debian, Hi-Tech, Linux, NoSQL

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!

Neo4j: a pretty graph database

6 September 2014 in Databases, Events, Hi-Tech, SQL

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.

Mediawiki: make your search case insensitive

31 August 2014 in Databases, Hi-Tech, Web

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.

My Book: MariaDB High Performance available for pre-order

23 August 2014 in Books, Databases, Debian, Hi-Tech, Linux, SQL

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.