【 使用环境 】 测试环境
【 OB or 其他组件 】
【 使用版本 】(OceanBase 4.3.2.0 26)
链接语句
obclient -h172.25.xxx.xxx -P2883 -uroot@proxysys -p’upKUrln1V4’ -Doceanbase -A
进入后 查看数据是这个结果，不能创建数据库也不能，创建表
obclient [oceanbase]> show databases;
±-------------------------±------------------+
| Variable_name | Value |
±-------------------------±------------------+
| tx_isolation | READ-COMMITTED |
| system_time_zone | +08:00 |
| time_zone | +08:00 |
| character_set_server | utf8mb4 |
| character_set_client | utf8mb4 |
| interactive_timeout | 28800 |
| query_cache_size | 1048576 |
| character_set_results | utf8mb4 |
| max_allowed_packet | 4194304 |
| sql_mode | STRICT_ALL_TABLES |
| net_buffer_length | 16384 |
| wait_timeout | 28800 |
| lower_case_table_names | 2 |
| query_cache_type | OFF |
| init_connect | |
| transaction_isolation | READ |
| character_set_connection | utf8mb4 |
| net_write_timeout | 60 |
±-------------------------±------------------+
18 rows in set (0.002 sec)
数据库状态 正常
[root@minio2 obproxy]# obd cluster list
±-----------------------------------------------------------+
| Cluster List |
±----------±-----------------------------±----------------+
| Name | Configuration Path | Status (Cached) |
±----------±-----------------------------±----------------+
| demo | /root/.obd/cluster/demo | deployed |
| obcluster | /root/.obd/cluster/obcluster | running |
±----------±-----------------------------±----------------+
Trace ID: 1b960628-aae3-11ef-b84a-0894ef66c3b2
If you want to view detailed obd logs, please run: obd display-trace 1b960628-aae3-11ef-b84a-0894ef66c3b2
配置文件obproxy-only.yaml 如下所示
obproxy-ce:
servers:
- 172.25.xxxx.xxx
global:
listen_port: 2883 # External port. The default value is 2883.
prometheus_listen_port: 2884 # The Prometheus port. The default value is 2884.
rpc_listen_port: 2885
enable_obproxy_rpc_service: true
home_path: /opt/obproxy
obproxy_config_server_url: http://172.25.xxxx.xxxx:8080/services?Action=GetObProxyConfig
enable_cluster_checkout: false
cluster_name: obcluster
skip_proxy_sys_private_check: true
enable_strict_kernel_release: false
proxy_id: 1