There is so much to learn out there. So much to accomplish and so much to devour technically. It can be daunting and overwhelming to have so much in one’s plate, and that is why this Log Buffer Edition has culled some top notch blog posts for you  in Log buffer #264. Oracle: Dominic Delmolino [...]

If you use PrestaShop and nginx, you may find this script to convert PrestaShop’s .htaccess rules into an nginx rule file useful:

#!/usr/local/bin/perl
print <<EOF;
fastcgi_buffers           16 128k;
fastcgi_busy_buffers_size 128k;
fastcgi_buffer_size       128k;
client_body_buffer_size   128k;
EOF
while (<>) {
    if (/^RewriteRule \^(.*) \[L\]$/) { print "rewrite ^/$1? break;\n"; }
    if (/^RewriteRule \^(.*) \[QSA,L\]$/) { print "rewrite ^/$1 break;\n"; }
    if (/^ErrorDocument (\d+) (.*)$/) { print "error_page $1 = $2;\n"; }
}

Save as convert-htaccess.pl and run with ./convert-htaccess.pl <.htaccess >.htaccess.nginx. Then don’t forget to include .htaccess.nginx into your nginx site configuration and reload nginx.

If you have multiple languages or an other configuration that includes { brackets }, you may have to adapt the script.

Tested with PrestaShop …

I guest-posted on Fusion-io’s blog about the database’s working set size and the interplay with fast Flash storage. It’s written from a MySQL point of view, but it’s applicable to many types of systems. The post is gone now, but here’s the content rescued from the archives: As a MySQL consultant with Percona, I’m very happy about the recent advances in fast storage. Faster storage fundamentally changes things for database administrators.

Wow, I completely forgot to advertise this. I’m speaking Saturday (tomorrow) at RubyNation, which is already well underway (I’m missing the first day, though). My topic is “Seven Things To Know About MySQL Performance.”

The second week of April will be quite a busy one

Tuesday, April 10

April 10th is Tutorial day at the Percona Live MySQL Conference and Expo.

On that day, I will present a classic: MySQL Replication 101. This is a topic traditionally presented by a MySQL engineer. However, since Oracle seems not to be eager to send anyone to the conference, I volunteered to the task, and I have let everyone know that, if Oracle change its mind and sends some engineers at the conference, I will happily have one of my former colleagues from the replication team as co-speaker.

Wednesday, April 11

The conference will be in full swing when the regular sessions (and the keynotes!) start. From my side, it is noteworthy the talk about …

The Percona Live MySQL Conference & Expo is going to be awesome! Great speakers, an A-list of sponsors, countless opportunities to engage with the community, and an enthusiastic crowd of MySQL users ensure this is going to be a great event. The conference features 72 breakout sessions, keynotes by leading industry luminaries, an optional day of 16 tutorial sessions, a bustling exhibit hall, and numerous opportunities to connect with other community members.

I am pleased to announce the conference Birds of a Feather sessions and Lightning Talks. Birds of a Feather sessions will be Tuesday and Wednesday nights following the evening receptions. Lightning Talks will be …

I had planned to take tomorrow off as a fun “play hooky” day, but I still have responsibilities, and with the crazy way this work has been going, I feel like I’ve done 5 days of work in 4 days’ time.

So far this week, I feel like this:

I posted that to our internal IRC channel, and it was submitted by someone else to Mozilla Memes, with the title “Life is always better with awesome DBA’s on staff. I love how Mozilla openly appreciates its employees, in both serious and fun ways.

Now, why was this week so crazy? Well, unlike previous weeks, very little work was done on the data center move (even though we have many, many machines yet to move).

• An HP machine that was a db server for Addons and the new …

Check out this MySQL Cluster 7.2 Demo

From the Cluster 7.2 Demo

if you have missed any of the new features.

And upcoming MySQL Webcasts on Cluster, MySQL on Windows, MySQL Enterprise Edition, NoSQL access to MySQL, and Building High Performance and High Traffic PHP applications are available for registration!

…

We're excited to announce new additions to the list of expert speakers at the upcoming SkySQL & MariaDB: Solutions Day for the MySQL Database on April 13.

Building on the already announced keynote from Michael (Monty) Widenius and David Axmark, and speakers from SkySQL, Monty Program, Webyog, Continuent, ScaleDB, Severalnines, Calpont InfiniDB and Sphinx Search, attendees will also gain valuable insight from Constant Contact, Sheeri C. Cabral, and MySQL expert Yoshinori Matsunobu. For the latest details on speakers and their presentations, check our event schedule and featured speakers pages.

…

Thursday, March 29 @ 1 pm ET/10 am PTTuesday, April 3rd @ 15:00 CET/14:00 GMTGrowth is good, right? Yes, unless you are the one building and managing a MySQL database tier to handle all this growth! Your company has built a great new app and launched it in the cloud. And now you are seeing what many wish for: an exponential adoption of your app. But is your database tier really up to the job?What