集群节点负载不均衡，是否正常

[AntTech_ZGW8AE]

ob：社区版4.3.5
部署方式：在3台ecs上各部署一个节点

刚才查看性能，发现从早上开始，第三个节点的cpu使用率就很低，其他两个是差不多的，
应用程序是通过obproxy连接这个集群的，会不会是转发到第三个节点的请求太少，
请问如何排查这种情况是否正常？

[甯空]

primary_zone是zone1,zone2;zone3这样的吗？

[AntTech_ZGW8AE]

是的

[mark2022]

@甯空

primary_zone

primary_zone 调整为random就可以了，请求默认是强一致性读，只会访问leader节点。

[淇铭]

查一下信息
SHOW VARIABLES like ‘version_comment’;
SELECT * FROM oceanbase.DBA_OB_TENANTS limit 10;

[AntTech_ZGW8AE]

@淇铭

SHOW VARIABLES like ‘version_comment’;

version:

OceanBase_CE 4.3.5.3 (r103000092025080818-e8da5f0afb288ed0add0613740c6ccf2a3c6830b) (Built Aug 8 2025 18:44:31)

DBA_OB_TENANTS输出：
dba_ob_tenants.txt (2.4 KB)

[AntTech_ZGW8AE]

今天能帮忙再看看吗？

[独善其身]

租户配置是用分号隔离的把

[旭辉]

三个节点主机配置一样吗？

[旭辉]

查下这个看下

SELECT/*+ PARALLEL(8)*/t2.zone, t1.svr_ip,  COUNT(*) AS QPS,  
      AVG(t1.elapsed_time), AVG(t1.queue_time)  
      FROM oceanbase.GV$OB_SQL_AUDIT t1, __all_server t2  
      WHERE t1.svr_ip = t2.svr_ip AND IS_EXECUTOR_RPC = 0    
      AND request_time > (time_to_usec(now()) - 1000000)    
      AND request_time < time_to_usec(now())
      GROUP BY t1.svr_ip  ORDER BY t2.zone;

[淇铭]

之前看你设置的primary_zone=zone1,zone2;zone3
看时间你修改过primary_zone=RANDOM

后面查看的信息 还是不均衡是么？按照楼上旭辉老师发的查一下信息

[AntTech_2IV55D]

三个节点的配置是一样的吗

[AntTech_ZGW8AE]

@旭辉

SELECT/*+ PARALLEL(8)*/t2.zone, t1.svr_ip,  COUNT(*) AS QPS,  
      AVG(t1.elapsed_time), AVG(t1.queue_time)  
      FROM oceanbase.GV$OB_SQL_AUDIT t1, __all_server t2  
      WHERE t1.svr_ip = t2.svr_ip AND IS_EXECUTOR_RPC = 0    
      AND request_time > (time_to_usec(now()) - 1000000)    
      AND request_time < time_to_usec(now())
      GROUP BY t1.svr_ip  ORDER BY t2.zone;

[AntTech_ZGW8AE]

还是node 3cpu低

[Sunshining]

学习一下高手们的经验

[Sunshining]

这样配置是不是大部分都到zone1和zone2了吧

[旭辉]

每隔2分钟查一次，查3次看下

[旭辉]

再查下这个

select tenant_id, zone, svr_ip, count(*) , ls_id,role
from cdb_ob_table_locations 
where table_type = 'user table' 
group by tenant_id, zone, svr_ip, ls_id,role;

[AntTech_ZGW8AE]

[旭辉]

查下这3个SQL

select svr_ip,count(*) from cdb_ob_ls_locations where role='LEADER' and ls_id>1 and tennat_id=1002 group by svr_ip;

select tenant_id, zone, svr_ip, count(*) from cdb_ob_table_locations where table_type = 'user table' group by tenant_id, zone, svr_ip;


select svr_ip,count(1) from cdb_ob_table_locations where tenant_id = 1002 and role = 'LEADER' group by svr_ip;