MySQL 8.0 MGR 迁移至 OceanBase 4.0 ，我遇到了5个问题

root@localhost:mysql_uatDB.sock [performance_schema]> create database db_oms_test ;--------------create database db_oms_test--------------Query OK, 1 row affected (0.01 sec)

root@localhost:mysql_uatDB.sock [performance_schema]> use db_oms_testDatabase changedroot@localhost:mysql_uatDB.sock [db_oms_test]> create table t_oms_tab(id int primary key, name varchar(200));--------------create table t_oms_tab(id int primary key, name varchar(200))--------------Query OK, 0 rows affected (0.01 sec)root@localhost:mysql_uatDB.sock [db_oms_test]> insert into t_oms_tab values (1,'mysql 8.0 to OB4.0 via OMS');--------------insert into t_oms_tab values (1,'mysql 8.0 to OB4.0 via OMS')--------------Query OK, 1 row affected (0.00 sec)root@localhost:mysql_uatDB.sock [db_oms_test]> commit;--------------commit--------------Query OK, 0 rows affected (0.00 sec)

root@localhost:mysql_uatDB.sock [performance_schema]> create user app_oms_test@'%' identified with mysql_native_password by '1234_abcD';--------------create user app_oms_test@'%' identified with mysql_native_password by '1234_abcD'--------------Query OK, 0 rows affected (0.01 sec)root@localhost:mysql_uatDB.sock [performance_schema]> grant all on db_oms_test.* to app_oms_test@'%';--------------grant all on db_oms_test.* to app_oms_test@'%'--------------Query OK, 0 rows affected (0.01 sec)root@localhost:mysql_uatDB.sock [db_oms_test]> GRANT REPLICATION CLIENT, REPLICATION SLAVE ON *.* TO   app_oms_test@'%' WITH GRANT OPTION;--------------GRANT REPLICATION CLIENT, REPLICATION SLAVE ON *.* TO   app_oms_test@'%' WITH GRANT OPTION--------------Query OK, 0 rows affected (0.01 sec)
root@localhost:mysql_uatDB.sock [db_oms_test]> create database drc;--------------create database drc--------------Query OK, 1 row affected (0.01 sec)root@localhost:mysql_uatDB.sock [db_oms_test]> grant all on drc.* to app_oms_test@'%';--------------grant all on drc.* to app_oms_test@'%'--------------Query OK, 0 rows affected (0.01 sec)

obclient [oceanbase]> CREATE resource unit mysqlunit max_cpu=2, min_cpu=1, MEMORY_SIZE='1G', min_iops=1024, LOG_DISK_SIZE='2G';Query OK, 0 rows affected (0.006 sec)

CREATE resource pool app_pool unit = 'mysqlunit', unit_num = 1, ZONE_LIST  = ('zone1','zone2','zone3');

CREATE TENANT IF NOT EXISTS tenant_mysql_test charset='utf8mb4', comment 'mysql tenant/instance', primary_zone='RANDOM', resource_pool_list = ('app_pool') set ob_tcp_invited_nodes = '%';

[oceanbase@whdrcsrv403 ~]$ obclient -h10.25.15.83 -P2881 -uroot@tenant_mysql_test -Doceanbase -AWelcome to the OceanBase.  Commands end with ; or \g.Your OceanBase connection id is 3221601564Server version: OceanBase_CE 4.0.0.0 (r100000272022110114-6af7f9ae79cd0ecbafd4b1b88e2886ccdba0c3be) (Built Nov  1 2022 14:57:18)

Copyright (c) 2000, 2018, OB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

obclient [oceanbase]> create user app_oms_account identified by "12345678";Query OK, 0 rows affected (0.137 sec)

obclient [oceanbase]> create database db_oms_test ;Query OK, 1 row affected (0.149 sec)

obclient [oceanbase]> grant all on *.* to app_oms_account;Query OK, 0 rows affected (0.062 sec)

# 动态更新 OMS 社区版容器可用 CPU 到 4C[root@whdrcsrv403 ~]# docker update 52dcc0486b89  --cpu-quota 40000052dcc0486b89

# 动态更新 OMS 社区版容器可用内存到 16G[root@whdrcsrv403 ~]# docker update 52dcc0486b89  --memory 16G --memory-swap 16G52dcc0486b89

[root@whdrcsrv403 ~]# docker restart 52dcc0486b8952dcc0486b89