(Ziran Sun) Back in the days of classic ASP, if you were building a database-driven web site, your choice was either to invest a lot of money to get a copy of Microsoft SQL Server (or some other enterprise-ready database) or invest a lot of time finding a way to deal with the performance and scalabi

The Rackspace Data Center powers thousands of business critical applications and high traffic websites, using a proven formula for success: their expertise, Dell systems, and the MySQL database. Join us February 23, 2005, for a web presentation to learn Rackspace’s best practices to deliver high

(Chris Josephes) In Profiling LAMP Applications with Apache’s Blackbox Logs, I discussed using Apache’s built-in logging directives to record server performance metrics. By recording performance metrics, web server administrators can have a historical record of how the server handled incoming HTTP r

(Alex Davies) This HOWTO was designed for a classic setup of two servers behind a loadbalancer. The aim is to have true redundancy – either server can be unplugged and yet the site will remain up.

(Russell J.T. Dyer) The reliability and longevity of the C programming language coupled with the stability of MySQL make them a strong pair for system database management. In last month’s MySQL column, I went over the basics of developing a Perl interface to MySQl. Before that, I covered PHP with My

The program for the third annual MySQL Users Conference continues to expand — providing IT professionals, programmers, DBAs, and other users a more comprehensive look into the solutions and opportunities offered by the world’s most popular open source database. The MySQL Users Conference will be hel

(Tony Bourke) With the introduction of the 2.6 Linux kernel, FreeBSD-5-STABLE, Solaris 10, and now NetBSD 2.0, you might be wondering which of them offers superior database performance. In my previous article, I discussed the tools I chose to test these venerable operating systems and the methodolog

(Ian Gilfillan) This month’s topic is one that often baffles inexperienced SQL coders. We will look at the GROUP BY clause, and then the difference between conditions placed in the WHERE clause, and the HAVING clause. I have used MySQL to test all of the examples, but most of them should work withou

(Robert Lemos) A source-code analysis of the MySQL database, a popular open-source program at the heart of many Web sites, revealed few bugs compared with the number found in commercial code, testing company Coverity said.

(Lisa Vaas) In the wake of the MySpooler worm that spread via weak MySQL passwords on Windows installations last week, database users criticized the open-source database for lax security lockdown on installation, saying that it should be held to the same high standards as traditional security whippi