oceanbase

echo 1048576 > /proc/sys/fs/file-max && ulimit -HSn 1048576
echo '* hard nofile 655350'>>/etc/security/limits.conf
echo '* soft nofile 655350'>>/etc/security/limits.conf
echo 'fs.file-max=1048576'>>/etc/sysctl.conf
echo 'fs.aio-max-nr=1048576'>/etc/sysctl.conf
echo 'net.nf_conntrack_max=1048576'>>/etc/sysctl.conf
echo 'net.netfilter.nf_conntrack_max=1048576'>>/etc/sysctl.conf


 useradd admin
 passwd admin
 echo '%admin ALL=(ALL) NOPASSWD: ALL'>/etc/sudoers.d/admin


#https://www.oceanbase.com/softwarecenter
wget https://obbusiness-private.oss-cn-shanghai.aliyuncs.com/download-center/opensource/oceanbase-all-in-one/7/x86_64/oceanbase-all-in-one-4.0.0.0-100120230113164218.el7.x86_64.tar.gz
tar -zxf oceanbase-all-in-one-4.*.el7.x86_64.tar.gz
sh oceanbase-all-in-one/bin/install.sh
source ~/.oceanbase-all-in-one/bin/env.sh
obd demo
obclient -h127.0.0.1 -P2881 -uroot

#

set password=password('mima');
SHOW VARIABLES LIKE 'ob_tcp_invited_nodes';
set global ob_tcp_invited_nodes= '%.%.%.%';

use oceanbase;
create resource unit qbit max_cpu 1,memory_size '2G';
create resource pool qbit unit='qbit',unit_num=1,zone_list=('zone1');
create tenant qbit resource_pool_list=('qbit'),primary_zone='zone1';
exit;

yum-config-manager --add-repo https://mirrors.aliyun.com/oceanbase/OceanBase.repo

sudo yum install oblogproxy -y
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/home/admin/oblogproxy/liboblog/
// error while loading shared libraries: libobcdc.so.4: cannot open shared object file: No such file or directory
// locate libobcdc
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/home/admin/oceanbase/lib64/
// locate libmariadb
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/home/admin/oceanbase/lib/
cd /home/admin
./oblogproxy/bin/logproxy -x root
8D472B19E6E96BC69ABE8070031BC534
./oblogproxy/bin/logproxy -x mima
3C1387B4A46F2F41AC9FE77F028469E0
./oblogproxy/bin/logproxy -x root |xargs -I {} sed -i 's/"ob_sys_username": "",/"ob_sys_username": "{}",/g' ./oblogproxy/conf/conf.json
./oblogproxy/bin/logproxy -x mima |xargs -I {} sed -i 's/"ob_sys_password": "",/"ob_sys_password": "{}",/g' ./oblogproxy/conf/conf.json