TY - BOOK AU - Caluya, Susan S. AU - Marfil, Ronald T. AU - Hernandez, Alexander A. AU - Rebong, Corazon AU - Caballero, Jonathan M. TI - Database administration in MySQL SN - 9789719905356 AV - QA 76.73.S67 .C35 2012 PY - 2012/// CY - Manila PB - Mindshapers KW - DATABASE ADMINISTRATION KW - DATABASE MANAGEMENT N1 - 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 N2 - 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 ER -