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)

Conventions

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.example.com’, master_port=3306, master_ user=’repl’, master_password=’slavepass’;
slave> START SLAVE;

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

slave> SHOW SLAVE STATUS\G
************************** 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”.

Note

Warnings or important notes appear in a box like this.

Tip

Tips and tricks appear like this.