Advertisement

Introducing InnoDB Cluster

Learning the MySQL High Availability Stack

  • CharlesĀ Bell

Table of contents

  1. Front Matter
    Pages i-xx
  2. Charles Bell
    Pages 1-41
  3. Charles Bell
    Pages 43-87
  4. Charles Bell
    Pages 89-121
  5. Charles Bell
    Pages 123-157
  6. Charles Bell
    Pages 159-188
  7. Charles Bell
    Pages 189-226
  8. Charles Bell
    Pages 227-293
  9. Charles Bell
    Pages 295-373
  10. Charles Bell
    Pages 375-419
  11. Charles Bell
    Pages 421-457
  12. Back Matter
    Pages 459-465

About this book

Introduction

Set up, manage, and configure the new InnoDB Cluster feature in MySQL from Oracle. If you are growing your MySQL installation and want to explore making your servers highly available, this book provides what you need to know about high availability and the new tools that are available in MySQL 8.0.11 and later. 

Introducing InnoDB Cluster teaches you about the building blocks that make up InnoDB Cluster such as MySQL Group Replication for storing data redundantly, MySQL Router for the routing of inbound connections, and MySQL Shell for simplified setup and configuration, status reporting, and even automatic failover. You will understand how it all works together to ensure that your data are available even when your primary database server goes down. 

Features described in this book are available in the Community Edition of MySQL, beginning with the version 8.0.11 GA release, making this book relevant for any MySQL users in need of redundancy against failure. Tutorials in the book show how to configure a test environment and plan a production deployment. Examples are provided in the form of a walk-through of a typical MySQL high-availability setup.

What You'll Learn:
  • Discover the newest high-availability features in MySQL
  • Set up and use InnoDB Cluster as an HA solution
  • Migrate your existing servers to MySQL 8
  • Employ best practices for using InnoDB Cluster
  • Configure servers for optimal automatic failover to ensure that applications continue when a server fails
  • Configure MySQL Router to load-balance inbound connections to the cluster

Keywords

HA Failover Replication High Availability InnoDB Clustering MySQL Router Group Replication MySQL Shell InnoDB Cluster Load Balancing Automatic Failover

Authors and affiliations

  • CharlesĀ Bell
    • 1
  1. 1.WarsawUSA

Bibliographic information