Professional MySQL

Written by the architect of one of today2s 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 roadmap for installation and specifics for improving performance, the unique coverage features real-world examples-most of which are in PHP code-to illustrate points Contains tricks that readers won2t 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 Features a discussion of InnoDB-MySQL2s transactional environment-and Scott Johnson2s firsthand experience with this environmentJohnson, J. Scott is the author of 'Professional MySQL', published 2006 under ISBN 9780764588051 and ISBN 0764588052.