MySQL Admin Cookbook

99 great recipes for mastering MySQL configuration and administration

MySQL Admin Cookbook

Daniel Schneller, Udo Schwedt

99 great recipes for mastering MySQL configuration and administration
eBook
$10.00
RRP $29.99
Save 66%
Print + eBook
$49.99
RRP $49.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$10.00
$49.99
RRP $29.99
RRP $49.99
eBook
Print + eBook

Frequently bought together


MySQL Admin Cookbook Book Cover
MySQL Admin Cookbook
$ 29.99
$ 10.00
High Availability MySQL Cookbook Book Cover
High Availability MySQL Cookbook
$ 26.99
$ 10.00
Buy 2 for $20.00
Save $36.98
Add to Cart

Book Details

ISBN 139781847197962
Paperback376 pages

Book Description

MySQL is the most popular open-source database and is also known for its easy set up feature. However, proper configuration beyond the default settings still is a challenge, along with some other day-to-day maintenance tasks such as backing up and restoring, performance tuning, and server monitoring. These tasks have not been covered thoroughly in the default documentation.

This book provides both step-by-step recipes and relevant background information on these topics and more. It covers everything from basic to advanced aspects of MySQL administration and configuration. One of the things you are really going to love about this book is that all recipes are based on real-world experience and were derived from proven solutions used in an enterprise environment.

This book shows you everything you need to know about MySQL Administration. You will learn to set up MySQL replication to manage load balancing and deal with online backup and fail-over scenarios. As you consider the benefits of backing up, you might like to back up your database efficiently with advanced techniques covered in this book.

The book demonstrates how to create, modify, and delete indexes. You will also learn to identify duplicate indexes, which hinder your MySQL server performance. This book focuses on administration tasks and will help you as an administrator to optimize the database for efficiency and reliability.

You will learn to manage data efficiently by inserting data in existing database content and importing and exporting databases. The sooner you learn about taking advantage of metadata from this book, the sooner you can start using the space efficiently. Get to know about managing users and assigning privileges and regaining lost administrative user credentials. Finally, learn to manage the database schema by customizing it to automate database schema evolution in the context of application updates.

Table of Contents

What You Will Learn

  • 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

Authors

Table of Contents

Book Details

ISBN 139781847197962
Paperback376 pages
Read More

Read More Reviews

These popular $10 titles might interest you

High Availability MySQL Cookbook Book Cover
High Availability MySQL Cookbook
$ 26.99
$ 10.00
Creating your MySQL Database: Practical Design Tips and Techniques  Book Cover
Creating your MySQL Database: Practical Design Tips and Techniques
$ 11.99
$ 8.40
MySQL Admin Cookbook LITE: Configuration, Server Monitoring, Managing Users Book Cover
MySQL Admin Cookbook LITE: Configuration, Server Monitoring, Managing Users
$ 9.99
$ 7.00
MySQL Admin Cookbook LITE: Replication and Indexing Book Cover
MySQL Admin Cookbook LITE: Replication and Indexing
$ 9.99
$ 7.00
MySQL Management and Administration with Navicat Book Cover
MySQL Management and Administration with Navicat
$ 17.99
$ 10.00
Responsive Web Design with HTML5 and CSS3 Book Cover
Responsive Web Design with HTML5 and CSS3
$ 23.99
$ 4.80