MySQL Admin Cookbook LITE: Replication and Indexing


MySQL Admin Cookbook LITE: Replication and Indexing
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 replication and indexing
  • Balance server loads across multiple machines, ease backups and much more with replication 
  • Allow for rapid and efficient access across your database with indexing
  • 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 : 104 pages [ mm x mm ]
Release Date : May 2011
ISBN : 1849516146
ISBN 13 : 9781849516143
Author(s) : Daniel Schneller, Udo Schwedt
Topics and Technologies : All Books, Big Data and Business Intelligence, Lite Editions

Table of Contents

Preface
Chapter 1: Replication
Chapter 2: Indexing
Index
  • Chapter 1: Replication
    • Introduction
    • Setting up automatically updated slaves of
    • a server based on a SQL dump
    • Setting up automatically updated slaves of a selection of tables based on a SQL dump
    • Setting up automatically updated slaves using data file copy
    • Sharing read load across multiple machines
    • Using replication to provide full-text indexing for InnoDB tables
    • Estimating network and slave I/O load
    • Limiting network and slave I/O load in heavy write scenarios using the blackhole storage engine
    • Setting up slaves via network streaming
    • Skipping problematic queries
    • Checking if servers are in sync
    • Avoiding duplicate server IDs
    • Setting up slaves to report custom information about themselves to the master
    • Chapter 2: Indexing
      • Introduction
      • Adding indexes to tables
      • Adding a fulltext index
      • Creating a normalized text search column
      • Removing indexes from tables
      • Estimating InnoDB index space requirements
      • Using prefix primary keys
      • Choosing InnoDB primary key columns
      • Speeding up searches for (sub)domains
      • Finding duplicate indexes

      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: Replication and Indexing MySQL Admin Cookbook

      Lite Edition

      Learn more

      Full Edition

      Learn more
       Set up MySQL to perform administrative tasks such as replication and indexing
      Balance server loads across multiple machines, ease backups and much more with replication 
      Allow for rapid and efficient access across your database with indexing
      eBook available as PDF downloads
      eBook available as ePub downloads
      Available on PacktLib
      Deal with typical performance bottlenecks and lock-contention problems
      Restrict access sensibly and regain access to your database in case of loss of administrative user credentials
      Price £12.99
      £30.99

      Frequently bought together

      MySQL Admin Cookbook LITE: Replication and Indexing +    BackTrack 5 Cookbook =
      50% Off
      the second eBook
      Price for both: £17.95

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

      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
      • Set up automatically updated slaves
      • Estimate and limit your network and slave I/O load
      • Check that your servers are in sync to improve communication
      • Learn about primary keys
      • Speed up your searches for sub-domains

      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 indexing and replication. These tasks have not been covered thoroughly in the default documentation.

      This MySQL Admin Cookbook LITE covers two key aspects of MySQL administration in detail; replication, which will allow you to organize your database more efficiently, and indexing, which enables you to access information even in the deepest, darkest depths of your largest databases.

      All of the recipes are based on real-world experience which were 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