MySQL Router构建读写分离，提示schemadoes not exist.

GreatSQL版本：8.0.32-24。
MySQL Router  版本：Ver 8.0.32 for Linux on x86_64 (MySQL Community - GPL)

szhjb88 发表于 2023-12-3 18:03
GreatSQL版本：8.0.32-24。
MySQL Router  版本：Ver 8.0.32 for Linux on x86_64 (MySQL Community - GPL) ...

用MySQL Shell接管MGR后，就会创建mysql_innodb_cluster_metadata这个元数据Schema，然后就可以用Router接入了

yejr 发表于 2023-12-4 08:12
用MySQL Shell接管MGR后，就会创建mysql_innodb_cluster_metadata这个元数据Schema，然后就可以用Router ...

请问  用MySQL Shell接管MGR，是不是通过以下命令？

MySQL  localhost:33060+ ssl  JS > var c=dba.createCluster('MGR1');
A new InnoDB Cluster will be created on instance '192.168.3.244:3306'.

You are connected to an instance that belongs to an unmanaged replication group.
Do you want to setup an InnoDB Cluster based on this replication group? [Y/n]: y
Creating InnoDB Cluster 'MGR1' on '192.168.3.244:3306'...

Adding Seed Instance...
Adding Instance '192.168.3.245:3306'...
Adding Instance '192.168.3.246:3306'...
Adding Instance '192.168.3.244:3306'...
Resetting distributed recovery credentials across the cluster...
Dba.createCluster: Access denied; you need SYSTEM_VARIABLES_ADMIN and PERSIST_RO_VARIABLES_ADMIN privileges for this operation (MYSQLSH 3630)

szhjb88 发表于 2023-12-8 01:09
请问  用MySQL Shell接管MGR，是不是通过以下命令？

MySQL  localhost:33060+ ssl  JS > var c=dba.cre ...

mysql mysqlrouter --bootstrap root@192.168.3.244:3306 --user=mysqlrouter
Please enter MySQL password for root:
# Bootstrapping system MySQL Router instance...

- Creating account(s) (only those that are needed, if any)
- Verifying account (using it to run SQL queries that would be run by Router)
- Storing account in keyring
- Adjusting permissions of generated files
- Creating configuration /etc/mysqlrouter/mysqlrouter.conf

Existing configuration backed up to '/etc/mysqlrouter/mysqlrouter.conf.bak'

# MySQL Router configured for the InnoDB Cluster 'MGR1'

After this MySQL Router has been started with the generated configuration

    $ /etc/init.d/mysqlrouter restart
or
    $ systemctl start mysqlrouter
or
    $ mysqlrouter -c /etc/mysqlrouter/mysqlrouter.conf

InnoDB Cluster 'MGR1' can be reached by connecting to:

## MySQL Classic protocol

- Read/Write Connections: localhost:6446
- Read/Only Connections:  localhost:6447

## MySQL X protocol

- Read/Write Connections: localhost:6448
- Read/Only Connections:  localhost:6449

szhjb88 发表于 2023-12-8 01:09
请问  用MySQL Shell接管MGR，是不是通过以下命令？

MySQL  localhost:33060+ ssl  JS > var c=dba.cre ...

参考：https://mp.weixin.qq.com/s/fqI3GQjcHMBtRsUeG3AE8Q