YashanDB的YCA认证学习安装部署YashanDB操作系统调整规划准备安装YashanDB卸载特性问题记录openssl版本不对导致安装失败学习体验YCA官方报名和课程配套PPT下载https://www.yashandb.com/YCA_courses个人版数据库、驱动及工具下载体验https://download.yashandb.com/download产品文档https://doc.yashandb.com/yashandb/23.2/zh/%E4%BA%A7%E5%93%81%E6%8F%8F%E8%BF%B0/%E4%BA%A7%E5%93%81%E7%AE%80%E4%BB%8B.html安装部署YashanDB主机环境CentOS 7.8.2003 Intel X86 8GB 2C 192.168.0.214操作系统调整ulimit-c unlimited echosoft core unlimited/etc/security/limits.conf echohard core unlimited/etc/security/limits.conf# 设置主机DNS域名解析hostnamectlset-hostname yanshan01 echo192.168.0.214 yanshan01/etc/hosts# 关闭透明大页echonever/sys/kernel/mm/transparent_hugepage/enabled echonever/sys/kernel/mm/transparent_hugepage/defrag# 调整交换分区在性能与稳定性避免OOM之间的选择sysctl-w vm.swappiness5echovm.swappiness5/etc/sysctl.conf# 调整自动分配本地端口范围sysctl-w net.ipv4.ip_local_port_range32768 60999echonet.ipv4.ip_local_port_range 32768 60999/etc/sysctl.conf# 调整进程的VMA上限sysctl-w vm.max_map_count2000000echovm.max_map_count2000000/etc/sysctl.conf# 使调整变量生效sysctl-p关闭防火墙和开机自启systemctl stop firewalld systemctldisablefirewalld规划准备安装YashanDB下载YashanDB个人版数据库# 创建YashanDB用户useradd yashan passwd yashan# 调整资源限制值cat/etc/security/limits.confEOF yashan soft nofile65536yashan hard nofile65536yashan soft nproc65536yashan hard nproc65536yashan soft rss unlimited yashan hard rss unlimited yashan soft stack8192yashan hard stack8192EOF# 上传下载的安装包到/tmp目录调整授权chown yashan.yashan/tmp/yashandb-personal-23.2.3.100-linux-x86_64.tar.gz# 切换到yashan用户操作解压安装包su-yashan mkdir/home/yashan/install/cd/home/yashan/install/mv/tmp/yashandb-personal-23.2.3.100-linux-x86_64.tar.gz.tar xzvf yashandb-personal-23.2.3.100-linux-x86_64.tar.gz采用命令行在服务端安装# 执行yasboot package命令生成配置文件./bin/yasboot package se gen--cluster yashandb -u yashan -p Test123 --ip 192.168.0.214 --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.3.100-linux-x86_64.tar.gz如果机器内存少于4GB可以添加 -f 强制安装跳过检查部署数据库./bin/yasboot cluster deploy-t yashandb.toml-d配置环境变量cd/home/yashan/yasdb_home/yashandb/23.2.3.100/conf/cat yashandb.bashrc~/.bashrc source~/.bashrc检查安装结果cd/home/yashan/install# 通过yasboot工具设置数据库sys用户的密码./bin/yasboot cluster passwordset-n Test#123 -c yashandb# 查看数据库状态./bin/yasboot clusterstatus-c yashandb-d-u sys-p Test#123# 查看实例状态./bin/yasbootsql-d sys/Test#123192.168.0.214:1688SELECTSTATUS,VERSION,STARTUP_TIME,INSTANCE_NAMEFROMV$INSTANCE;selectDATABASE_NAME,OPEN_MODE,STATUSfromv$database;实例启停# 关闭与开启yasboot cluster stop-c yashandb-p Test#123yasboot clusterstart-c yashandb-p Test#123卸载yasboot cluster clean--cluster yashandb --purgeyasboot package uninstall--cluster yashandb特性O记 有界计算DDL 默认自动提交DML 默认非自动提交退出连接时会触发隐式提交新版本yasboot操作需要带上密码SQLcreatetablet_test(idint,name varchar2(20));Succeed.SQLinsertintot_testvalues(1,ok);1rowaffected.SQLrollback;Succeed.SQLinsertintot_testvalues(2,OK);1rowaffected.SQLexit[yashanecs-gy001-0002~]$ yasbootsql-d yashan/yashan192.168.0.214:1688YashanDBSQLPersonal EditionRelease23.2.3.100x86_64 Connectedto: YashanDB Server Personal EditionRelease23.2.3.100x86_64-X8664bit LinuxSQLselect*fromt_test;ID NAME------------ ---------------------2OK1rowfetched.问题记录openssl版本不对导致安装失败openssl version下载1.1.1l版本安装https://openssl-library.org/source/github_openssl1.1.1l# 清理低版本opensslyum remove openssl yum remove openssl-devel# 下载1.1.1版本并编译安装wget https://openssl.org/source/old/1.1.1/openssl-1.1.1l.tar.gztar-xzvf openssl-1.1.1l.tar.gz cd openssl-1.1.1l./config--prefix/usr/local/opensslmake 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学习体验YCA培训流程很清晰但视频录播的是比较早的版本跟新版本的yashandb库差别比较大参考意义不大建议及时更新吧yashandb的“有界计算”还是挺不错的就还得看看实际案例如何了YCA认证考试流程还是挺规范的发现了一个前沿巨牛的宝藏人工智能学习网站通俗易懂风趣幽默忍不住给大家分享一下。戳一下跳转到学习