暂无图片
暂无图片
1
暂无图片
暂无图片
暂无图片

YashanDB 23.1.1.200 共享集群安装步骤

原创 Skye 2023-12-26
341

1. 系统环境

1.1 系统拓扑

  1. 共享集群模式由两台实例组成;
  2. 测试环境集群配置了两块网卡,但是崖山共享集群只需使用一块网卡。

1.2 硬件资源说明

image.png

[root@yasrac01 ~]# lsblk NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT sda 8:0 0 200G 0 disk ├─sda1 8:1 0 1G 0 part /boot └─sda2 8:2 0 199G 0 part ├─centos-root 253:0 0 50G 0 lvm / ├─centos-swap 253:1 0 7.9G 0 lvm [SWAP] └─centos-home 253:2 0 141.1G 0 lvm /home sdb 8:16 0 2G 0 disk sdc 8:32 0 2G 0 disk sdd 8:48 0 30G 0 disk sr0 11:0 1 4.4G 0 rom [root@yasrac02 ~]# lsblk NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT sda 8:0 0 200G 0 disk ├─sda1 8:1 0 1G 0 part /boot └─sda2 8:2 0 199G 0 part ├─centos-root 253:0 0 50G 0 lvm / ├─centos-swap 253:1 0 7.9G 0 lvm [SWAP] └─centos-home 253:2 0 141.1G 0 lvm /home sdb 8:16 0 2G 0 disk sdc 8:32 0 2G 0 disk sdd 8:48 0 30G 0 disk sr0 11:0 1 4.4G 0 rom
复制

1.3 软件资源说明

操作系统:CentOS Linux release 7.9.2009 (Core)
数据库软件:YashanDB Server Enterprise Edition Release 23.1.1.200 x86_64

两个节点一样。

2. 系统规划

2.1 数据库系统安装规划

image.png

这里跟Oracle很大差异,没有VIP、scan ip和独立网段的private ip。

3. 安装前准备

3.1 检查操作系统版本

[root@yasrac01 ~]# cat /etc/redhat-release CentOS Linux release 7.9.2009 (Core)
复制

3.2 检查物理内存容量

[root@yasrac01 ~]# free -g total used free shared buff/cache available Mem: 7 0 7 0 0 7 Swap: 7 0 7
复制

3.3 检查系统架构

[root@yasrac01 ~]# uname -a Linux yasrac01 3.10.0-1160.el7.x86_64 #1 SMP Mon Oct 19 16:18:59 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux
复制

3.4 配置内核参数

以root用户身份在所有集群主机节点上执行如下命令:

sysctl -w vm.swappiness=0 sysctl -w net.ipv4.ip_local_port_range='32768 60999' sysctl -w vm.max_map_count=2000000 cat >> /etc/sysctl.conf << EOF vm.swappiness=0 net.ipv4.ip_local_port_range=32768 60999 vm.max_map_count=2000000 EOF sysctl -p
复制

3.5 配置资源限制

以root用户身份在所有集群主机节点上执行如下命令:

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
复制

这里的yashan用户是集群使用的系统用户,按实际情况调整。

3.6 关闭透明大页

以root用户身份在所有集群主机节点上执行如下命令:

1. cat /sys/kernel/mm/transparent_hugepage/enabled 2. vi /etc/default/grub 在 GRUB_CMDLINE_LINUX 中添加或修改参数 transparent_hugepage=never 3. cat /sys/kernel/mm/transparent_hugepage/enabled 4. grub2-mkconfig -o /boot/grub2/grub.cfg 5. cat /sys/kernel/mm/transparent_hugepage/enabled 6. init 6 7. cat /sys/kernel/mm/transparent_hugepage/enabled
复制

实操步骤参考

