(Paul Dubois) Virtually everything you do in MySQL involves data in some way or another because the purpose of a database management system is, by definition, to manage data. Even a simple SELECT 1 statement involves expression evaluation to produce an integer data value.

(Giuseppe Maxia) You may know about the MySQL Cluster, which is a complex architecture to achieve high availability and performance. One of the advantages of MySQL Cluster is that each node is a peer to the others, whereas in a normal replicating system you have a master and many slaves, and applica

(Barbara Darrow) MySQL plans to outline its plugin architecture that allows VARs and developers to use specialized storage and transaction engines suited for their workloads.

(Jon Stephens and Chad Russell) Many of you are still working with earlier versions of the MySQL database. This article takes a look at MySQL 4.1. It is the first of several parts that examine more recent versions of the software.

(Robert Treat) Many people consider PostgreSQL 8.0 to be a groundbreaking release for the PostgreSQL project, calling it the first version to include native Windows support. But while it did indeed take a significant step in this direction, if you look a bit further you will see that PostgreSQL 8.0

With the rapid growth of MySQL in the database market, many corporations, government agencies, educational institutions, and others have begun to migrate away from their expensive and proprietary databases. Of course, a migration from any database is not something to be taken lightly, and so countle

(Ian Gilfillan) Change is afoot in the PHP/MySQL world. In quite a short space of time, we have moved from MySQL 3.23.x and PHP 4.x, to PHP 5.x and MySQL 4.1.x and now 5.0.x. I have written about some of changes in new versions of PHP, as well as in MySQL. The more grown-up a platform becomes, the m

With the rapid growth of MySQL in the database market, many corporations, government agencies, educational institutions, and others have begun to migrate away from their expensive and proprietary databases. Of course, a migration from any database is not something to be taken lightly, and so countle

(Barbara Darrow) MySQL will use SolidDB OLTP storage engine for its popular open-source database, filling what could have become a void caused by Oracle’s acquisition last fall of Innobase. MySQL had been using Innobase’s InnoDB storage engine.

(Paul DuBois, Stefan Hinz, and Carsten Pedersen) This chapter covers the following exam topics: –Invoking command-line client programs –Specifying command-line options –The mysql client –Using mysql interactively –Using script files with mysql –mysql client commands and SQL statements