Book Image

MySQL Admin Cookbook LITE: Replication and Indexing

Book Image

MySQL Admin Cookbook LITE: Replication and Indexing

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
MySQL Admin Cookbook LITE: Replication and Indexing
May, 2011 | 104 pages
No titles found
Table of Contents (3 chapters)
Preface
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Free Chapter
1
1. Replication
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
2
2. Indexing
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

Chapter 2. Indexing

In this chapter, we will cover:

  • 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
Previous Section
End of Section 1
Next Section