ODP相关__all_dummy表我查询了下,都是空的,也只有一个字段?


ODP相关__all_dummy表我查询了下,都是空的,也只有一个字段?对于路由来说好像没有什么作用?

5798F6DC-A5AA-45cb-A017-B0074C30402E

2 个赞

我理解是指OBProxy查__all_virtual_proxy_schema表,不是直接查__all_dummy表

obclient [oceanbase]> select svr_ip,tenant_name,database_name,table_name,role from __all_virtual_proxy_schema where tenant_name='obmysql' and database_name='oceanbase' and table_name='__all_dummy';
+--------------+-------------+---------------+-------------+------+
| svr_ip       | tenant_name | database_name | table_name  | role |
+--------------+-------------+---------------+-------------+------+
| 10.186.61.29 | obmysql     | oceanbase     | __all_dummy |    1 |
| 10.186.61.30 | obmysql     | oceanbase     | __all_dummy |    2 |
+--------------+-------------+---------------+-------------+------+
2 rows in set (0.035 sec)
2 个赞

好的,谢谢了。差不多理解了。

1 个赞

用于演示显示observer

2 个赞

proxyschema表看看

2 个赞

:+1:

1 个赞