MySQL Admin Cookbook {purestevil} release
:clover: Information:
Author(s) : Daniel Schneller, Udo Schwedt Publisher : Packt Date : 2010 Pages : 376 Format : PDF ISBN-10 : 1847197965
What you will learn from this book: * Set up MySQL replication to manage load balancing, online back up, and fail-over scenarios * Create, modify, and delete indexes; also identify duplicate indexes to optimize your MySQL servers' performance * Leverage the power of MySQL Administrator, Query Browser GUI Tools, and the MySQL command line client * Back up your database and restore the data efficiently and reliably with advanced techniques such as on-the-fly compression, point-in-time recovery, avoiding extended lock situations, backup in replication scenarios, and partial backup and restore. * Manage data by deleting data in a highly efficient manner, inserting data based on existing database content, and importing and exporting data in a customizable manner * Monitor table space usage and use database metadata to your advantage * Deal with typical performance bottlenecks and lock-contention problems * Configure MySQL and leverage available settings to their full potential * Manage MySQL user accounts and assign appropriate privileges * Restrict access sensibly and regain access to your database in case of loss of administrative user credentials * Manage the schema by adding and removing columns from tables, choosing a suitable storage engine and character set for individual needs * Add a new primary key column to a table already filled with data and also manage and automate database schema evolution in the context of application updates |