MySQL Admin Cookbook
MySQL Admin Cookbook is a new book from Packt that helps users tackle real-world challenges with MySQL configuration and administration through 99 great recipes. Written by Daniel Schneller and Udo Schwedt, this book walks readers through the basic and advanced aspects of MySQL administration.
MySQL is the most popular open-source database and is also known for its easy set up feature. It is a database management system that runs as a server providing multi-user access to a number of databases. Many web applications use MySQL as the database component of a LAMP (Linux, Apache, MySQL, PHP/Perl /Python) software stack.
Readers will learn to back up their database with advanced techniques and set up MySQL replication to manage load balancing. They will also learn to create, modify, and delete indexes along with identifying duplicate indexes to optimize their MySQL servers' performance. Using advanced techniques such as on-the-fly compression, point-in-time recovery and backup in replication scenarios, readers will be able to back up their database and restore data efficiently and reliably.
As a part of Packt’s Cookbook series, MySQL Admin Cookbook will guide readers to accomplish a specific task in the form of recipes that are based on real-world experience. Example values and code samples are used throughout the recipes, thereby making adaptation for individual needs easy. Users will learn to manage the database schema by customizing it to automate database schema evolution in the context of application updates.
Database administrators and MySQL users interested in widening their MySQL horizon will find this book useful. This book is out now and is available from Packt. For more information, please visit:http://www.packtpub.com/
Photo:
http://www.prlog.org/