-----实操步骤样例---- #1.查看 [root@yasrac01 ~]# cat /sys/kernel/mm/transparent_hugepage/enabled [always] madvise never #--若显示[always] madvise never,则说明透明大页开启。 #--若显示always madvise [never],则说明透明大页关闭。 #2.修改 [root@yasrac01 ~]# vi /etc/default/grub #3.查看 [root@yasrac01 ~]# cat /etc/default/grub GRUB_TIMEOUT=5 GRUB_DISTRIBUTOR="$(sed 's, release .*$,,g' /etc/system-release)" GRUB_DEFAULT=saved GRUB_DISABLE_SUBMENU=true GRUB_TERMINAL_OUTPUT="console" GRUB_CMDLINE_LINUX="crashkernel=auto rd.lvm.lv=centos/root rd.lvm.lv=centos/swap rhgb quiet transparent_hugepage=never" GRUB_DISABLE_RECOVERY="true" #4.指令重新配置 grub.cfg [root@yasrac01 ~]# grub2-mkconfig -o /boot/grub2/grub.cfg Generating grub configuration file ... Found linux image: /boot/vmlinuz-3.10.0-1160.el7.x86_64 Found initrd image: /boot/initramfs-3.10.0-1160.el7.x86_64.img Found linux image: /boot/vmlinuz-0-rescue-6e33d7c660524569848200f1a6500fa1 Found initrd image: /boot/initramfs-0-rescue-6e33d7c660524569848200f1a6500fa1.img done #5.查看 [root@yasrac01 ~]# cat /sys/kernel/mm/transparent_hugepage/enabled [always] madvise never #6.重启 [root@yasrac01 ~]# init 6 Connection closing...Socket close. Connection closed by foreign host. Disconnected from remote host(192.168.33.111 yas-rac01) at 17:05:06. Type `help' to learn how to use Xshell prompt. [C:\~]$ Connecting to 192.168.33.111:22... Connection established. To escape to local shell, press 'Ctrl+Alt+]'. WARNING! The remote SSH server rejected X11 forwarding request. Last login: Wed Dec 20 16:48:00 2023 from 192.168.130.21 #7.查看 [root@yasrac01 ~]# cat /sys/kernel/mm/transparent_hugepage/enabled always madvise [never]
复制

image.png

3.7 关闭防火墙

以root用户身份在所有集群主机节点上执行如下命令:

systemctl stop firewalld systemctl disable firewalld systemctl status firewalld
复制

3.8 创建用户及用户组

以root用户身份在所有集群主机节点上执行如下命令:

3.8.1 创建yashan用户及YASDBA组

groupadd YASDBA useradd -d /home/yashan -G YASDBA -m yashan echo "yashan" |passwd --stdin yashan
复制

echo "yashan"是给yashan用户设置的密码为yashan,可以自定义密码。

3.9 配置共享存储

以root用户身份在所有集群主机节点上执行如下命令:

#获取共享磁盘scsi_id [root@yasrac01 ~]# for i in {b..d}; do echo "sd$i" "`/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i` "; done sdb 36000c2998ba97b791417a905aa504ecc sdc 36000c29bfaa52387f836611169fd042b sdd 36000c29d1699cb57b26f05bdf88a622c #根据获取id,按需填写,注意RESULT对应id和SYMLINK绑定的盘的关系 [root@yasrac02 ~]# cat /etc/udev/rules.d/yashan-device-rule.rules KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36000c29d1699cb57b26f05bdf88a622c", SYMLINK+="yas/data",OWNER="yashan", GROUP="YASDBA",MODE="0666" KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36000c29bfaa52387f836611169fd042b", SYMLINK+="yas/vote",OWNER="yashan", GROUP="YASDBA",MODE="0666" KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36000c2998ba97b791417a905aa504ecc", SYMLINK+="yas/ycr",OWNER="yashan", GROUP="YASDBA",MODE="0666" #重新扫描设备 /sbin/udevadm trigger --type=devices --action=change #在两个节点确认获取的id是否是一致的。 /usr/lib/udev/scsi_id --whitelisted --device=/dev/yas/data /usr/lib/udev/scsi_id --whitelisted --device=/dev/yas/vote /usr/lib/udev/scsi_id --whitelisted --device=/dev/yas/ycr
复制

因为这里使用的是虚拟机,按照官方文档的配置磁阵的方式行不通,直接使用scsi_id命令找到磁盘wwid进行手动编辑绑定即可。

4. 安装部署集群

使用yahsan用户,在节点1执行即可。

