odp

 

sudo rpm -ivh obproxy-3.2.0-1.el7.x86_64.rpm

sudo rpm -ivh libobclient-2.0.0-2.el7.x86_64.rpm
sudo rpm -ivh obclient-2.0.0-2.el7.x86_64.rpm 

 

cd /home/admin/obproxy-3.2.0 && bin/obproxy -r '10.6.144.167:2881;10.6.144.168:2881;10.6.144.169:2881' -p 3306 -o 'enable_strict_kernel_release=false,enable_cluster_checkout=false,enable_metadb_used=false' -c cluster_1

obclient -h 10.6.144.166 -uroot@proxysys -P3306 -p
alter proxyconfig set obproxy_sys_password='proxyPas5w@rd';
alter proxyconfig set observer_sys_password='proxyRoPas5W@rd';

obclient -h 10.6.144.166 -uroot@proxysys -P3306 -pproxyPas5w@rd

 

#observer 

for ip in 10.6.144.1{67..69};do echo $ip; obclient -h $ip -uroot -p -P2881;done
grant select on oceanbase.* to proxro identified by 'proxyRoPas5W@rd';

 

obclient -h 127.0.0.1 -uroot@sys#cluster_1 -P3306 -p -c -A oceanbase