5 月底,openEuler 24.03 LTS 发布,详情戳:
在诸多亮点特性中,有一条值得注意:
集成 GreatSQL 数据库,适用于金融级应用场景,具有高可用、高性能、高兼容、高安全等特性。
那么,本文就来介绍一下如何安装 openEuler 24.03 LTS 操作系统,以及集成的 GreatSQL 数据库。
openEuler 24.03 LTS
这里为便于演示,使用 VMware 虚拟机在本地环境安装 openEuler 系统,OS 的 iso 镜像可从官方网站下载。
https://www.openeuler.org/zh/download/
跳过介质测试步骤,直接进入安装环节。
国产操作系统,语言当然选择中文。
默认是禁用 root 账户的,这里启用 root 账户,如果有安全要求,可以勾选 SM3 算法。
安装完成后,登陆系统。
查看一些基础信息,如操作系统的版本,内核版本,语言设定等。
[root@eular ~]# cat /etc/openEuler-release
openEuler release 24.03 (LTS)
[root@eular ~]# hostnamectl
Static hostname: eular.shawnyan.cn
...
Operating System: openEuler 24.03 (LTS)
Kernel: Linux 6.6.0-28.0.0.34.oe2403.x86_64
Architecture: x86-64
Hardware Vendor: VMware, Inc.
Hardware Model: VMware Virtual Platform
Firmware Version: 6.00
Firmware Date: Wed 2020-07-22
Firmware Age: 3y 10month 3w
[root@eular ~]# uname -a
Linux eular.shawnyan.cn 6.6.0-28.0.0.34.oe2403.x86_64 #1 SMP Mon May 27 22:22:46 CST 2024 x86_64 x86_64 x86_64 GNU/Linux
[root@eular ~]# localectl
System Locale: LANG=zh_CN.UTF-8
VC Keymap: cn
X11 Layout: cn
可以看到操作系统为当前最新长期支持版本 openEuler 24.03 (LTS)
内核版本也是当前最新长期支持版本 Linux 6.6
。
扩展知识
我们通常所说的 Linux Kernel 内核,也有维护生命周期,其中当前维护的长期支持版本信息,参见下表:
Version | Maintainer | Released | Projected EOL |
---|---|---|---|
6.6 | Greg Kroah-Hartman & Sasha Levin | 10/29/2023 | Dec, 2026 |
6.1 | Greg Kroah-Hartman & Sasha Levin | 12/11/2022 | Dec, 2026 |
5.15 | Greg Kroah-Hartman & Sasha Levin | 10/31/2021 | Dec, 2026 |
5.1 | Greg Kroah-Hartman & Sasha Levin | 12/13/2020 | Dec, 2026 |
5.4 | Greg Kroah-Hartman & Sasha Levin | 11/24/2019 | Dec, 2025 |
4.19 | Greg Kroah-Hartman & Sasha Levin | 10/22/2018 | Dec, 2024 |
GreatSQL 8.0.32-25
GreatSQL 数据库是一款开源免费数据库,可在普通硬件上满足金融级应用场景,具有高可用、高性能、高兼容、高安全等特性。
GreatSQL
针对MGR进行了大量改进和提升工作,新增支持地理标签、仲裁节点、读写节点可绑定动态IP、快速单主模式、智能选主,并针对流控算法、事务认证队列清理算法、节点加入&退出机制、recovery机制等多项MGR底层工作机制算法进行深度优化,进一步提升优化了MGR的高可用保障及性能稳定性。同时,支持高性能的内存查询加速
Rapid 引擎、InnoDB并行查询、并行LOAD DATA、事务无锁化、线程池等特性。
当前最新版本为 GreatSQL 8.0.32-25 (2023-12-28)
集成后的 GreatSQL 无需额外配置 yum 源或自行下载安装包,只需一条命令即可完成安装。
[root@eular ~]# dnf install greatsql-*
Last metadata expiration check: 0:03:10 ago on 2024年06月12日 星期三 22时27分11秒.
Dependencies resolved.
=======================================================================================================================
Package Architecture Version Repository Size
=======================================================================================================================
Installing:
greatsql-client x86_64 8.0.32-25.1.oe2403 everything 18 M
greatsql-debuginfo x86_64 8.0.32-25.1.oe2403 debuginfo 611 M
greatsql-debugsource x86_64 8.0.32-25.1.oe2403 debuginfo 21 M
greatsql-devel x86_64 8.0.32-25.1.oe2403 everything 1.8 M
greatsql-icu-data-files x86_64 8.0.32-25.1.oe2403 everything 2.0 M
greatsql-mysql-config x86_64 8.0.32-25.1.oe2403 OS 5.2 k
greatsql-mysql-router x86_64 8.0.32-25.1.oe2403 everything 4.9 M
greatsql-server x86_64 8.0.32-25.1.oe2403 everything 73 M
greatsql-shared x86_64 8.0.32-25.1.oe2403 everything 1.4 M
greatsql-test x86_64 8.0.32-25.1.oe2403 everything 392 M
Installing dependencies:
compat-openssl11-devel x86_64 1:1.1.1m-10.oe2403 everything 1.8 M
compat-openssl11-libs x86_64 1:1.1.1m-10.oe2403 OS 1.4 M
e2fsprogs-devel x86_64 1.47.0-3.oe2403 OS 290 k
keyutils-libs-devel x86_64 1.6.3-5.oe2403 OS 9.8 k
krb5-devel x86_64 1.21.2-2.oe2403 OS 161 k
libselinux-devel x86_64 3.5-3.oe2403 OS 105 k
libsepol-devel x86_64 3.5-3.oe2403 OS 370 k
libverto-devel x86_64 0.3.2-3.oe2403 OS 15 k
net-tools x86_64 2.10-4.oe2403 OS 199 k
pcre2-devel x86_64 10.42-7.oe2403 OS 514 k
perl-JSON noarch 4.10-1.oe2403 OS 54 k
zlib-devel x86_64 1.2.13-2.oe2403 OS 91 k
Transaction Summary
=======================================================================================================================
Install 22 Packages
Total download size: 1.1 G
Installed size: 4.2 G
Is this ok [y/N]: y
...
Installed:
compat-openssl11-devel-1:1.1.1m-10.oe2403.x86_64 compat-openssl11-libs-1:1.1.1m-10.oe2403.x86_64
e2fsprogs-devel-1.47.0-3.oe2403.x86_64 greatsql-client-8.0.32-25.1.oe2403.x86_64
greatsql-debuginfo-8.0.32-25.1.oe2403.x86_64 greatsql-debugsource-8.0.32-25.1.oe2403.x86_64
greatsql-devel-8.0.32-25.1.oe2403.x86_64 greatsql-icu-data-files-8.0.32-25.1.oe2403.x86_64
greatsql-mysql-config-8.0.32-25.1.oe2403.x86_64 greatsql-mysql-router-8.0.32-25.1.oe2403.x86_64
greatsql-server-8.0.32-25.1.oe2403.x86_64 greatsql-shared-8.0.32-25.1.oe2403.x86_64
greatsql-test-8.0.32-25.1.oe2403.x86_64 keyutils-libs-devel-1.6.3-5.oe2403.x86_64
krb5-devel-1.21.2-2.oe2403.x86_64 libselinux-devel-3.5-3.oe2403.x86_64
libsepol-devel-3.5-3.oe2403.x86_64 libverto-devel-0.3.2-3.oe2403.x86_64
net-tools-2.10-4.oe2403.x86_64 pcre2-devel-10.42-7.oe2403.x86_64
perl-JSON-4.10-1.oe2403.noarch zlib-devel-1.2.13-2.oe2403.x86_64
Complete!
[root@eular ~]#
安装完成后,通过 systemctl 命令启动 GreatSQL 数据库。
[root@eular ~]# systemctl start mysqld
第一次启动后,会生成一个随机密码,需要从日志文件中获取。
[root@eular ~]# grep root /var/log/mysqld.log
2024-06-12T22:42:54.089407Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: eqoz=EpSG1Lg
使用临时密码登陆后,修改密码。
[root@eular ~]# mysql -uroot -peqoz=EpSG1Lg
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.32-25
Copyright (c) 2021-2023 GreatDB Software Co., Ltd
Copyright (c) 2009-2023 Percona LLC and/or its affiliates
Copyright (c) 2000, 2023, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> alter user root@'localhost' identified by 'GreatSQL666!';
Query OK, 0 rows affected (0.00 sec)
之后,可用新密码对数据库进行管理。
查看数据库版本信息。
mysql> show variables like 'version%';
+-------------------------+--------------------------------------------------+
| Variable_name | Value |
+-------------------------+--------------------------------------------------+
| version | 8.0.32-25 |
| version_comment | GreatSQL (GPL), Release 25, Revision db07cc5cb73 |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
| version_compile_zlib | 1.2.13 |
| version_suffix | |
+-------------------------+--------------------------------------------------+
6 rows in set (0.00 sec)
基于 openEuler 24.03 安装 GreatSQL 8.0.32-25 数据库,先介绍到这里。
关于 GreatSQL 的更多内容欢迎到 GreatSQL 社区进行了解。