|
|
|
|
| LEADER |
06478nmm a2200505 u 4500 |
| 001 |
EB001926919 |
| 003 |
EBX01000000000000001089821 |
| 005 |
00000000000000.0 |
| 007 |
cr||||||||||||||||||||| |
| 008 |
210123 ||| eng |
| 020 |
|
|
|a 9781484238868
|
| 020 |
|
|
|a 9781484238851
|
| 020 |
|
|
|a 1484238850
|
| 020 |
|
|
|a 1484238869
|
| 050 |
|
4 |
|a QA76.9.D3
|
| 100 |
1 |
|
|a Bell, Charles
|
| 245 |
0 |
0 |
|a Introducing InnoDB Cluster
|b learning the MySQL High Availability Stack
|c Charles Bell
|
| 260 |
|
|
|a [Berkeley, CA]
|b Apress
|c 2018
|
| 300 |
|
|
|a 1 online resource
|
| 505 |
0 |
|
|a Includes bibliographical references and index
|
| 505 |
0 |
|
|a 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
|
| 505 |
0 |
|
|a 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
|
| 505 |
0 |
|
|a 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
|
| 505 |
0 |
|
|a 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
|
| 505 |
0 |
|
|a 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
|
| 653 |
|
|
|a MySQL (Electronic resource) / http://id.loc.gov/authorities/names/n2004021601
|
| 653 |
|
|
|a Computer programming / software development / bicssc
|
| 653 |
|
|
|a Bases de données / Gestion
|
| 653 |
|
|
|a MySQL (Electronic resource) / fast
|
| 653 |
|
|
|a COMPUTERS / Databases / General / bisacsh
|
| 653 |
|
|
|a Database management / http://id.loc.gov/authorities/subjects/sh85035848
|
| 653 |
|
|
|a Databases / bicssc
|
| 653 |
|
|
|a Database management / fast
|
| 041 |
0 |
7 |
|a eng
|2 ISO 639-2
|
| 989 |
|
|
|b OREILLY
|a O'Reilly
|
| 028 |
5 |
0 |
|a 10.1007/978-1-4842-3885-1
|
| 776 |
|
|
|z 9781484238851
|
| 776 |
|
|
|z 1484238850
|
| 776 |
|
|
|z 9781484238868
|
| 776 |
|
|
|z 9781484238844
|
| 776 |
|
|
|z 1484238842
|
| 856 |
4 |
0 |
|u https://learning.oreilly.com/library/view/~/9781484238851/?ar
|x Verlag
|3 Volltext
|
| 082 |
0 |
|
|a 005.74
|
| 082 |
0 |
|
|a 658
|
| 520 |
|
|
|a 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 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
|