I ran into a very surprising result today in regards to using UPDATE ... SET ... that I thought interesting enough to share. For those of you who keep up with my blog (I'm not sure why, but thanks :), you know that I have been playing around with using triggers to keep various items up to date instead of relying solely on the application code itself. This far, I have been pleased. I could see situations where people might abuse the mighty power of triggers, but they seemed to really help keep things consistent on my site - even if it just for a few small things.

I had previously implemented triggers to keep track of the comment count of blog posts. Seemed to make a whole lot more sense to use a trigger for this than having to run multiple queries in the application. Less chance for error, and it is more difficult to mess up the comment counts …

KEWEGO, the European leader in Internet video distribution, has selected MySQL to power its video streaming solutions -? providing an obvious match between two key players in the growing Web 2.0 space.

I have presented this webinar in Italian on Mon 12th Feb. The main topic was the scale-out strategy with MySQL, based on Replication, MySQL Cluster, in combination with other HA solutions, such as DRBD. This picture shows an example of shard using DRBD and MySQL Replication.





The recording (in Italian) and the slides (in English) of the webinar are available here:

Here is an abstract of the Q&A session (still italian):

Q from Giovanni: Volendo implementare una soluzione Mysql in un ambiente completamente virtuale (macchine virtuali su piattaforma esx server clusterizzata) è preferibile aumentare semplicemente il numero di mysql server …

For my US trip in March, I tried flying Delta. On paper they made the best offer regarding price and flight times. I am not a frequent flyer, I do not usually fly in the US and if I should have known to avoid Delta if possible… well, I did not. Also, I have been told that all airlines suck for one reason or another so choosing Delta was not worse than choosing anybody else.

This post is not about accusing anybody, it is a simple report of my booking experience. And about what is wrong with the now popular system of customer support.

I started searching for flights using Kayak. Their website is simple, the UI is very easy to use and anticipates the user’s input with great success. It is a pleasure to …

For my US trip in March, I tried flying Delta. On paper they made the best offer regarding price and flight times. I am not a frequent flyer, I do not usually fly in the US and if I should have known to avoid Delta if possible… well, I did not. Also, I have been told that all airlines suck for one reason or another so choosing Delta was not worse than choosing anybody else.

This post is not about accusing anybody, it is a simple report of my booking experience. And about what is wrong with the now popular system of customer support.

I started searching for flights using Kayak. Their website is simple, the UI is very easy to use and anticipates the user’s input with great success. It is a pleasure to …

For my US trip in March, I tried flying Delta. On paper they made the best offer regarding price and flight times. I am not a frequent flyer, I do not usually fly in the US and if I should have known to avoid Delta if possible… well, I did not. Also, I have been told that all airlines suck for one reason or another so choosing Delta was not worse than choosing anybody else.

This post is not about accusing anybody, it is a simple report of my booking experience. And about what is wrong with the now popular system of customer support.

I started searching for flights using Kayak. Their website is simple, the UI is very easy to use and anticipates the user’s input with great success. It is a pleasure to …

If you read my blog, chances are you are aware of this new fad called the internet, and this new language called PHP. You’re also probably aware of things like MySQL and SQL, and the importance of data to visitors of your website. So, keeping that in mind, I’d also like you to know about backing up this data.

As I grow my business, the number of clients I run into that do not do backups, astounds me. I’m not talking about end user laptops/desktops, but rather backups of their SugarCRM database, or their file server, or even their company website, which is powered by Drupal/Wordpress/CMS Du Jour. When, not If, the database is corrupted, or the disk fails, they have no idea what they would do then. They just hope that it doesn’t happen to them.

So I did some thinking, and decided I should write a post, and make available to the world, a simple script, which I believe will at least give you onsite backups. This is what the …

To hear the New York Times' John Markoff and Matt Richtel describe it in their largely fact-free story on the technical integration that Yahoo! and Microsoft will need to do if the merger goes through, you'd think that a Yahoo-Microsoft integration will amount to a cleaning of the Aegean stables.

The writers did take the time to interview someone who did a Unix-to-Microsoft port of a web site after it was purchased by Microsoft, but that port was done eight years ago. And Microsoft's 1998 Hotmail acquisition (which some people consider to be the gold standard for Microsoft cocking up an acquisition of a *nix-based web property).

So the question is, from a technical integration perspective, could things have possibly changed in the past eight to ten years?

Well, of course they have. The one guy with direct knowledge that …

To hear the New York Times' John Markoff and Matt Richtel describe it in their largely fact-free story on the technical integration that Yahoo! and Microsoft will need to do if the merger goes through, you'd think that a Yahoo-Microsoft integration will amount to a cleaning of the Aegean stables.

The writers did take the time to interview someone who did a Unix-to-Microsoft port of a web site after it was purchased by Microsoft, but that port was done eight years ago. And Microsoft's 1998 Hotmail acquisition (which some people consider to be the gold standard for Microsoft cocking up an acquisition of a *nix-based web property).

So the question is, from a technical integration perspective, could things have possibly changed in the past eight to ten years?

Well, of course they have. The one guy with direct knowledge that …

For some time now, I have been pondering about a Storage engine for MySQL that interfaces with flat files. Yes, I see a few needs that can solve for me.
Today, browsing around, I found Ben Martin's article on Using MySQL as a filesystem. The articles uses MySQLfs to get the desired results. Not 100% what I was looking for but still a good read. Ben writes:
With MySQLfs you can store a filesystem inside a MySQL relational database. MySQLfs breaks up the byte content of files that you store in its filesystem into tuples in the database, which allows you to store large files in the filesystem without requiring the database to support extremely large BLOB fields. With MySQLfs you can throw a filesystem into a MySQL database and take advantage of …