As more enterprise managers look up-the-stack with Open Source beyond Linux, some become concerned about the performance and reliability of software such as Apache, MySQL and even JBoss. Emic Networks is bringing an open approach to optimized clustering, which is designed to keep Open Source apps ru

(Russell J.T. Dyer) As with all data, MySQL databases should be backed up regularly. Backing up MySQL, however, can be approached in several different ways. One possibility is to shut down MySQL first and then to copy the MySQL data files so that the data betweeen tables is consistent. There are

(Antonio Badia, Matt Chanda and Bin Cao) MySQL is an OLTP system without the ability to handle SQL subqueries. As part of our project in query optimization, we add subquery processing to MySQL through rewriting. First, we incorporate the ability to handle subqueries in the FROM clause; then rewr

(Trudy Pelzer and Jim Winstead) The new HELP statement allows you to get help on various topics from the server. You can use HELP contents to get a list of available topics.

(Roy Cheung) One of the very common questions appeared on various developer forums is that of comparing the pros and cons of MySQL and MS SQL. While comparisons have been made by many volunteers, mostly technical issues, I personally find that they are difficult to compare especially regarding their

(J.A. (Zak) Greant) This article aims to clearly answer seven of the most common questions asked by PHP users about MySQL’s licensing. For each question, this article attempts to provide a simple and direct answer that focuses on the intent of the question, rather than its literal meaning. Additiona

(Guilhem Bichot) Here we discuss how to recover data after a crash in case of: –operating system crash –power failure –filesystem crash –hardware problem (hard drive, motherboard…).

(Jeremy Zawodny and Derek J. Balling) This chapter from High Performance MySQL talks about binary distributions, the sections in a configuration file, and some SHOW commands that provide a window into what’s going on inside MySQL.

MySQL 4.1 introduces spatial functionality in MySQL. This article describes some of the uses of spatial extensions in a relational database, how it can be implemented in a relational database, what features are present in MySQL and some simple examples.

(Alexander Prohorenko) Part 1 of this article explained IDS and examined the most popular open source IDS solutions. Part 2 demonstrates some common, practical uses for these solutions.