YashanDB 23.2.3安装过程，并使用DBeaver进行连接

Yashandb安装

环境准备

虚拟机环境说明

虚拟机系统：centos 7.9，2c，8g，100GB；内存至少4G+，否则无法安装；
安装用户：yashan
软件目录：/app/install
安装目录：/app/yasdb_home
数据目录：/app/yasdb_data

修改主机名称

hostnamectl set-hostname yashan && bash

依赖项确认–openssl版本

openssl version

OpenSSL 1.0.2k-fips 26 Jan 2017 --版本必须要1.1以上

find / -name openssl mv /usr/bin/openssl /usr/bin/openssl_old 
mv /usr/lib64/openssl/ /usr/lib64/openssl_old

安装openssl-1.1.1

$ tar xzf openssl-1.1.1l.tar.gz 
$ cd openssl-1.1.1l/ 
$ ./config --prefix=/usr/local/openssl 
$ make && make install 
$ ln -s /usr/local/openssl/bin/openssl /usr/bin/openssl 
$ ln -s /usr/local/openssl/include/openssl/ /usr/include/openssl 
$ echo "/usr/local/openssl/lib/" >> /etc/ld.so.conf

$ ldconfig -v 
$ openssl version -a

系统环境配置

系统参数配置

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

关闭防火墙

systemctl stop firewalld 
systemctl disable firewalld

添加用户及用户组

useradd yashan 
echo "Asdf123." |passwd --stdin yashan
groupadd YASDBA
usermod -a -G YASDBA yashan

创建目录并授权

mkdir -p /app/yasdb_home
mkdir -p /app/yasdb_data
mkdir -p /app/install
chown -R yashan:yashan /app

配置sudo

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

执行安装

上传安装包到install目录并解压：yashandb-personal-23.2.3.100-linux-x86_64.tar.gz

su yashan

tar -zxf yashandb-personal-23.2.3.100-linux-x86_64.tar.gz

生成参数文件

[yashan@yashan install]$ ./bin/yasboot package se gen --cluster yashandb -u yashan -p Asdf123. --ip 192.168.50.183 --port 22 --install-path /app/yasdb_home  --data-path /app/yasdb_data --begin-port 1688
host host0001 openssl version: OpenSSL 1.1.1l  24 Aug 2021
OpenSSL version is 1.1.1 or greater
192.168.50.183ip:192.168.50.183 memory is less than 4096MB   --我这里的内存是4G，安装失败，后面改成8G安装就可以了。hostid   | group | node_type | node_name | listen_addr         | replication_addr    | data_path
--------------------------------------------------------------------------------------------------------host0001 | dbg1  | db        | 1-1       | 192.168.50.183:1688 | 192.168.50.183:1689 | /app/yasdb_data
----------+-------+-----------+-----------+---------------------+---------------------+-----------------Generate config success

执行安装

yashandb-personal-23.1.1.100-linux-x86_64.tar.gz

[yashan@yashan install]$ ./bin/yasboot package install -t hosts.toml -i yashandb-personal-23.2.3.100-linux-x86_64.tar.gz                                       host host0001 openssl version: OpenSSL 1.1.1l  24 Aug 2021
OpenSSL version is 1.1.1 or greater
checking install package...
install version: yashandb 23.2.3.100
host0001 100% [====================================================================]  1m0s
update host to yasom...

执行部署

[yashan@yashan install]$ ./bin/yasboot cluster deploy -t yashandb.tomltype | uuid             | name               | hostid | index    | status  | return_code | progress | cost
------------------------------------------------------------------------------------------------------------task | 24ef82d552d93233 | DeployYasdbCluster | -      | yashandb | SUCCESS | 0           | 100      | 138
------+------------------+--------------------+--------+----------+---------+-------------+----------+------
task completed, status: SUCCESS

配置环境变量：

[yashan@yashan install]$ cd /app/yasdb_home/yashandb/23.2.3.100/conf/[yashan@yashan conf]$  cat yashandb.bashrc   -- 不用改变export YASDB_HOME=/app/yasdb_home/yashandb/23.2.3.100export PATH=${YASDB_HOME}/bin:$PATHexport LD_LIBRARY_PATH=${YASDB_HOME}/lib:$LD_LIBRARY_PATHif command -v rlwrap >/dev/null 2>&1; thenalias yasql="rlwrap yasql"fiexport YASDB_DATA=/app/yasdb_data/db-1-1
---------------------------------------------------------------------[yashan@yashan conf]$  cat yashandb.bashrc >> ~/.bashrc
[yashan@yashan conf]$ source ~/.bashrc
[yashan@yashan conf]$ env|grep YASYASDB_HOME=/app/yasdb_home/yashandb/23.2.3.100YASDB_DATA=/app/yasdb_data/db-1-1

或者直接执行下面这个，配置环境变量
cd /app/yasdb_home/yashandb/23.2.3.100/conf/
source yashandb.bashrc
cat yashandb.bashrc >> ~/.bashrc

设置sys用户密码：

至少8位，至少包含1个特殊字符，好像没有限制大写字母

[yashan@yashan instance]$ yasboot cluster password set -n yasdb_123 -c yashandbtype | uuid             | name             | hostid | index    | status  | return_code | progress | cost
----------------------------------------------------------------------------------------------------------task | 956c8f977ef3ef86 | YasdbPasswordSet | -      | yashandb | SUCCESS | 0           | 100      | 2
------+------------------+------------------+--------+----------+---------+-------------+----------+------
task completed, status: SUCCESS

使用YasBoot查看YashanDB数据库状态，显示以下信息表示安装成功

[yashan@yashan instance]$ yasboot cluster status -c yashandbhost_id  | node_type | nodeid | pid
--------------------------------------host0001 | db        | 1-1:1  | 7590
----------+-----------+--------+------

登陆验证，显示以下信息表示登陆成功

[yashan@yashan instance]$ yasql sys/yasdb_123
YashanDB SQL Personal Edition Release 23.2.3.100 x86_64Connected to:
YashanDB Server Personal Edition Release 23.2.3.100 x86_64 - X86 64bit LinuxSQL>
SQL> select database_name,open_mode from v$database;DATABASE_NAME                                                    OPEN_MODE
---------------------------------------------------------------- -----------------
yashandb                                                         READ_WRITE1 row fetched.SQL> select instance_name,status from v$instance;INSTANCE_NAME                                                    STATUS
---------------------------------------------------------------- -------------
yasdb                                                            OPEN1 row fetched.

关闭与开启

yasboot cluster stop -c yashandbyasboot cluster start -c yashandb

卸载

yasboot cluster clean --cluster yashandb --purgeyasboot package uninstall --cluster yashandb

清理环境变量

使用图形工具连接数据库

添加yanshandb驱动器：

下载崖山数据库的驱动包（官网或者文末网盘）：

连接数据库，测试成功。

通过百度网盘分享的文件：Yashandb 23.2.3.100 （openssl-1.1.1l.tar.gz、yashandb-personal-23.2.3.100-linux-x86_64.tar.gz、yashandb-jdbc-1.6.9.jar）
链接：https://pan.baidu.com/s/1v9NJe5QIj0RqWnI-FmVTRA
提取码：9p4y