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


MySQL Admin Cookbook LITE: Configuration, Server Monitoring, Managing Users
eBook: $9.99
Formats: PDF, PacktLib, ePub and Mobi formats
$8.49
save 15%!
Print + free eBook + free PacktLib access to the book: $29.98    Print cover: $19.99
$19.99
save 33%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Support
Sample Chapters
  • 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

Book Details

Language : English
Paperback : 120 pages [ mm x mm ]
Release Date : May 2011
ISBN : 184951612X
ISBN 13 : 9781849516129
Author(s) : Daniel Schneller, Udo Schwedt
Topics and Technologies : All Books, Big Data and Business Intelligence, Lite Editions

Table of Contents

Preface
Chapter 1: Monitoring and Analyzing a MySQL Installation
Chapter 2: Configuring MySQL
Chapter 3: MySQL User Management
Index
  • Chapter 1: Monitoring and Analyzing a MySQL Installation
    • Introduction
    • Checking free InnoDB tablespace
    • Establishing alerting mechanisms for low remaining tablespace by using triggers
    • Estimating tablespace requirements
    • Identifying and changing MySQL variables
    • Assessing the overall table count
    • Finding the biggest tables
    • Finding all columns with a certain name and/or type
    • Finding all tables referencing each other
    • Chapter 2: Configuring MySQL
      • Introduction
      • Setting up a fixed InnoDB tablespace
      • Setting up an auto-extending InnoDB tablespace
      • Storing InnoDB data in one file per table
      • Decreasing InnoDB tablespace
      • Enabling and configuring binary logging
      • Configuring the InnoDB redo log
      • Understanding and configuring important MySQL and InnoDB timeout options
      • Adjusting table and database name letter case handling for better platform independence
      • Installing MySQL as a Windows service with custom options
      • Running multiple MySQL server instances in parallel on a Linux server
      • Preventing invalid date values from being stored in DATE or DATETIME columns
      • Chapter 3: MySQL User Management
        • Introduction
        • Configuring MySQL Administrator to display global privileges and hosts
        • Defining an alternative user for administrative tasks
        • Disabling the default accounts
        • Creating a basic user
        • Creating an installation user
        • Creating a read-only account
        • Defining a specific user for backup
        • Defining a specific user for replication
        • Allowing access from specific hosts only
        • Regaining access to your database in case of lost account information
        • Avoiding plain text passwords in administrative scripts

        Daniel Schneller

        Daniel Schneller works as a software developer, database administrator, and general IT professional for an independent software vendor in the retail sector. After successfully graduating from the University of Cooperative Education in Heidenheim, Germany with a degree in Business Computer Science, he started his career as a professional software developer, focused on the Microsoft technology stack. In 2002 he started focusing on enterprise-level Java development and has since gained extensive knowledge and experience implementing large scale systems based on Java EE and relational databases, especially MySQL since version 4.0.

        Currently he is mostly involved with the ongoing development of framework-level functionality, including customization and extension of an ORM-based persistence layer. He is involved in different open source projects such as FindBugs, Eclipse, and Checkstyle and infrequently blogs about Java, MySQL, Windows, Linux and other insanities at http://www.danielschneller.com.


        Udo Schwedt

        Udo Schwedt is head of the Java architecture team and deputy head of the Java development department at the IT service provider for Germany's market leader in the Do-It-Yourself sector. After finishing his studies at RWTH Aachen, Germany with a degree in Computer Science, he started his career as a professional Java developer in a leading software company in the banking sector. In 2003, he joined his current company as a framework developer, subsequently taking the role of a lead architect.

        Both authors are involved in a large scale international software project, which encompasses development of a Java-based merchandise management software solution. This decentralized multi-platform environment is based on more than 500 decentralized MySQL server instances with more than 5,500 replication slaves. Daniel and Udo are responsible for configuration and management of this infrastructure.

        Sorry, we don't have any reviews for this title yet.

        Submit Errata

        Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

        Sorry, there are currently no downloads available for this title.

        Compare Books

        See which product is right for you

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

        Lite Edition

        Learn more

        Full Edition

        Learn more
        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
        eBook available as PDF downloads
        eBook available as ePub downloads
        Available on PacktLib
        Deal with typical performance bottlenecks and lock-contention problems
        Price €14.99
        €38.99

        Frequently bought together

        MySQL Admin Cookbook LITE: Configuration, Server Monitoring, Managing Users +    Java EE 6 Development with NetBeans 7 =
        50% Off
        the second eBook
        Price for both: €24.40

        Buy both these recommended eBooks together and get 50% off the cheapest eBook.

        What you will learn from this book

        • 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!

        Approach

        This cookbook presents solutions to problems in the form of recipes. Each recipe provides the reader with easy step-by-step descriptions of the actions necessary to accomplish a specific task. Example values and code samples are used throughout the recipes, which makes adaptation for individual needs easy

        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.

        Code Download and Errata
        Packt Anytime, Anywhere
        Register Books
        Print Upgrades
        eBook Downloads
        Video Support
        Contact Us
        Awards Voting Nominations Previous Winners
        Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
        Resources
        Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software