	Login		Register

Title: MySQL: The Complete Reference

Recommend this page to a friend!

Stumble It!

Bookmark in del.icio.us

	All reviews		MySQL: The Complete Reference		Latest reviews		Best sellers ranking

Title

Find where to Buy Now

MySQL: The Complete Reference

Author

Vikram Vaswani

Publisher

McGraw-Hill Osborne

Release date

December 18, 2003

ISBN

0072224770

Reviews

March 22, 2004 5

	Post a comment		See comments		Find where to Buy Now

Manuel Lemos
manuellemos.netMySQL and PHP are two Open Source products that have been holding hands since their early days. PHP always has been a very popular Web programming language because it is free and dedicated to Web development.

On the other hand, most PHP applications require a capable database engine. Since MySQL is capable enough and is also free, it became a perfect partner database application, which explains why it is so popular in the PHP world.

Along with Linux and Apache, MySQL completes the set of main components that comprise the popular quartet of free Web development applications frequently used together that is often known as LAMP: Linux, Apache, MySQL and PHP.

Despite previously lacking some of the powerful features that are usually available in high-end database server products, MySQL became increasingly popular over time. However, MySQL has evolved to implement many of the features that used to be lacking.

"MySQL: The Complete Reference" is an up to date book that covers MySQL features exhaustively, including the latest enhancements introduced in the recent releases.

The book is divided in four parts of several chapters each: installation, usage, administration and development.

The installation part provides an introduction to MySQL sub-systems and their components before explaining how to install and configure MySQL on Windows or Unix/Linux like platforms either from readily available binaries of from the source code distribution.

The usage part mostly covers access to databases using SQL. It has special chapters about newer features like sub-queries and transaction support.

The administration part covers all aspects of DBA interest, including configuration, security, user access control, maintenance tasks, data backup and recovery, performance tuning and database server replication.

The development part cover aspects of the MySQL APIs and how to use them to access MySQL databases from programs developed in C, Perl and PHP.

Overall this is a very complete reference book, of interest to different types of users of MySQL databases from database application developers to database administrators. The fact that it covers features introduced in MySQL 4 and more recent versions like ACID transactions, referential integrity, query result caching and sub-queries, makes it an excellent choice for people looking for an up to date MySQL book.

	Post a comment		See comments		Find where to Buy Now

Comments

No comments were submitted yet.