I'll be speaking at ConFoo in Montreal this March. I have two talks on performance and scaling. If you're in the area, drop in. The conference line-up is great, and if PHP Quebec last year was any indication, it should be very enlightening.

Mercredi 10 Février, 11h00 (Paris) : Sécurité pour les applications Web. Pour les startups du Web, la protection et la sécurisation de leurs applications, de leurs données, et de celles de leurs clients est un véritable facteur clé de succès.  Ce Webinar couvre les différents challenges liés à la sécurité ainsi que les solutions associées telles que l'encryption, l'authentification, les certificats, la sécurisation du stockage et le stockage à tolérance de panne, les environnements étanches. Les architectes de Sun Startup Essentials présenteront des implémentations économiques basées sur des composents standards et ouverts tel qu'Apache, MySQL et ZFS. Ce webinar fait partie de l'accompagnement du programme Sun Startup Essentials et est réservé à ses membres.

Votre société a moins de 6 ans et moins de  150 …

I was re-reading through Oracle’s tech white paper on Exadata v2, and I must have missed the first time a new feature they brought out in the latest version – storage indexes:

“Storage Indexes are a very powerful capability provided in Exadata storage that helps avoid I/O operations. The Exadata Storage Server Software creates and maintains a Storage Index in Exadata memory. The Storage Index keeps track of minimum and maximum values of columns for tables stored on tRead More...

I was re-reading through Oracle’s tech white paper on Exadata v2, and I must have missed the first time a new feature they brought out in the latest version – storage indexes:

“Storage Indexes are a very powerful capability provided in Exadata storage that helps avoid I/O operations. The Exadata Storage Server Software creates and maintains a Storage Index in Exadata memory. The Storage Index keeps track of minimum and maximum values of columns for tables stored on tRead More...

I’m on the voting committee of the MySQL Conference this year. I was on the same committee in 2008. This year’s submissions are awesome. Much different from previous years, for whatever reason. Some of the proposals are sales pitches, infomercials, or just generally BS, but there’s a gang of sharp-eyed people on the committee who are digging into who submits the proposals, what their company does, etc. Those sessions are getting shot down with bluntly honest reviews and low votes.

I already mentioned this repository several times on my blog. It is the repository where I'm trying to keep bleeding edge stuff for MySQL. I've been updating it recently and we've got new package there and some interesting updates I want to mention.

MariaDB and MySQL

First thing to mention is that this repository contains MariaDB builds. MariaDB is fork of MySQL and their goals are certainly interesting. For list of differences, try upstream page. As I consider it interesting, I'm keeping eye on it Maybe our users may benefit from it. But currently it is also a source of possible problems in this repository as it contains MySQL as well. I tried to modify both packages in …

I already mentioned this repository several times on my blog. It is the repository where I’m trying to keep bleeding edge stuff for MySQL. I’ve been updating it recently and we’ve got new package there and some interesting updates I want to mention.

MariaDB and MySQL

First thing to mention is that this repository contains MariaDB builds. MariaDB is fork of MySQL and their goals are certainly interesting. For list of differences, try upstream page. As I consider it interesting, I’m keeping eye on it Maybe our users may benefit from it. But currently it is also a source of possible problems in this repository as it contains MySQL as well. I tried to modify both …

db4free.net users may have noticed that they can't access the server on port 3307 anymore.

It isn't gone (yet), but soon will be. I plan to reduce the db4free.net service to a single server again which means that the 2nd server will be removed. So in order to make people notice that a change is going to happen, I moved the server to port 3308.

If you have data on this server which you want to keep, please move it to the port 3306 server until February 28, 2010. After then, the server will no longer be accessible.

Another change which is going to happen is that I will delete db4free.net accounts again which are not being used anymore. If you have - or will until end of February - accessed your port 3306 any time in the year 2010, you will be safe (unless you use up excessively much disk space or do other naughty things, so your account gets deleted for …

If you are running your MySQL databases on the Amazon EC2 compute cloud, Zmanda Recovery Manager (ZRM) for MySQL can perform fast full backups of these databases by using Elastic Block Store (EBS) Snapshots. ZRM takes only a momentary read lock on the MySQL database during the creation of the snapshot, in order to ensure consistency of the backed up database archive. MySQL Backups using Amazon EBS snapshots are differential backups, meaning that only the blocks that have changed since your last full backup (via EBS snapshot) will be saved. For example, if you have a database with 100 GBs of data, but only 5 GBs of data has changed since your last snapshot, only the 5 additional GBs of snapshot data will be stored back to Amazon S3 during the current full backup run.

ZRM automatically deletes EBS snapshots (containing full backups of MySQL) according to the configured …

In previous articles, we examined the maximum performance of basic web static and dynamic (php) requests. In this article, we will take a look at what happens when a database access is added to a simple php page. The application code is part of the corelamp workload (see webapp/hellomysql.php).

In this application, I added a single database row request to the TABLES table in the …