龙蜥社区保持凋谢单干、继续打造软硬件生态认证体系。您能够在龙蜥操作系统(Anolis OS)上安心应用已实现验证的利用。近期龙蜥社区与南大通用 GBase 实现产品兼容互认证,验证结果显示产品性能失常。本文以此为例,介绍如何疾速实现验证。
以下是南大通用 Gbase 8a 兼容性验证的具体步骤。
筹备工作
1、版本信息
- Anolis 7.7 ANCK 64 位
- GBase8a-NoLicense-Free-8.6.2_build43-R7-redhat7.3-x86_64(留神:留神:该二进制版本是从南大通用官网下载的基于 Redhat 7.3 编译的版本,咱们 Anolis OS 7.7 上运行该版本来验证根本的性能兼容性)
2、反对的架构
- x86_64
3、资源筹备
- 8 核 32G OS
- GBase 8a 数据库安装包(GBase8a-NoLicense-Free-8.6.2_build43-R7-redhat7.3-x86_64.tar.bz2,能够在南大通用数据库官网申请试用 (链接见文末))
第一步:装置
1、创立用户 GBase,后续操作都在 GBase 用户上面进行。
useradd -m gbase
su - gbase
2、假如安装包曾经放到了 /home/gbase 目录上面,解压数据到 /home/gbase/install 目录上面。
mkdir ~/install
tar -xjvf GBase8a-NoLicense-Free-8.6.2_build43-R7-redhat7.3-x86_64.tar.bz2 -C ~/install/
3、执行命令装置。
cd install/GBaseInstall/
./Install_lin.shd
# 失去如下提醒,输出 Yes 承受 License 以持续装置
*********************************************************************************
Thank you for choosing GBase product!
Please read carefully the following licencing agreement before installing any product:
Disclaimer of Product Trial License:
1. Any user who tries out (including self-downloaded trial or trial version provided by General Data Technology Co., Ltd) General Data Technology Co., Ltd Software Products should read this statement carefully. Users may choose not to try Nanda General Software Products. The user's tries out General Data Technology Co., Ltd Software Products will be deemed to be an endorsement of the full content of this statement.
2. Universal software products of General Data Technology Co., Ltd have complete autonomous knowledge rights and do not infringe on the relevant rights and interests of any other unit or individual. Universal software products of General Data Technology Co., Ltd are protected by law. Any transfer, reproduction, dissemination or use in unauthorized projects are strictly prohibited without the written permission of Universal of Nanda. Otherwise, the infringer will bear full responsibility.
3. Except for the terms of service specified by General Data Technology Co., Ltd, General Data Technology Co., Ltd is not liable or liable for any accident, negligence, contract destruction, defamation, copyright or intellectual property infringement caused by the trial use of General Data Technology Co., Ltd software products and any losses (including virus infection due to downloading).
4. The relevant information of General Data Technology Co., Ltd Software Products is the original information released. If there are any changes, no further notice will be given. Software may run differently from the final version, and features and functions in pre-release software may not appear in the final version. The risk of trying out the software should be borne by you.
5. Users assume their own risks for the trial of General Data Technology Co., Ltd Software Products. General Data Technology Co., Ltd does not guarantee any form of guarantee, does not guarantee that the trial products meet the user's requirements, does not guarantee that the trial service is uninterrupted, and does not guarantee the safety of the trial products. Due to any technical reasons such as network status, communication lines and so on, users can not normally try out General Data Technology Co., Ltd Products, or the impact or loss on third parties in the process of trial, General Data Technology Co., Ltd does not bear any legal liability.
6. General Data Technology Co., Ltd respects and protects the personal privacy rights of all users who try out General Data Technology Co., Ltd Products. Without the personal permission of users or mandatory provisions of relevant laws, General Data Technology Co., Ltd will not voluntarily disclose other third parties.
7. Any unit or individual who considers that General Data Technology Co., Ltd Software products may be suspected of infringing on its legitimate rights and interests should promptly give written feedback to General Data Technology Co., Ltd or its service website, and provide identity certificates, ownership certificates and detailed tort proof. After receiving the verification of the above-mentioned legal documents, General Data Technology Co., Ltd l will make corresponding treatment as soon as possible.
8. General Data Technology Co., Ltd Corporation has the final right to interpret General Data Technology Co., Ltd Products and this statement.
*********************************************************************************
Do you accept the above licence agreement (Yes/No, default=No) ?
Yes
*********************************************************************************
Welcome to install GBase products
*********************************************************************************
Please input the GBase software installation directory (Default:/home/gbase/GBase):
Installing all software packages ...
Software packages installation done.
*********************************************************************************
Welcome to create GBase database instance
*********************************************************************************
Please input the new database instance name (default: gbase8a):
Please input the port number for the new database instance (default:5258):
GBase is creating the New 'gbase8a' instance ...
hostkey: 2bc385b******
The host key file is genarate at GBASE_BASE/config/gbase_host.cnf.
Congratulations. Your GBase installation is successful.
Please execute $source ~/.bashrc manually on the first run.
Please refer to the product's manuals and readme.txt to start using GBase product.
一路点击回车应用默认配置,GBase 软件将被装置到 /home/gbase 目录,并将创立一个 GBase 8a 的数据库实例,实例默认服务端口 5258,执行 source 加载环境变量。
source ~/.bashrc
4、启动数据库服务。
gbase.server start
# 能够看到如下输入
# Starting GBase. SUCCESS!
第二步:测试
1、通过如下命令登录数据库。
gbase -uroot
如果装置没有问题,咱们能够顺利登录到数据库。
GBase client Free Edition 8.6.2.43-R7-free.110605. Copyright (c) 2004-2021, GBase. All Rights Reserved.
gbase>
2、展现数据库。
gbase> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| performance_schema |
| gbase |
| gclusterdb |
| gctmpdb |
+--------------------+
5 rows in set (Elapsed: 00:00:00.00)
gbase>
3、创立测试 db。
gbase> create database test;
Query OK, 1 row affected (Elapsed: 00:00:00.00)
gbase> use test;
Query OK, 0 rows affected (Elapsed: 00:00:00.00)
gbase>
4、创立表。
gbase> create table hola(bonj text);
Query OK, 0 rows affected (Elapsed: 00:00:00.01)
gbase>
5、插入数据。
gbase> insert into test.hola(bonj) values('Mundo');
Query OK, 1 row affected (Elapsed: 00:00:00.01)
gbase> insert into test.hola(bonj) values('Lundo');
Query OK, 1 row affected (Elapsed: 00:00:00.01)
gbase> insert into test.hola(bonj) values('Nundo');
Query OK, 1 row affected (Elapsed: 00:00:00.00)
gbase> select * from test.hola;
+-------+
| bonj |
+-------+
| Mundo |
| Lundo |
| Nundo |
+-------+
3 rows in set (Elapsed: 00:00:00.00)
gbase>
6、更新数据。
gbase> select * from test.hola;
+-------+
| bonj |
+-------+
| Mundo |
| Lundo |
| Nundo |
+-------+
3 rows in set (Elapsed: 00:00:00.00)
gbase> update test.hola set bonj='Xundo' where bonj='Mundo';
Query OK, 1 row affected (Elapsed: 00:00:00.01)
Rows matched: 1 Changed: 1 Warnings: 0
gbase> select * from test.hola;
+-------+
| bonj |
+-------+
| Xundo |
| Lundo |
| Nundo |
+-------+
3 rows in set (Elapsed: 00:00:00.00)
gbase>
7、查问数据。
gbase> select * from test.hola;
+-------+
| bonj |
+-------+
| Xundo |
| Lundo |
| Nundo |
+-------+
3 rows in set (Elapsed: 00:00:00.00)
gbase>
8、删除数据。
gbase> delete from test.hola where bonj='Xundo';
Query OK, 1 row affected (Elapsed: 00:00:00.00)
gbase> select * from test.hola;
+-------+
| bonj |
+-------+
| Lundo |
| Nundo |
+-------+
2 rows in set (Elapsed: 00:00:00.00)
gbase>
9、退出 sql。
gbase> exit
Bye
以上是南大通用 GBase 8a 兼容性验证介绍,欢送感兴趣的各位验证适配。如有验证需要,请分割:陈佳 jackie.cj@openanolis.org
后续社区会提供线上认证流程,更加高效通明,敬请期待!
南大通用官网:http://www.gbase8a.com/Topic/173
欢送更多开发者退出软件兼容性 SIG:
https://openanolis.cn/sig/thi…
邮件列表:os@lists.openanolis.cn
—— 完 ——