Book Image

MySQL Admin Cookbook LITE: Replication and Indexing

Book Image

MySQL Admin Cookbook LITE: Replication and Indexing

Overview of this book

Table of Contents (3 chapters)


In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

Code words in text are shown as follows: “Only use qualified statements and replicate-*-table configuration options for intuitively predictable replication!”

A block of code is set as follows:

slave> create database sakila;
slave> use sakila;
slave> source /tmp/sakila_master.sql;
slave> CHANGE MASTER TO master_host=’’, master_port=3306, master_ user=’repl’, master_password=’slavepass’;

When we wish to draw your attention to a particular part of a code block, the relevant lines or items are set in bold:

************************** 1. row ***************************
Slave_IO_Running: Yes
Slave_SQL_Running: Yes

New terms and important words are shown in bold. Words that you see on the screen, in menus or dialog boxes for example, appear in the text like this: “You will see the familiar messages about InnoDB filling up the data files and finally, the Ready for connections line”.


Warnings or important notes appear in a box like this.


Tips and tricks appear like this.