【产品名称】
【产品版本】
【问题描述】
__all_server表的status状态表示observer进程是否活着,是否和RootService有正常心跳交互。
stop server操作仅表示observer不再对外提供服务,Leader会切走,obproxy也不再路由读写流量给该server。stop server成功后,用户可以安全kill进程。
stop server成功标志是__all_server表的stop_time字段是否为0,如果不等于0,表示stop成功,并且会记录stop时间;如果stop_time等于0表示没有stop。
SELECT DATE_FORMAT(gmt_create, '%b%d %H:%i:%s') gmt_create_ , module, event, name1, value1, name2, value2, rs_svr_ip,name3,value3,name4,value4,name5,value5 FROM __all_rootservice_event_history WHERE 1 = 1 -- AND module IN ('server') -- AND module NOT IN ('snapshot','ddl') -- and event not in ('finish_add_replica','start_add_replica') ORDER BY gmt_create DESC LIMIT 100;
select a.zone,concat(a.svr_ip,':',a.svr_port) observer, cpu_total, (cpu_total-cpu_assigned) cpu_free, round(mem_total/1024/1024/1024) mem_total_gb, round((mem_total-mem_assigned)/1024/1024/1024) mem_free_gb, usec_to_time(b.last_offline_time) last_offline_time, usec_to_time(b.start_service_time) start_service_time, b.status, usec_to_time(b.stop_time) stop_time, b.build_version from __all_virtual_server_stat a join __all_server b on (a.svr_ip=b.svr_ip and a.svr_port=b.svr_port) order by a.zone, a.svr_ip ;