MySQL High Availability, 2nd Edition

Index

Symbols

# (hash mark), Basic Usage

* (asterisk), Basic Usage

--log-slow-queries startup option, Server Logs

_ (underscore), Slave filters

A

acceptable downtime, Achieving High Availability

active binlog file

described, The Binary Log’s Structure and Content, Structure of the Binary Log

switching, Binlog File Rotation

Activity Monitor, Activity Monitor–Activity Monitor

administrative tasks

adding slaves, Adding Slaves–Adding Slaves

checking slave status, Checking Status–Checking Status

load balancing functions, Example of an application-level load balancer

managing replication, MySQL Replicant Library–MySQL Replicant Library, Managing the Replication Topology

MySQL Workbench, MySQL server administration–Data export/restore

performing common, Performing Common Tasks with Replication–Scheduling tasks on Windows

stopping replication, Stopping Replication

advisors

described, Anatomy of MySQL Enterprise Monitor, Advisors

MEM support, Advisors–Advisors

after image (column bitmaps), The Structure of Row Events

agents

described, Anatomy of MySQL Enterprise Monitor

fixing problems, Fixing monitoring agent problems–Configuring the dashboard

installing, Installing the MEM Agent

ALTER statement

binlog events and, Structure of the Binary Log

logging transactions, Logging Transactions

ALTER TABLE statement

changing tablespaces, InnoDB

hierarchal replication, Setting Up a Relay Server

logging, Logging Data Definition Language Statements

MySQL Cluster and, Online Operations

ORDER BY clause, Storing a Table in Index Order

transactional ...