MySQL 8.0 Reference Manual
xviii
18.11 Group Replication Technical Details ....................................................................... 3239
18.11.1 Group Replication Plugin Architecture .......................................................... 3239
18.11.2 The Group .................................................................................................. 3241
18.11.3 Data Manipulation Statements ..................................................................... 3241
18.11.4 Data Definition Statements .......................................................................... 3241
18.11.5 Distributed Recovery ................................................................................... 3242
18.11.6 Observability ............................................................................................... 3248
19 MySQL Shell ...................................................................................................................... 3251
20 Using MySQL as a Document Store ................................................................................... 3253
20.1 Interfaces to a MySQL Document Store .................................................................... 3254
20.2 Document Store Concepts ....................................................................................... 3254
20.3 JavaScript Quick-Start Guide: MySQL Shell for Document Store ................................ 3255
20.3.1 Import Database Sample ............................................................................... 3255
20.3.2 MySQL Shell ................................................................................................ 3256
20.3.3 Documents and Collections ........................................................................... 3258
20.3.4 Relational Tables .......................................................................................... 3268
20.3.5 Documents in Tables .................................................................................... 3274
20.4 Python Quick-Start Guide: MySQL Shell for Document Store ..................................... 3275
20.4.1 Import Database Sample ............................................................................... 3275
20.4.2 MySQL Shell ................................................................................................ 3276
20.4.3 Documents and Collections ........................................................................... 3278
20.4.4 Relational Tables .......................................................................................... 3288
20.4.5 Documents in Tables .................................................................................... 3294
20.5 X Plugin .................................................................................................................. 3295
20.5.1 Checking X Plugin Installation ....................................................................... 3295
20.5.2 Disabling X Plugin ........................................................................................ 3295
20.5.3 Using Secure Connections with X Plugin ....................................................... 3295
20.5.4 Using X Plugin with the Caching SHA-2 Authentication Plugin ......................... 3296
20.5.5 X Plugin Options and Variables ..................................................................... 3296
20.5.6 Monitoring X Plugin ...................................................................................... 3307
21 InnoDB Cluster ................................................................................................................... 3313
21.1 Introducing InnoDB Cluster ...................................................................................... 3313
21.2 Creating an InnoDB Cluster ..................................................................................... 3315
21.2.1 Deployment Scenarios .................................................................................. 3315
21.2.2 InnoDB Cluster Requirements ....................................................................... 3316
21.2.3 Methods of Installing ..................................................................................... 3316
21.2.4 Production Deployment of InnoDB Cluster ..................................................... 3317
21.2.5 Sandbox Deployment of InnoDB Cluster ........................................................ 3326
21.2.6 Adopting a Group Replication Deployment ..................................................... 3329
21.3 Using MySQL Router with InnoDB Cluster ................................................................ 3330
21.4 Working with InnoDB Cluster ................................................................................... 3333
21.5 Known Limitations ................................................................................................... 3358
22 MySQL NDB Cluster 8.0 .................................................................................................... 3359
22.1 NDB Cluster Overview ............................................................................................. 3363
22.1.1 NDB Cluster Core Concepts .......................................................................... 3364
22.1.2 NDB Cluster Nodes, Node Groups, Replicas, and Partitions ............................ 3367
22.1.3 NDB Cluster Hardware, Software, and Networking Requirements .................... 3369
22.1.4 What is New in NDB Cluster ......................................................................... 3371
22.1.5 Options, Variables, and Parameters Added, Deprecated or Removed in NDB
8.0 .......................................................................................................................... 3377
22.1.6 MySQL Server Using InnoDB Compared with NDB Cluster ............................. 3378
22.1.7 Known Limitations of NDB Cluster ................................................................. 3381
22.2 NDB Cluster Installation ........................................................................................... 3391
22.2.1 The NDB Cluster Auto-Installer ...................................................................... 3393
22.2.2 Installation of NDB Cluster on Linux .............................................................. 3414
22.2.3 Installing NDB Cluster on Windows ............................................................... 3422
22.2.4 Initial Configuration of NDB Cluster ............................................................... 3431
22.2.5 Initial Startup of NDB Cluster ........................................................................ 3433