描述

    • show proxycluster [like 'xx']语句

    • 展示指定cluster的rs list详细信息(包括meta_db_cluster)，支持like模糊匹配(支持’%’和’_‘的匹配)

    • show proxycluster idc [like 'xx']语句

    • 展示指定cluster的idc list详细信息(包括meta_db_cluster)，支持like模糊匹配(支持’%’和’_‘的匹配)

    示例

    1. OceanBase (root@oceanbase)> show proxycluster;
    2. +-----------------+--------------------------------------------------------------------------------+-------------------+--------+
    3. | cluster_name    | rs_url                                                                         | root_addr         | role   |
    4. +-----------------+--------------------------------------------------------------------------------+-------------------+--------+
    5. | ob1.jianhua.sjh | http://10.111.4.23:8080/oceanbase_obconfig/ob1.jianhua.sjh.10.125.111.4.rslist | 10.244.4.27:13203 | leader |
    6. | MetaDataBase    | http://10.111.4.23:8080/oceanbase_obconfig/ob1.jianhua.sjh.10.125.111.4.rslist | 10.244.4.27:13203 | leader |
    7. +-----------------+--------------------------------------------------------------------------------+-------------------+--------+
    8. 2 rows in set (0.00 sec)
    10. OceanBase (root@oceanbase)> show proxycluster like "%ob1%";
    11. +-----------------+--------------------------------------------------------------------------------+-------------------+--------+
    12. | cluster_name    | rs_url                                                                         | root_addr         | role   |
    13. +-----------------+--------------------------------------------------------------------------------+-------------------+--------+
    14. | ob1.jianhua.sjh | http://10.111.4.23:8080/oceanbase_obconfig/ob1.jianhua.sjh.10.125.111.4.rslist | 10.111.4.27:13203 | leader |
    15. +-----------------+--------------------------------------------------------------------------------+-------------------+--------+
    16. 1 row in set (0.00 sec)
    1. mysql> show proxycluster;
    2. +--------------+------------+--------------------------------------------------------------------------+-------------------+----------+
    3. | cluster_name | cluster_id | rs_url                                                                   | root_addr         | role     |
    4. +--------------+------------+--------------------------------------------------------------------------+-------------------+----------+
    5. | ob1.schema   |          1 | http://10.111.4.23:8080/oceanbase_obconfig/obtest_schema_10.111.4.50_ob1 | 10.111.4.62:42000 | leader   |
    6. | ob1.schema   |          1 | http://10.111.4.23:8080/oceanbase_obconfig/obtest_schema_10.111.4.50_ob1 | 10.111.4.38:42000 | follower |
    7. | ob1.schema   |          1 | http://10.111.4.23:8080/oceanbase_obconfig/obtest_schema_10.111.4.50_ob1 | 10.111.14.1:42000 | follower |
    8. | MetaDataBase |          1 | http://10.111.4.23:8080/oceanbase_obconfig/obtest_schema_10.111.4.50_ob1 | 10.111.14.1:42000 | follower |
    9. +--------------+------------+--------------------------------------------------------------------------+-------------------+----------+
    10. 4 rows in set (0.00 sec)
    12. mysql> show proxycluster idc;
    13. +--------------+------------+-----------------------------------------------------------------------------------+------+--------+
    14. | cluster_name | cluster_id | idc_url                                                                           | idc  | region |
    15. +--------------+------------+-----------------------------------------------------------------------------------+------+--------+
    16. | ob1.schema   |          1 | http://10.111.4.23:8080/oceanbase_obconfig/obtest_schema_10.111.4.50_ob1_idc_list |      |        |
    17. | MetaDataBase |          1 | http://10.111.4.23:8080/oceanbase_obconfig/obtest_schema_10.111.4.50_ob1_idc_list |      |        |
    18. +--------------+------------+-----------------------------------------------------------------------------------+------+--------+
    19. 2 rows in set (0.00 sec)
    21. mysql> show proxycluster idc like 'ob1.schema';
    22. +--------------+------------+-----------------------------------------------------------------------------------+------+--------+
    23. | cluster_name | cluster_id | idc_url                                                                           | idc  | region |
    24. +--------------+------------+-----------------------------------------------------------------------------------+------+--------+
    25. | ob1.schema   |          1 | http://10.111.4.23:8080/oceanbase_obconfig/obtest_schema_10.111.4.50_ob1_idc_list |      |        |
    26. +--------------+------------+-----------------------------------------------------------------------------------+------+--------+
    27. 1 row in set (0.00 sec)