展示proxy binary信息

    使用show proxyinfo binary语句：

    • 展示proxy binary信息， 包括version、build相关、MD5相关等任何信息，富文本展示。
    • 该命令从proxy 1.1.0版本开始支持。

    示例：

    1. mysql> show proxyinfo binary\G
    2. *************************** 1. row ***************************
    3. name: binary info
    4. info: ObProxy-OceanBase 1.1.0-
    5. version:VERSION_6U
    6. MD5:
    7. REVISION:190-local-4371bcb798866c0b798bb4e308a1aaa67928ff4a
    8. BUILD_TIME:Jul 25 2016 16:05:01
    9. BUILD_FLAGS:-D__STDC_LIMIT_MACROS -D_OB_VERSION=1000 -D__STDC_CONSTANT_MACROS -D_NO_EXCEPTION -g -Wall -Werror -Wextra -Wunused-parameter -Wformat -Wconversion -Wno-invalid-offsetof -Wno-deprecated -fno-strict-aliasing -fno-omit-frame-pointer -mtune=generic -Wno-psabi -Wno-sign-compare -DGCC_52 -DSUPPORT_SSE4_2 -DHAVE_SCHED_GETCPU -DHAVE_REALTIME_COARSE -DOB_HAVE_EVENTFD -DHAVE_FALLOCATE -DHAVE_MINIDUMP
    10. 1 row in set (0.00 sec)

    展示proxy 自身运行/升级相关信息

    使用show proxyinfo upgrade语句：

    • 展示proxy 自身运行/升级相关信息，富文本展示。
    • 该命令从proxy 1.1.0版本开始支持

    示例：

    1. mysql> show proxyinfo upgrade\G
    2. *************************** 1. row ***************************
    3. name: hot upgrade info
    4. info: {is_inited:true, proxy_port:13205, proxy_ip:"10.125.111.18", 
    5. is_self_md5_available:false, proxy_self_md5:"", upgrade_failures:0, check_available_failures:0, is_timeout_rollback:false, timeout_rollback_timeout_at:0,  wait_cr_finish_timeout_at:0, is_self_binary:false, 
    6. last_new_binary_name:"", last_new_binary_md5:"", cmd:"", hu_cont:NULL, 
    7. mysql_proxy:{this:0x1107a750, is_inited:true, stop:false, is_raw_execute:false, timeout_ms:5000, 
    8. client_pool:{this:0x7fd04d55d280, is_inited:true, stop:false, mc_count:1, cluster_resource:0x7fd04d5a5f80}, 
    9. raw_mysql_client:{is_inited:true, info:{has_passwd_scrambled:false, user_name:"admin", database_name:"oceanbase", request_sql:""}, svr_addr_[0]="0.0.0.0", svr_addr_[1]="0.0.0.0", svr_addr_[2]="0.0.0.0"}}, 
    10. info:{is_inherited:false, upgrade_version:0, need_conn_accept:true, user_rejected:0, fd:23, sub_pid:-1, graceful_exit_end_time:0, graceful_exit_start_time:0, active_client_vc_count:-1, local_addr:"10.125.224.18:13205", rc_status:"", 
    11. hu_cmd:"", state:"HU_STATE_WAIT_HU_CMD", hu_status:"", is_parent:true, sub_status:"", last_parent_status:"", last_sub_status:"", 
    12. upgrade_version_buf:"", argc:1, argv[0]="./bin/obproxy", inherited_argv[0]="./bin/obproxy", inherited_argv[1]="(null)", inherited_argv[2]="(null)", inherited_argv[3]="(null)"}}
    13. 1 row in set (0.00 sec)

    展示proxy idc匹配信息

    使用show proxyinfo idc语句：

    • 展示proxy idc匹配信息， 包括idc name, 同idc/同region/不同region的zone, 匹配模式，富文本展示。
    • 该命令从proxy 1.3.0版本开始支持。

    示例：

    1. mysql> show proxyinfo idc;
    2. +-----------------+--------------+----------------+--------------+--------------+-------------+--------------+
    3. | global_idc_name | cluster_name | match_type     | regions_name | same_idc     | same_region | other_region |
    4. +-----------------+--------------+----------------+--------------+--------------+-------------+--------------+
    5. | idc1            | MetaDataBase | MATCHED_BY_IDC | ["HZ"]       | ["z1", "z2"] | []          | ["z3", "z4"] |
    6. +-----------------+--------------+----------------+--------------+--------------+-------------+--------------+
    7. 1 row in set (0.04 sec)