openkylin安装yashan数据库
崖山数据库是国产数据库的佼佼者,openkylin是国产操作系统的知名品牌,当两者结合在一起,会碰出怎样的火花呢?我们期待着各种国产软件能够完美的互相协作。
下面,我记录下我在openkylin上安装yashan数据库的过程,以供有需要的朋友参考:
安装基础工具
这部分不是安装yashan数据库所必须的,仅仅是一些为了方便使用而预先安装的工具包,读者可以有选择的安装或跳过本节。
#openssh:
sudo apt install openssh-server
安装依赖
openssl1.1.1。由于该版本相对较低,openkylin软件源仓库中没有集成。我们可以通过编译源代码来手动安装,步骤如下:
#下载源代码
wget https://www.openssl.org/source/openssl-1.1.1i.tar.gz
#编译
tar xvzf openssl-1.1.1l.tar.gz
cd openssl-1.1.1l/
./config --prefix=/usr/local/openssl
make -j4
sudo make install
修改默认配置
sudo useradd yashan
sudo passwd yashan
sudo visudo
sudo mkdir -p /data/yashan
sudo chown -R yashan:root /data/yashan/
sudo groupadd YASDBA
sudo usermod -a -G YASDBA yashan
sudo mkdir /home/yashan
sudo chown yashan:yashan /home/yashan
#切换到yashan用户
su - yashan
#编写.bashrc
cat ~/.bashrc
export PATH="/usr/local/openssl/bin:$PATH"
alias ll="ls -l"
安装yashanDB
#切换到yashan用户
su - yashan
#规划安装路径
/home/yashan/install:软件包上传目录。
/home/yashan/yasdb_home:软件安装目录,即$YASDB_HOME。包含YashanDB所提供的命令、数据库运行所需的库及各关键组件。
/home/yashan/yasdb_data:数据目录,即$YASDB_DATA。包含数据库的各类系统数据文件、部分日志文件和配置文件,用户数据也缺省存储在该目录下
mkdir /home/yashan/install /home/yashan/yasdb_home /home/yashan/yasdb_data
cd ~/install
#下载yashanDB个人版
wget https://linked.yashandb.com/upload1010/yashandb-personal-23.2.4.100-linux-x86_64.tar.gz
tar xvf yashandb-personal-23.2.4.100-linux-x86_64.tar.gz
#查看本机ip
ifconfig
docker0: flags=4099<UP,BROADCAST,MULTICAST> mtu 1500
inet 172.17.0.1 netmask 255.255.0.0 broadcast 172.17.255.255
ether 02:42:2a:4b:94:6b txqueuelen 0 (以太网)
RX packets 0 bytes 0 (0.0 B)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 0 bytes 0 (0.0 B)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
ens33: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 192.168.174.130 netmask 255.255.255.0 broadcast 192.168.174.255
inet6 fe80::8ac8:a9f8:8328:8aa6 prefixlen 64 scopeid 0x20<link>
ether 00:0c:29:3e:c0:f9 txqueuelen 1000 (以太网)
RX packets 184107 bytes 253956938 (253.9 MB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 98599 bytes 7228911 (7.2 MB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
lo: flags=73<UP,LOOPBACK,RUNNING> mtu 65536
inet 127.0.0.1 netmask 255.0.0.0
inet6 ::1 prefixlen 128 scopeid 0x10<host>
loop txqueuelen 1000 (本地环回)
RX packets 1601 bytes 173857 (173.8 KB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 1601 bytes 173857 (173.8 KB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
#根据实际情况选择网卡接口的ip键入如下命令以生成配置文件:
./bin/yasboot package se gen --cluster yashandb -u yashan -p qwer1234 --ip 192.168.174.130 --port 22 --install-path /home/yashan/yasdb_home --data-path /home/yashan/yasdb_data --begin-port 1688
#执行安装
./bin/yasboot package install -t hosts.toml -i yashandb-personal-23.2.4.100-linux-x86_64.tar.gz
./bin/yasboot cluster deploy -t yashandb.toml
#检查下进程
ps -edf|grep yasha
cd yasdb_home/yashandb/23.2.4.100/
source conf/yashandb.bashrc
cat conf/yashandb.bashrc >> ~/.bashrc
set -n yasdb_123 -c yashandb
yasboot cluster password set -n yasdb_123 -c yashandb
./bin/yasql / as sysdba
当重启系统后再次启动:
120 yasboot process yasom start -c yashandb
121 yasboot process yasagent start -c yashandb
122 yasboot cluster status -c yashandb
123 yasboot cluster start -c yashandb
参考网页:
浙公网安备 33010602011771号