Caluya, Susan S.

Database administration in MySQL / Susan S. Caluya [and three others] - Manila : Mindshapers, c2012. - vii, 259 pages : illustrations ; 25 cm.

Includes bibliographical references.

Context of Database Administration -- MySQL Architecture -- User Administration -- Storage Engine -- Logging -- Query Cache -- Server Information -- Transaction Management -- Backup and Recovery -- Table Maintenance -- Database Replication -- Operating System and Hardware Considerations -- Partitioning -- Administration Tools -- Utility Program Reference.

This book provides application and example-oriented introduction to database management in MySQL. The first part of this book introduces the most database management basics such as user administration, storage engines, and lodging. The second part provides extensive discussion of core database management performance guidelines and procedures including query caching, server transaction management, database replication, backup and recovery and table maintenance. In the last part, it emphasize database replication, table partitioning, considerations in hardware and operating system installation and selection, administration tools and reference of commonly used MySQL utility programs.

9789719905356


DATABASE ADMINISTRATION
DATABASE MANAGEMENT

QA 76.73.S67 .C35 2012