We don’t always need all rows from the table as part of the final results set. You can use one (or more) of the comparison operators to filter the rows with a WHERE clause conditional. In this post, we are looking at the equality comparison operator (=)…

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

Image by kalhh from  …

Wikimedia Foundation is expanding Wikipedia to multimedia with Sun Open Storage Solution and MySQL Database:

Wikipedia receives between 25,000 and 60,000 page requests per second, depending on the time of day. Wikimedia needed to update its infrastructure to handle this huge volume of traffic and ensure that its systems were reliable, highly available, and easily scalable. It also wanted to expand its upload file limit from 20 MB to 100 MB to accommodate rich media (audio and video) content, but before it could do that it needed to expand its storage capacity.

…

Wikimedia Foundation is expanding Wikipedia to multimedia with Sun Open Storage Solution and MySQL Database:

Wikipedia receives between 25,000 and 60,000 page requests per second, depending on the time of day. Wikimedia needed to update its infrastructure to handle this huge volume of traffic and ensure that its systems were reliable, highly available, and easily scalable. It also wanted to expand its upload file limit from 20 MB to 100 MB to accommodate rich media (audio and video) content, but before it could do that it needed to expand its storage capacity.

…

Wikimedia Foundation is expanding Wikipedia to multimedia with Sun Open Storage Solution and MySQL Database:

Wikipedia receives between 25,000 and 60,000 page requests per second, depending on the time of day. Wikimedia needed to update its infrastructure to handle this huge volume of traffic and ensure that its systems were reliable, highly available, and easily scalable. It also wanted to expand its upload file limit from 20 MB to 100 MB to accommodate rich media (audio and video) content, but before it could do that it needed to expand its storage capacity.

…

Karim Lakhani has put together a business case study on Wikipedia. It is worth noting that Wikipedia uses MySQL as its database engine. 

This week I'm attending the second of two developer conferences on my schedule for this month. I noticed an interesting trend that I hadn't seen discussed anywhere else before. Nearly every presenter is using some kind of virtualization technology to give their talks.

This is a terrific idea -- it's awesome to have a more or less pristine copy of your development environment that you can put into cold storage and spin up right before your talk is slated to begin.

I'm not sure why it's taken until 2007 for this kind of virtualization to reach a tipping point, although it might have something to do with the success of Parallels on the Mac -- as well as the fact that Microsoft released Virtual PC as a free product last year. (Although I should mention that I overheard more than one conversation at VSLive two weeks ago from presenters who were slagging Virtual PC's performance.)

I'd be willing to bet that this trend will work …