#1.切换用户 su - yashan #2.创建目录 mkdir install 将软件包上传到此目录/home/yashan/install #3.解压软件 tar -zxvf yashandb-23.1.1.200-linux-x86_64.tar.gz #4.生成配置文件 ./bin/yasboot package ce gen --cluster yashandb -u yashan -p yashan --ip 192.168.33.111,192.168.33.112 --port 22 --install-path /home/yashan/yasdb_home --data-path /home/yashan/yasdb_data --begin-port 1688 --node 2 --data /dev/yas/data --vote /dev/yas/vote --ycr /dev/yas/ycr #5.安装软件 ./bin/yasboot package install -t hosts.toml -i yashandb-23.1.1.200-linux-x86_64.tar.gz #6.部署集群 ./bin/yasboot cluster deploy -t yashandb.toml --yfs-force-create #7.设置环境变量 cd /home/yashan/yasdb_home/yashandb/23.1.1.200/conf/ cat yashandb.bashrc >> ~/.bashrc source ~/.bashrc #8.设置数据库sys用户密码,Cod-2023为密码,可自定义 yasboot cluster password set -n Cod-2023 -c yashandb #9.登录数据库 yasql / as sysdba
复制

实操参考

[root@yasrac01 ~]# su - yashan Last login: Wed Dec 20 17:26:04 CST 2023 on pts/0 [yashan@yasrac01 ~]$ mkdir install [yashan@yasrac01 ~]$ cd install/ [yashan@yasrac01 install]$ ll total 0 [yashan@yasrac01 install]$ ll total 262080 -rw-r--r-- 1 root root 215678976 Dec 20 17:49 yashandb-23.1.1.200-linux-x86_64.tar.gz [yashan@yasrac01 install]$ tar -zxvf yashandb-23.1.1.200-linux-x86_64.tar.gz ...(省略) [yashan@yasrac01 install]$ ll total 249704 drwxrwxr-x 6 yashan yashan 70 Oct 26 18:27 admin drwxrwxr-x 2 yashan yashan 312 Oct 26 18:27 bin drwxrwxr-x 2 yashan yashan 152 Oct 26 18:27 conf drwxrwxr-x 5 yashan yashan 60 Oct 26 18:27 ext -rw-rw-r-- 1 yashan yashan 11632 Oct 26 18:27 gitmoduleversion.dat drwxrwxr-x 2 yashan yashan 65 Oct 26 18:27 include drwxrwxr-x 3 yashan yashan 17 Oct 26 18:27 java drwxr-xr-x 2 yashan yashan 4096 Oct 26 18:27 lib -rw-r----- 1 yashan yashan 14989 Oct 26 18:05 LICENSE drwxrwxr-x 3 yashan yashan 21 Oct 26 18:27 plug-in drwxrwxr-x 2 yashan yashan 170 Oct 26 18:27 scripts -rw-r--r-- 1 root root 255660007 Dec 20 17:50 yashandb-23.1.1.200-linux-x86_64.tar.gz [yashan@yasrac01 install]$ ./bin/yasboot package ce gen --cluster yashandb -u yashan -p yashan --ip 192.168.33.111,192.168.33.112 --port 22 --install-path /home/yashan/yasdb_home --data-path /home/yashan/yasdb_data --begin-port 1688 --node 2 --data /dev/yas/data --vote /dev/yas/vote --ycr /dev/yas/ycr hostid | group | node_type | node_name | listen_addr | inter_connect | data_path ---------------------------------------------------------------------------------------------------------------- host0001 | ceg1 | ce | 1-1 | 192.168.33.111:1688 | 192.168.33.111:1689 | /home/yashan/yasdb_data ----------+-------+-----------+-----------+---------------------+---------------------+------------------------- host0002 | ceg1 | ce | 1-2 | 192.168.33.112:1688 | 192.168.33.112:1689 | /home/yashan/yasdb_data ----------+-------+-----------+-----------+---------------------+---------------------+------------------------- Generate config success [yashan@yasrac01 install]$ ll -rt total 249712 -rw-r----- 1 yashan yashan 14989 Oct 26 18:05 LICENSE drwxrwxr-x 3 yashan yashan 21 Oct 26 18:27 plug-in drwxrwxr-x 3 yashan yashan 17 Oct 26 18:27 java drwxr-xr-x 2 yashan yashan 4096 Oct 26 18:27 lib drwxrwxr-x 2 yashan yashan 65 Oct 26 18:27 include -rw-rw-r-- 1 yashan yashan 11632 Oct 26 18:27 gitmoduleversion.dat drwxrwxr-x 2 yashan yashan 152 Oct 26 18:27 conf drwxrwxr-x 5 yashan yashan 60 Oct 26 18:27 ext drwxrwxr-x 2 yashan yashan 312 Oct 26 18:27 bin drwxrwxr-x 2 yashan yashan 170 Oct 26 18:27 scripts drwxrwxr-x 6 yashan yashan 70 Oct 26 18:27 admin -rw-r--r-- 1 root root 255660007 Dec 20 17:50 yashandb-23.1.1.200-linux-x86_64.tar.gz drwxrwxr-x 2 yashan yashan 25 Dec 20 17:52 om -rw------- 1 yashan yashan 779 Dec 20 17:52 hosts.toml -rw------- 1 yashan yashan 1932 Dec 20 17:52 yashandb.toml [yashan@yasrac01 install]$ ./bin/yasboot package install -t hosts.toml -i yashandb-23.1.1.200-linux-x86_64.tar.gz checking install package... install version: yashandb 23.1.1.200 host0001 100% [====================================================================] 3s host0002 100% [====================================================================] 3s update host to yasom... [yashan@yasrac01 install]$ ./bin/yasboot cluster deploy -t yashandb.toml --yfs-force-create type | uuid | name | hostid | index | status | return_code | progress | cost ------------------------------------------------------------------------------------------------------------ task | aa24de0724d93962 | DeployYasdbCluster | - | yashandb | SUCCESS | 0 | 100 | 22 ------+------------------+--------------------+--------+----------+---------+-------------+----------+------ task completed, status: SUCCESS [yashan@yasrac01 install]$ cd /home/yashan/yasdb_home/yashandb/23.1.1.200/conf/ [yashan@yasrac01 conf]$ ll total 728 -rw-rw-r-- 1 yashan yashan 103550 Oct 26 18:27 database_options.json drwxrwxr-x 2 yashan yashan 73 Dec 20 17:56 monit -rw-rw-r-- 1 yashan yashan 297 Oct 26 18:27 profile.toml -rw-rw-r-- 1 yashan yashan 6837 Oct 26 18:27 sqlcollect.toml -rw-rw-r-- 1 yashan yashan 23577 Oct 26 18:27 sqlhtml.template -rwx------ 1 yashan yashan 281 Dec 20 17:56 yashandb.bashrc -rw-rw-r-- 1 yashan yashan 590524 Oct 26 18:27 yasreport.template -rw-rw-r-- 1 yashan yashan 3071 Oct 26 18:27 yfs_options.json [yashan@yasrac01 conf]$ cat yashandb.bashrc >> ~/.bashrc [yashan@yasrac01 conf]$ source ~/.bashrc [yashan@yasrac01 conf]$ echo $YASDB_HOME /home/yashan/yasdb_home/yashandb/23.1.1.200 [yashan@yasrac01 conf]$ yasboot cluster password set -n Cod-2023 -c yashandb type | uuid | name | hostid | index | status | return_code | progress | cost ---------------------------------------------------------------------------------------------------------- task | ec5dacf0740d5f9c | YasdbPasswordSet | - | yashandb | SUCCESS | 0 | 100 | 2 ------+------------------+------------------+--------+----------+---------+-------------+----------+------ task completed, status: SUCCESS [yashan@yasrac01 conf]$ yasboot cluster status -c yashandb -d hostid | node_type | nodeid | pid | instance_status | database_status | database_role | listen_address | data_path ------------------------------------------------------------------------------------------------------------------------------------------------- host0001 | ce | 1-1:1 | 2745 | open | normal | primary | 192.168.33.111:1688 | /home/yashan/yasdb_data/ce-1-1 ----------+-----------+--------+------+-----------------+-----------------+---------------+---------------------+-------------------------------- host0002 | ce | 1-2:2 | 2501 | open | normal | primary | 192.168.33.112:1688 | /home/yashan/yasdb_data/ce-1-2 ----------+-----------+--------+------+-----------------+-----------------+---------------+---------------------+-------------------------------- [yashan@yasrac01 conf]$ yasql / as sysdba YashanDB SQL Enterprise Edition Release 23.1.1.200 x86_64 Connected to: YashanDB Server Enterprise Edition Release 23.1.1.200 x86_64 - X86 64bit Linux SQL> select * from gv$instance; INST_ID STATUS VERSION STARTUP_TIME HOST_NAME DATA_HOME INSTANCE_NUMBER INSTANCE_NAME PARALLEL INSTANCE_ROLE IN_REFORM ----------- ------------- ---------------------------------------------------------------- ---------------------------------------------------------------- ---------------------------------------------------------------- ---------------------------------------------------------------- --------------- ---------------------------------------------------------------- -------------------- ---------------------------------------------------------------- --------- 1 OPEN Enterprise Edition Release 23.1.1.200 x86_64 2023-12-20 17:56:03.051207 yasrac01 /home/yashan/yasdb_data/ce-1-1 1 yasdb true MASTER_ROLE NO 2 OPEN Enterprise Edition Release 23.1.1.200 x86_64 2023-12-20 17:56:16.153710 yasrac02 /home/yashan/yasdb_data/ce-1-2 2 yasdb true NORMAL_ROLE NO 2 rows fetched.
复制

