在SmartArt中新添加项目如何编辑文字(smartart图形中怎么添加文字)
794
2022-05-29
近期GaussDB很火,作为一名DBA,本身对国产数据库有无限憧憬与向往,所以就先走一步,体验一下。
GaussDB安装过程中使用Python脚本实现,此处仅简要记录安装步骤。
部署环境说明:
Centos7.5 mini安装
CPU:1C MEM:2G磁盘:100G
1.系统初始
1>关闭防火墙
[root@Gauss1 ~]# systemctl status firewalld.service
[root@Gauss1 ~]# systemctl stop firewalld.service
[root@Gauss1 ~]# systemctl disable firewalld.service
[root@G0 ~]# firewall-cmd --state
not running
[root@G0 ~]#
2>调整内核参数
/etc/sysctl.conf追加如下内容:
kernel.sem = 50100 128256000 50100 2560
net.core.netdev_max_backlog = 1000
net.ipv4.tcp_max_syn_backlog = 2048
kernel.core_pattern = /corefile/core.%p.%e
kernel.core_uses_pid = 1
kernel.shmmni = 4096
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
fs.file-max = 6815744
增加完成后执行sysctl -p更新
3>配置本地YUM源,安装依赖包
echo "/dev/sr0 mnt/iso iso9660 defaults,loop 0 0" >> etc/fstab
mkdir -p mnt/iso
rm -rf /etc/yum.repos.d/*
cat >> etc/yum.repos.d/ios.repo < [ios] name=ios baseurl=file:///mnt/iso enabled=1 gpgcheck=0 EOF mount -a yum repolist 配置完成后,检查依赖包。安装未安装的依赖包 [root@G0 ~]# unset uninstall_rpm;for i in zlib readline gcc python python-devel perl-ExtUtils-Embed readline-devel zlib-devel lsof;do rpm -q $i &>/dev/null || uninstall_rpm="$uninstall_rpm $i";done ;[[ -z "$uninstall_rpm" ]] && echo -e "\nuninstall_rpm:\n\tOK.OK.OK" || echo -e "\nuninstall_rpm:\n\t$uninstall_rpm" uninstall_rpm: gcc python-devel perl-ExtUtils-Embed readline-devel zlib-devel [root@G0 ~]# yum -y install gcc python-devel perl-ExtUtils-Embed readline-devel zlib-devel 安装完成后,再次执行脚本,如果均已按安装,会输出“ OK.OK.OK” 4>管理用户创建 [root@G0 ~]# groupadd -g 1000 dbgrp [root@G0 ~]# useradd -u 1100 -g dbgrp -d home/omm -m -s bin/bash omm [root@G0 ~]# passwd omm 5>目录规划 [root@G0 ~]# mkdir -p opt/software/gaussdb --软件包存放目录 [root@G0 ~]# mkdir -p opt/gaussdb/data --数据目录 [root@G0 ~]# mkdir -p opt/gaussdb/log --日志目录 [root@G0 ~]# mkdir -p opt/gaussdb/gaussdb --软件家目录 [root@G0 ~]# chown omm:dbgrp /opt -R 6>突破上传解压 [omm@G0 ~]$ cd opt/software/gaussdb/ [omm@G0 gaussdb]$ rz GaussDB_100_1.0.0-DATABASE-REDHAT-64bit.tar.gz [omm@G0 gaussdb]$ ls GaussDB_100_1.0.0-DATABASE-REDHAT-64bit.tar.gz [omm@G0 gaussdb]$ tar -xzf GaussDB_100_1.0.0-DATABASE-REDHAT-64bit.tar.gz [omm@G0 gaussdb]$ ls GaussDB_100_1.0.0-DATABASE-REDHAT-64bit GaussDB_100_1.0.0-DATABASE-REDHAT-64bit.tar.gz 2.安装展开 1>执行安装命令 [root@G0 ~]# cd /opt/software/gaussdb/GaussDB_100_1.0.0-DATABASE-REDHAT-64bit [root@G0 GaussDB_100_1.0.0-DATABASE-REDHAT-64bit]# ls funclib.py GaussDB_100_1.0.0-RUN-REDHAT-64bit.tar.gz sshexkey.py GaussDB_100_1.0.0-RUN-REDHAT-64bit.sha256 install.py upgrade.py [root@G0 GaussDB_100_1.0.0-DATABASE-REDHAT-64bit]# python install.py -U omm:dbgrp -R /opt/gaussdb/gaussdb100 -D /opt/gaussdb/data -C LSNR_ADDR=127.0.0.1,192.168.0.11 -C LSNR_PORT=1888 -C DATA_BUFFER_SIZE=500m -C SHARED_POOL_SIZE=150M -C TEMP_BUFFER_SIZE=150M Error: Run package GaussDB_100_1.0.0-RUN-REDHAT-64bit.tar.gz is inconsistent with os system centos. Please refer to install log "/home/omm/zengineinstall.log" for more detailed information. [root@G0 GaussDB_100_1.0.0-DATABASE-REDHAT-64bit]# 报错是因为操作系统模型检查未通过,可通过编辑install.py规避(注释掉L572,573安装脚本中的校验) 571 # check os version of package is mattched with current os version 572 #if self.run_pkg_name.find(distname.upper().replace("OS", "")) == -1: --注释掉 573 # logExit("Run package %s.tar.gz is inconsistent with os system %s." % (self.run_pkg_name, distname)) --注释掉 574 重新执行 [root@G0 GaussDB_100_1.0.0-DATABASE-REDHAT-64bit]# python install.py -U omm:dbgrp -R /opt/gaussdb/gaussdb100 -D /opt/gaussdb/data -C LSNR_ADDR=127.0.0.1,192.168.0.11 -C LSNR_PORT=1888 -C DATA_BUFFER_SIZE=500m -C SHARED_POOL_SIZE=150M -C TEMP_BUFFER_SIZE=150M Checking runner. Checking parameters. End check parameters. Checking user. End check user. Checking old install. End check old install. Checking kernel parameters. Checking directory. Checking integrality of run file... Decompressing run file. Setting user env. Checking data dir and config file Initialize db instance. Creating database. Creating database succeed. Changing file permission due to security audit. Install successfully, for more detail information see /home/omm/zengineinstall.log. [root@G0 GaussDB_100_1.0.0-DATABASE-REDHAT-64bit]# 成功完成安装后,数据库预设是启动的。 [omm@G0 ~]$ ps -ef | grep zengine omm 26232 1 7 18:49 ? 00:00:14 /opt/gaussdb/gaussdb100/bin/zengine nomount -D /opt/gaussdb/data omm 26312 25605 0 18:52 pts/3 00:00:00 grep --color=auto zengine [omm@G0 ~]$ 2>首次登陆数据库,修改默认密码 [omm@G0 ~]$ zsql SYS/Changeme_123@127.0.0.1:1888 -q connected. SQL> alter user sys identified by 123456 replace Changeme_123; GS-00657, Password is too simple, password should contain at least three of the following character types: A. at least one lowercase letter B. at least one uppercase letter C. at least one digit D. at least one special character: `~!@#$%^&*()-_=+\|[{}]:'",<.>/? and space --密码复杂度要求 SQL> alter user sys identified by "aA123!@#" replace Changeme_123; Succeed. SQL> 3.测试使用: 1>创建用户表空间 SQL> create tablespace kevin datafile '/opt/gaussdb/data/kevin' size 100M autoextend on; SQL> create user kevin identified by "kevinA1!" default tablespace kevin temporary tablespace temp; SQL> grant connect,resource to kevin; 2>创建表并测试性能 SQL> create table kevin.test as select * from dv_tablespaces; SQL> select count(*) from kevin.test; COUNT(*) -------------------- 7 1 rows fetched. SQL> set timing on SQL> insert into kevin.test select * from kevin.test; ... --重复执行多次 SQL> insert into kevin.test select * from kevin.test; 3670016 rows affected. Elapsed: 18.545 sec SQL> insert into kevin.test select * from kevin.test; 7340032 rows affected. Elapsed: 55.795 sec SQL> 如上,插入734w数据仅耗时55s,这个速度令人惊奇,非常厉害。 4.补充 下次开机后不会自动启动,需要手动启。 [omm@G0 ~]$ cd /opt/gaussdb/gaussdb100/bin/ [omm@G0 bin]$ python zctl.py -t start Successfully started instance. [omm@G0 bin] 本文转自“墨天轮”社区GaussDB频道 数据库 GaussDB
版权声明:本文内容由网络用户投稿,版权归原作者所有,本站不拥有其著作权,亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容,请联系我们jiasou666@gmail.com 处理,核实后本网站将在24小时内删除侵权内容。