Professional MySQL

Written by the architect of one of today's leading search engines, this book covers such topics as replication, a multiple MySQL server environment, and the new MySQL InnoDB table structure, while answering questions regarding failover, reliability, and more. Offering programmers, database developers, and administrators a road map for installation and specifics for improving performance, this unique coverage features real-world examples - most of which are in PHP code - to illustrate points. This book contains tricks that readers won't find anywhere else, including how to avoid having to shut down MySQL and performing a full backup, or how database connections can make an enormous difference in a large-scale application. It features a discussion of InnoDB-MySQL's transactional environment-and Scott Johnson's firsthand experience with this environment.