Overview
Shows how to build highly-available database solutions around MySQL Group Replication, MySQL Router, and MySQL Shell
Provides administrators with key knowledge about setting up, maintaining, and migrating servers to MySQL InnoDB Cluster
Makes available a much-needed introductory text for learning how to utilize high availability in MySQL 8.0.11 and beyond
Access this book
Tax calculation will be finalised at checkout
Other ways to access
Table of contents(10 chapters)
About this book
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
Who This Book Is For
Systems engineers, developers, and database professionals wanting to learn about the powerful high availability (HA) features, beginning with MySQL 8.0.11: MySQL Shell, MySQL Router, and MySQL Group Replication. The book is useful for those designing high-availability systems backed by a database, and for those interested in open source HA solutions.
Authors and Affiliations
-
Warsaw, USA
Charles Bell
About the author
Charles is an expert in the database field and has extensive knowledge and experience in software development and systems engineering. His research interests include 3D printers, microcontrollers, 3D printing, database systems, software engineering, high availability systems, cloud, and sensor networks. He spends his limited free time as a practicing Maker, focusing on microcontroller projects and refinement of 3D printers.
Bibliographic Information
Book Title: Introducing InnoDB Cluster
Book Subtitle: Learning the MySQL High Availability Stack
Authors: Charles Bell
DOI: https://doi.org/10.1007/978-1-4842-3885-1
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Professional and Applied Computing (R0), Apress Access Books
Copyright Information: Charles Bell 2018
Softcover ISBN: 978-1-4842-3884-4Published: 08 September 2018
eBook ISBN: 978-1-4842-3885-1Published: 07 September 2018
Edition Number: 1
Number of Pages: XX, 465
Number of Illustrations: 67 b/w illustrations
Topics: Database Management, Open Source