MySQL Admin Cookbook LITE: Configuration, Server Monitoring, Managing Users

MySQL Admin Cookbook LITE: Configuration, Server Monitoring, Managing Users

Cookbook
Daniel Schneller, Udo Schwedt

$9.99
$19.99
RRP $9.99
RRP $19.99
eBook
Print + eBook
$12.99 p/month

Get Access

Get Unlimited Access to every Packt eBook and Video course

Enjoy full and instant access to over 3000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Code Files
+ Collection

Book Details

ISBN 139781849516129
Paperback120 pages

About This Book

  • Set up MySQL to perform administrative tasks such as configuration, server monitoring and managing user credentials
  • Work with InnoDB in order to improve the organization of your database
  • Restrict access sensibly and regain access to your database in case of loss of administrative user credentials
  • Part of Packt's Cookbook series: Each recipe is a carefully organized sequence of instructions to complete the task as efficiently as possible

Who This Book Is For

This book is for ambitious MySQL users as well as professional data center database administrators. Beginners as well as experienced administrators will benefit from this cookbook and get fresh ideas to improve their MySQL environments. Detailed background information will enable them to widen their MySQL horizon.

It does not cover SQL basics, how to install MySQL servers, or how to design a relational database schema. Readers are expected to have a basic understanding of the SQL language and database concepts in general.

Table of Contents

What You Will Learn

  • Use the InnoDB storage engine to store data in different files and thus improve efficiency
  • Establish alert mechanisms to let you know when table space is running low
  • Identify and change MySQL variables
  • Enable and configure binary logging
  • Understand and configure MySQL and InnoDB timeout options
  • Run multiple MySQL Server Instances in parallel on a Linux server
  • Manage MySQL user accounts and assign appropriate privileges
  • Configure MySQL Administrator to display global privileges and hosts
  • Restrict access sensibly and regain access to your database in case of loss of administrative user credentials

In Detail

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 remains a challenge, along with day-to-day maintenance tasks such as configuration, server monitoring and managing user credentials.

This MySQL Admin Cookbook LITE book provides both step-by-step recipes and relevant background information on many basic and advanced aspects of MySQL administration and configuration.

Three key aspects of MySQL administration are covered in detail; monitoring and analyzing a MySQL installation, configuring MySQL, helping you, amongst other things, to regain lost administrative user credentials, and managing users by assigning privileges.
All of the recipes are based on real-world experience derived from proven solutions used in an enterprise environment.

To find out more about upgrading to the full edition, visit www.packtpub.com/lite-editions and log into your account for offers and help. If you don’t have an account on PacktPub.com, visit today and set one up!

Authors

Table of Contents

Book Details

ISBN 139781849516129
Paperback120 pages
Read More