崖山数据库安装详细教程

##安装前准备
netstat -anlp|grep 1688

#关闭防火墙
systemctl stop firewalld
systemctl disable firewalld

#系统参数配置
#关闭交换分区--调整自动分配本地窗口范围--调整进程的VMA上限
echo "vm.swappiness = 0">> /etc/sysctl.conf
echo "net.ipv4.ip_local_port_range = 32768 60999" >> /etc/sysctl.conf
echo "vm.max_map_count=2000000" >> /etc/sysctl.conf
sysctl -p

#资源配置
cat >> /etc/security/limits.conf << EOF
yashan soft nofile 65536
yashan hard nofile 65536
yashan soft nproc 65536
yashan hard nproc 65536
yashan soft rss unlimited
yashan hard rss unlimited
yashan soft stack 8192
yashan hard stack 8192
EOF

#添加用户及用户组
useradd yashan
echo "Asdf123." |passwd --stdin yashan
groupadd YASDBA
usermod -a -G YASDBA yashan

#配置sudo
chmod +w /etc/sudoers

cat >> /etc/sudoers << EOF
yashan ALL=(ALL)NOPASSWD:ALL
EOF

chmod -w /etc/sudoers

#创建数据目录
mkdir -p /data/yashan
chown -R yashan:yashan /data/yashan

##安装(使用yashan用户)
mkdir install
cd install
tar -zxf yashandb-personal-23.2.1.100-linux-x86_64.tar.gz

./bin/yasboot package se gen --cluster yashandb -u yashan -p Asdf123. --ip 172.22.92.232 --port 22 --install-path /data/yashan/yasdb_home --data-path /data/yashan/yasdb_data --begin-port 1688

./bin/yasboot package install -t hosts.toml -i yashandb-personal-23.2.1.100-linux-x86_64.tar.gz

./bin/yasboot cluster deploy -t yashandb.toml

cd /data/yashan/yasdb_home/yashandb/23.2.1.100/conf/
source yashandb.bashrc
cat yashandb.bashrc >> ~/.bashrc

yasboot cluster password set -n yasdb_123 -c yashandb
yasql / as sysdba

#关闭与开启
yasboot cluster stop -c yashandb
yasboot cluster start -c yashandb

#卸载
yasboot cluster clean --cluster yashandb --purge
yasboot package uninstall --cluster yashandb
清理环境变量