到此崖山共享集群安装完毕。

5. 集群常用运维命令

使用ycsctl,需要先配置环境变量YASCS_HOME。

是ycsctl,不是yasctl

#在节点1环境变量(~/.bashrc)中添加 export YASCS_HOME=/home/yashan/ycs/ce-1-1 #在节点2环境变量(~/.bashrc)中添加 export YASCS_HOME=/home/yashan/ycs/ce-1-2 #在两个节点都执行,使环境变量生效 source ~/.bashrc
复制

关闭实例

ycsctl stop instance #只会关闭当前节点的实例。
复制

查看实例状态

yasctl status
复制

image.png
查看集群参数(请注意这个AUTO_START=ALWAYS,后面重启集群会起到作用)

ycsctl show parameter
复制

image.png

一个完整的集群关闭——>重启虚拟机——>启动集群步骤

#1.关闭数据库实例(在两个节点上分别执行) ycsctl stop instance #2.关闭ycs服务(在两个节点上分别执行) ycsctl stop ycs #3.查看后台进程 ps -ef|grep yas #此时还有yasom和yasagent进程,yasom只在安装节点。 [yashan@yasrac02 ~]$ ps -ef|grep yashan yashan 2275 1 0 Dec20 ? 00:00:29 /home/yashan/yasdb_home/yashandb/23.1.1.200/bin/yasagent --init -c yashandb -l 192.168.33.112:1676 --host-id host0002 -k d17157b814abff0d -d [yashan@yasrac01 bin]$ ps -ef|grep yashan root 1926 1597 0 Dec20 pts/0 00:00:00 su - yashan yashan 1927 1926 0 Dec20 pts/0 00:00:00 -bash yashan 2467 1 0 Dec20 ? 00:00:28 /home/yashan/yasdb_home/yashandb/23.1.1.200/bin/yasagent --init -c yashandb -l 192.168.33.111:1676 --host-id host0001 -k d17157b814abff0d -d yashan 2494 1 0 Dec20 ? 00:00:59 /home/yashan/yasdb_home/yashandb/23.1.1.200/bin/yasom --init -c yashandb -l 192.168.33.111:1675 -k d17157b814abff0d -d root 21006 4168 0 10:49 pts/1 00:00:00 su - yashan #4.关闭yasagent服务(在两个节点执行) yasboot process yasagent stop -c yashandb #5.关闭yasom服务(在节点1执行) yasboot process yasom stop -c yashandb #6.此时两个节点上关于崖山的服务均已关闭完全。 #7.重启虚拟机(使用root用户) init 6 #8.启动yasom(在节点1执行) yasboot process yasom start -c yashandb #9.启动yasagent(两个节点执行) yasboot process yasagent start -c yashandb #10.启动ycs,这里如果直接使用ycsctl start ycs会跳不出去运行界面,用nohup(在两个节点分别执行) nohup ycsctl start ycs & #11.检查集群状态,因为默认数据库会跟着一起来,这里不用再单独启动数据库了。参数AUTO_START控制的。 ycsctl status
复制

