jdbc mysql cluster_如何连接 mysql cluster

在连接的实例上创建mysql.mysql_innodb_cluster_metadata存储元数据信息

验证配置信息

将此节点注册成seed节点

创建必要的管理账号

启动 Group Replication

mysql-js> \c root@10.186.23.95   #必须连接某个数据节点

Creating a Session to 'root@10.186.23.95'

Enter password:

Classic Session successfully established. No default schema selected.

mysql-js> dba.createCluster('mycluster')

A new InnoDB cluster will be created on instance 'root@10.186.23.95:3306'.

Creating InnoDB cluster 'mycluster' on 'root@10.186.23.95:3306'...

Adding Seed Instance...

Cluster successfully created. Use Cluster.addInstance() to add MySQL instances.

At least 3 instances are needed for the cluster to be able to withstand up to

one server failure.

mysql-js> var cluster=dba.getCluster('mycluster')

mysql-js> cluster.addInstance('root@10.186.23.96:3306')  #添加其他节点

A new instance will be added to the InnoDB cluster. Depending on the amount of

data on the cluster this might take from a few seconds to several hours.

Please provide the password for 'root@10.186.23.96:3306':

Adding instance to the cluster ...

The instance 'root@10.186.23.96:3306' was successfully added to the cluster.

mysql-js> cluster.addInstance('root@10.186.23.94:3306')

A new instance will be added to the InnoDB cluster. Depending on the amount of

data on the cluster this might take from a few seconds to several hours.

Please provide the password for 'root@10.186.23.94:3306':

Adding instance to the cluster ...

The instance 'root@10.186.23.94:3306' was successfully added to the cluster.

mysql-js> cluster.status()

{

"clusterName": "mycluster",

"defaultReplicaSet": {

"name&#