SkySQL Meet-Up was awesome !

18 December 2013 in Hi-Tech, SQL

The SkySQL meeting was really good yesterday ! We’ve seen MariaDB 10 new features, had a presentation of Galera cluster and a complicated (but good) explanation of a complex infrastructure that required write scaling. This was the my first SkySQL Meet-Up and I can’t wait until the next one :-). Congratulation SkySQL, one of the best Meet Up I’ve seen !

Galera : How to perform Zero Downtime Schema Changes

10 December 2013 in HA, Hi-Tech, SQL

Last week, I had a webinar regarding Galera Cluster given by Severalnines. As I found it very interesting, I’m sharing it with you :

MariaDB : restore on database from a single full dbs backup

18 November 2013 in Hi-Tech, SQL

I recently discovered how to restore only one database from a huge sql dump containing more than 1 database and wanted to share it with you : mysql -u<user> -p<password> --one-database <database_name> < backup-`date +%y%m%d`.sql I’ve added it to my wiki as well. Source : System Linux

Galera : Enlarge your gcache

2 November 2013 in Hi-Tech, SQL

Galera uses a preallocated file with a specific size called gcache, used to store the writesets in circular buffer style. By default, its size is 128MB and it’s a good idea to upgrade it to a higher value. I’ve updated my documentation on that if you want to check. In addition, you can find more informations, I suggest a Severalnines link.

PuPHPet : speed up your Vagrant deployment

6 August 2013 in Databases, Debian, Hi-Tech, Linux, Mac, Puppet, Red Hat, SQL, Virtualization, Web

Vagrant is a fast solution build on top of VirtualBox. I already talked about it in a previous post. The thing is, you could do really more with Vagrant by adding Puppet manifests or Chef recipes in your Vagrant configuration file. For those who don’t often use one of those 2 softwares, it quickly could transform into a nightmare when they want to deploy softwares in addition of the OS.

Galera Cluster : How to do maintenance and recover

29 July 2013 in Hi-Tech, Linux, SQL

To finish my Galera’s posts, I’ve wrote tips to help on maintenance and recover for the Galera Cluster (in french). As most of the time, Galera is able to manage automatically data recovering, some times (if split brain occurs for example) you need to manually do specific stuffs to recover the cluster. I hope this will help some of you if problems occurs.

Galera Cluster : choose the better SST method

25 July 2013 in Hi-Tech, Linux, SQL

Last month, I’ve wrote a document accessible on slideshare to explain some of basic/advanced features of MySQL/MariaDB. In addition, there were some informations related to Galera Cluster running on top of MariaDB. I’ve updated my documentation to help on choosing the better SST method and understand the differences (in french).