My previous post was made a long time ago, so here is a draft that I finally decide to post. Let’s see how to secure some of your data with an encrypted block device using losetup and dd. Steps will be : Create an image with dd Build a new device using the image with an encrypt algorythm [...]

Here is a quick picture about the impact of MySQL indexes misuse. At work, our developers made a new release of their search engine using MySQL fulltext indexes, unfortunately they didn’t implement it correctly. The impact was a huge load on all our database servers. To find the trouble, I had to redirect the SQL [...]

Some times, while scripting in your favorite shell (I mean Bash !! :) you need to print a sequence of letters or numbers. Don’t write it yourself ! Script it using seq or curly braces ! Print a sequence of number nicolas@macvin:~$ seq 1 10 1 2 3 4 5 6 7 8 9 10 nicolas@macvin:~$ seq 0 [...]

Joy ! I just get my new Mac Book Pro (2Go RAM / 2,4Ghz Core 2 Duo / 160Go HDD / etc.). So I’m playing a lot with VMware Fusion and multiple host (debian, ubuntu, solaris, windows, etc.) with a great fluidity ! A big improve for me who was working with an old [...]

Here is a quick post about a cheap SAN and secure backup architecture solution for small-sized platform (5/10 servers). In this study case we will see how to use Network Block Devices (nbd) and soft-raid with mdadm. I design it for my personal web platform which is a small one. Last day, I was missing [...]