oceanbase

1
## 功能: 获取指定租户的ip&port
2
# 1.最好使用前sleep下，否则tenant_schema有可能还未刷到server上导致连接不上
3
# 2.如果分布于多个server，取unit_id最小的
4
## 用法:
5
# 1.设置待连接的tenant_name
6
# 2.source本文件
7
# 3.connect
8
## 模板:
9
# sleep 3;
10
# let $__tenant_name__ = 'tt1';
11
# --source mysql_test/include/get_tenant_server.inc
12
# connect (conn1,$TE_SERVER_IP,root@tt1,,*NO-ONE*,$TE_SERVER_PORT);
13

14

15
--disable_query_log
16
--disable_result_log
17
connect (obsys,$OBMYSQL_MS0,admin,$OBMYSQL_PWD,test,$OBMYSQL_PORT);
18
connection obsys;
19
let $__tenant_id__  = `select tenant_id from oceanbase.__all_tenant where tenant_name = $__tenant_name__ limit 1`;
20
let $__resource_pool_id__ = `select resource_pool_id from oceanbase.__all_resource_pool where tenant_id = $__tenant_id__ limit 1`;
21

22
let $__svr_ip__ = `select svr_ip from oceanbase.__all_unit where resource_pool_id = $__resource_pool_id__ limit 1`;
23
let $__svr_port__ = `select svr_port from oceanbase.__all_unit where resource_pool_id = $__resource_pool_id__ limit 1`;
24

25
let $__inner_port__ = `select inner_port from oceanbase.__all_server where svr_ip = '$__svr_ip__' and svr_port = $__svr_port__ limit 1`;
26

27
let $TE_SERVER_IP = $__svr_ip__;
28
let $TE_SERVER_PORT = $__inner_port__;
29
disconnect obsys;
30
connection default;
31
--enable_query_log
32
--enable_result_log
33