MySQL 5.7 Reference Manual
xviii
19.1 Preproduction Status — Legal Notice ....................................................................... 2854
19.2 Key Concepts .......................................................................................................... 2854
19.3 Setting Up MySQL as a Document Store .................................................................. 2855
19.3.1 Installing MySQL Shell .................................................................................. 2858
19.3.2 Starting MySQL Shell .................................................................................... 2861
19.4 Quick-Start Guide: MySQL Shell for JavaScript ......................................................... 2861
19.4.1 Introduction ................................................................................................... 2862
19.4.2 Import Database Sample ............................................................................... 2863
19.4.3 MySQL Shell ................................................................................................ 2863
19.4.4 Documents and Collections ........................................................................... 2865
19.4.5 Relational Tables .......................................................................................... 2875
19.4.6 Documents in Tables .................................................................................... 2880
19.5 Quick-Start Guide: MySQL Shell for Python .............................................................. 2881
19.5.1 Introduction ................................................................................................... 2882
19.5.2 Import Database Sample ............................................................................... 2883
19.5.3 MySQL Shell ................................................................................................ 2883
19.5.4 Documents and Collections ........................................................................... 2885
19.5.5 Relational Tables .......................................................................................... 2895
19.5.6 Documents in Tables .................................................................................... 2900
19.6 Quick-Start Guide: MySQL for Visual Studio ............................................................. 2901
19.7 X Plugin .................................................................................................................. 2903
19.7.1 Using Secure Connections with X Plugin ....................................................... 2903
19.7.2 X Plugin Options and Variables ..................................................................... 2903
19.7.3 Monitoring X Plugin ...................................................................................... 2914
20 InnoDB Cluster ................................................................................................................... 2919
20.1 Introducing InnoDB Cluster ...................................................................................... 2919
20.2 Creating an InnoDB Cluster ..................................................................................... 2921
20.2.1 Deployment Scenarios .................................................................................. 2921
20.2.2 InnoDB Cluster Requirements ....................................................................... 2921
20.2.3 Methods of Installing ..................................................................................... 2922
20.2.4 Sandbox Deployment of InnoDB Cluster ........................................................ 2922
20.2.5 Production Deployment of InnoDB Cluster ..................................................... 2925
20.2.6 Adopting a Group Replication Deployment ..................................................... 2933
20.3 Using MySQL Router with InnoDB Cluster ................................................................ 2934
20.4 Working with InnoDB Cluster ................................................................................... 2937
20.5 Known Limitations ................................................................................................... 2946
21 MySQL NDB Cluster 7.5 and NDB Cluster 7.6 .................................................................... 2949
21.1 NDB Cluster Overview ............................................................................................. 2953
21.1.1 NDB Cluster Core Concepts .......................................................................... 2954
21.1.2 NDB Cluster Nodes, Node Groups, Replicas, and Partitions ............................ 2957
21.1.3 NDB Cluster Hardware, Software, and Networking Requirements .................... 2959
21.1.4 What is New in NDB Cluster ......................................................................... 2961
21.1.5 MySQL Server Using InnoDB Compared with NDB Cluster ............................. 2972
21.1.6 Known Limitations of NDB Cluster ................................................................. 2975
21.2 NDB Cluster Installation ........................................................................................... 2985
21.2.1 The NDB Cluster Auto-Installer ...................................................................... 2988
21.2.2 Installation of NDB Cluster on Linux .............................................................. 3003
21.2.3 Installing NDB Cluster on Windows ............................................................... 3012
21.2.4 Initial Configuration of NDB Cluster ............................................................... 3021
21.2.5 Initial Startup of NDB Cluster ........................................................................ 3023
21.2.6 NDB Cluster Example with Tables and Data .................................................. 3024
21.2.7 Safe Shutdown and Restart of NDB Cluster ................................................... 3027
21.2.8 Upgrading and Downgrading NDB Cluster ..................................................... 3028
21.3 Configuration of NDB Cluster ................................................................................... 3030
21.3.1 Quick Test Setup of NDB Cluster .................................................................. 3031
21.3.2 Overview of NDB Cluster Configuration Parameters, Options, and Variables ..... 3033
21.3.3 NDB Cluster Configuration Files .................................................................... 3049
21.3.4 Using High-Speed Interconnects with NDB Cluster ......................................... 3219