Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

MySQL Admin Cookbook LITE: Replication and Indexing

MySQL Admin Cookbook LITE: Replication and Indexing

Overview of this book

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. 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. 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 1. Replication

In this chapter, we will discuss:

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

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

MySQL Admin Cookbook LITE: Replication and Indexing

Search

Your notes and bookmarks