Cargando…
Introducing InnoDB Cluster : learning the MySQL High Availability Stack /
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.1...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
[Berkeley, CA] :
Apress,
2018.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- 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.