Introducing InnoDB Cluster: Learning the MySQL High Availability Stack by Charle

Description: Introducing InnoDB Cluster by Charles Bell 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 Youll LearnDiscover the newest high-availability features in MySQLSet up and use InnoDB Cluster as an HA solutionMigrate your existing servers to MySQL 8Employ best practices for using InnoDB ClusterConfigure servers for optimal automatic failover to ensure that applications continue when a server failsConfigure MySQL Router to load-balance inbound connections to the clusterWho This Book Is ForSystems 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. FORMAT Paperback LANGUAGE English CONDITION Brand New Back Cover 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 Youll 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 Author Biography Charles Bell conducts research in emerging technologies. He is a member of the Oracle MySQL development team and is a senior software developer for the MySQL Enterprise backup team. He lives in a small town in rural Virginia with his loving wife. He received his Doctor of Philosophy degree in engineering from Virginia Commonwealth University in 2005. 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. Table of Contents 1. Introduction to High Availability.- 2. What is MySQL InnoDB Cluster?.- 3. MySQL Group Replication.- 4. MySQL Shell.- 5. High Availability in a Sandbox.-6. MySQL Router.- 7. Example MySQL HA Deployment.-8. Example Application.- 9. InnoDB Cluster Administration.- 10. Planning Your Deployment. Feature 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 Details ISBN1484238842 Author Charles Bell Publisher APress Year 2018 Edition 1st ISBN-10 1484238842 ISBN-13 9781484238844 Format Paperback Imprint APress Subtitle Learning the MySQL High Availability Stack Place of Publication Berkley Country of Publication United States DEWEY 005.74 Pages 465 Publication Date 2018-09-08 Short Title Introducing InnoDB Cluster Language English DOI 10.1007/978-1-4842-3885-1 AU Release Date 2018-09-08 NZ Release Date 2018-09-08 US Release Date 2018-09-08 UK Release Date 2018-09-08 Illustrations 67 Illustrations, black and white; XX, 465 p. 67 illus. Edition Description 1st ed. Alternative 9781484245712 Audience Professional & Vocational We've got this At The Nile, if you're looking for it, we've got it. With fast shipping, low prices, friendly service and well over a million items - you're bound to find what you want, at a price you'll love! TheNile_Item_ID:137820666;

Price: 103.65 AUD

Location: Melbourne

End Time: 2024-11-05T01:56:33.000Z

Shipping Cost: 0 AUD