6. 存疑

1.部署了两个节点,怎么有4个node的信息?
image.png
2.实例关闭需要约一分半,开启能即时完成。是否有参数调优的空间?
image.png

思考,gstack 收集堆栈信息,stop instance的过程在做什么? #0 0x00007f06aadcbc20 in __poll_nocancel () from /lib64/libc.so.6 #1 0x00007f06abb50915 in poll (__timeout=<optimized out>, __nfds=1, __fds=0x7ffd6ab8ca10) at /usr/include/bits/poll2.h:46 #2 sockWaitForRecv (fd=<optimized out>, timeout=timeout@entry=100, ready=0x7ffd6ab8ca5f) at /var/lib/jenkins/yasbuild/src/infra/cs/ani_tcp.c:795 #3 0x00007f06abb509b7 in tcpWaitForRecv (link=link@entry=0x56126838e410, timeout=timeout@entry=100, ready=ready@entry=0x7ffd6ab8ca5f) at /var/lib/jenkins/yasbuild/src/infra/cs/ani_tcp.c:817 #4 0x00007f06abb50a60 in tcpRecvRemainBytes (link=link@entry=0x56126838e410, buf=buf@entry=0x56126838e5c8 "\034", size=size@entry=28) at /var/lib/jenkins/yasbuild/src/infra/cs/ani_tcp.c:955 #5 0x00007f06abb50bf6 in tcpRecvBytes (link=0x56126838e410, buf=0x56126838e5c8 "\034", size=28) at /var/lib/jenkins/yasbuild/src/infra/cs/ani_tcp.c:1000 #6 0x0000561267e9ba37 in csRecvBytes (size=28, buf=<optimized out>, link=0x56126838e410) at /var/lib/jenkins/yasbuild/src/infra/./cs/ani_link.h:67 #7 ycscRecvPacket (hSrv=hSrv@entry=0x56126838e400, msg=<optimized out>, msg=<optimized out>) at /var/lib/jenkins/yasbuild/src/cluster/yascs/client/ycs_client.c:25 #8 0x0000561267e9beeb in ycscSimpleCmd (context=<optimized out>, cmd=cmd@entry=242 '\362') at /var/lib/jenkins/yasbuild/src/cluster/yascs/client/ycs_client.c:96 #9 0x0000561267e9af9b in ycsctlStopResources (profile=profile@entry=0x7ffd6ab8cc00) at /var/lib/jenkins/yasbuild/src/tools/ycsctl/ycs_ctl.c:187 #10 0x0000561267e99fd2 in processYcsCmd (isContinue=<synthetic pointer>, profile=0x7ffd6ab8cc00, argv=0x7ffd6ab8cfb8) at /var/lib/jenkins/yasbuild/src/tools/ycsctl/ycs_ctl.c:619 #11 main (argc=3, argv=0x7ffd6ab8cfb8) at /var/lib/jenkins/yasbuild/src/tools/ycsctl/ycs_ctl.c:719
复制
最后修改时间:2023-12-27 10:22:54
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论

目录
  • 1. 系统环境
    • 1.1 系统拓扑
    • 1.2 硬件资源说明
    • 1.3 软件资源说明
  • 2. 系统规划
    • 2.1 数据库系统安装规划
  • 3. 安装前准备
    • 3.1 检查操作系统版本
    • 3.2 检查物理内存容量
    • 3.3 检查系统架构
    • 3.4 配置内核参数
    • 3.5 配置资源限制
    • 3.6 关闭透明大页
    • 3.7 关闭防火墙
    • 3.8 创建用户及用户组
      • 3.8.1 创建yashan用户及YASDBA组
      • 3.9 配置共享存储
  • 4. 安装部署集群
  • 5. 集群常用运维命令
  • 6. 存疑