Introducing InnoDB Cluster: learning the MySQL High Availability Stack

Intro; Table of Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Chapter 1: Introduction to High Availability; What Is High Availability?; Recovery; Logical Backup; Physical Backup; Redundancy; Scaling; Fault Tolerance; Overview of MySQL High-Availability Features; MySQL Replication Primer; MySQL Replication Tutorial; Initialize the Data Directories; Configure the Master; Configure the Slaves; Start the MySQL Instances; Create the Replication User Account; Connect the Slaves to the Master; Connect with Log File and Position; Connect with GTIDs.

Start ReplicationVerify Replication Status; Example MySQL Replication Script; Challenges for MySQL DBAs; Setup; Troubleshooting; Maintenance; Administration; References on MySQL High Availability; Summary; Chapter 2: What Is MySQL InnoDB Cluster?; Overview; What Is a Storage Engine?; MyISAM; Memory; Merge; Archive; Federated; CSV; Blackhole; InnoDB; Introducing InnoDB Cluster; InnoDB Cluster and the MySQL Document Store; InnoDB Cluster and NDB Cluster; Components; Group Replication; MySQL Shell; X DevAPI; AdminAPI; Router; Installing InnoDB Cluster; Summary; Chapter 3: MySQL Group Replication.

Concepts, Terms, and LingoOverview; MySQL Group Replication Tutorial; Initialize the Data Directories; Configure the Primary; Configure the Secondaries; Start the MySQL Instances; Install the Group Replication Plugin; Create the Replication User Account; Start Group Replication on the Primary; Connect the Secondaries to the Primary; Start Group Replication on the Secondaries; Verify Group Replication Status; Demonstration of Failover; DevOps Scripts; Summary; Chapter 4: MySQL Shell; Using MySQL Shell; Shell Commands; Options; Sessions and Modes; Session Objects; Modes Supported; Connections.

Using a URIUsing Individual Options; Using Connections in Scripts; Using SSL Connections; Installing the MySQL Shell; Enabling the X Plugin; Enable the X Plugin by Using MySQL Shell; Enable the X Plugin by Using the MySQL Client; Tutorial; Installing the Sample Database; Inserting Data; Selecting the Data; Summary; Chapter 5: High Availability in a Sandbox; Getting Started with the AdminAPI; The dba Class; The cluster Class; Demonstration; Setup and Configuration; Create and Deploy Instances in the Sandbox; Create the Cluster; Add the Instances to the Cluster; Check the Status of the Cluster.

FailoverDevOps Scripts; Summary; Chapter 6: MySQL Router; Overview; Installation; MySQL Installer (Windows); Other Platforms; Configuration; Setting Up InnoDB Cluster in a Sandbox; Modifying the Configuration File; Configuring with the Bootstrap Option; Using the Bootstrap Configuration File; [DEFAULT]; [logger]; [metadata_cache:MyCluster]; [routing:]; Starting the Router; Testing the New Configuration; Using the Router with Your Applications; Summary; Chapter 7: Example MySQL High Availability Deployment; Establishing the Servers; Installing MySQL on Commodity Hardware.