MySQL Administrator's Bible is designed to provide a solid framework for a beginning MySQL DBA or an intermediate level DBA transitioning from another database platform. The book is divided into two parts---Part 1 covers the fundamentals of MySQL database management, including MySQL's unique approach to such basic database features/functions as SQL queries, data and index types, stored procedures and functions,, triggers and views, and transactions. The authors briefly explain each topic in terms of general database management practices, and then drill down into how they work in a MySQL environment. Part 2 provides comprehensive coverage of major MySQL Server components and processes for which DBAs are responsible---these include: MySQL Server Tuning Query Processing, including authentication and optimization Managing storage engines Caching Backup and Recovery Managing users Partitioning Replication and logging Index tuning Database and performance monitoring Security Managing availability and scaling Appendixes will include a tutorial on basic, foundational SQL programmingthat all MySQL DBAs need to understand (and often don't), plus reference resources. The companion website will provide code examples, scripts,and data schemas used in the book.
- ISBN: 978-0-470-41691-4
- Editorial: John Wiley & Sons
- Encuadernacion: Rústica
- Páginas: 888
- Fecha Publicación: 08/05/2009
- Nº Volúmenes: 1
- Idioma: Inglés
- Inicio /
- INFORMÁTICA /
- MYSQL