MySQL Admin Cookbook LITE: Replication and Indexing
eBook:
$9.99
Formats:
Formats:
$8.49
save 15%!
save 15%!
Print + free eBook + free PacktLib access to the book:
$29.98
Print cover: $19.99
$19.99
save 33%!
save 33%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
| Also available on: |
|
- 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 : EnglishPaperback : 104 pages [ mm x mm ]
Release Date : May 2011
ISBN : 1849516146
ISBN 13 : 9781849516143
Author(s) : Daniel Schneller, Udo Schwedt
Topics and Technologies : Lite Editions
Table of Contents
PrefaceChapter 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
Udo Schwedt
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.
See which product is right for you
 |
 |
Lite EditionLearn more |
Full EditionLearn 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 | €14.99 |
€38.99 |
|---|
Frequently bought together
+
=
50% Off
the eBooks
the eBooks
Buy both these recommended eBooks together and get 50% off the total price
- 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
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!
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
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.
