2

Linux上OcenBase单机版部署及基本信息查询 - 爱奶茶的迪丽热巴

 4 months ago
source link: https://www.cnblogs.com/naicha-dilireba/p/18169834
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client

Linux上OcenBase单机版部署及基本信息查询

　　OceanBase单机版部署可以通过在线和离线两种方式部署。在线部署可以通过yum源或者apt源部署，直接拉取官方源码即可。实际使用中，大部分环境连不了外网，本文介绍离线方式安装。

　　下载“OceanBase All in One”离线安装包下载官方地址：https://www.oceanbase.com/softwarecenter?_gl=1*14gauzt*_ga*MTQzNzg0MDI0Ny4xNzEzMzM4MzYx*_ga_T35KTM57DZ*MTcxNDU3NTk5OC4yMy4xLjE3MTQ1NzY3MzAuNTguMC4w

1. 解压安装包

[root@tidb01 db_ob]# ll
-rwxr-xr-x 1 root root 692947447 May 1 19:23 oceanbase-all-in-one-4.3.0.1-100000242024032211.el7.x86_64.tar.gz
[root@tidb01 db_ob]# tar -xzvf oceanbase-all-in-one-4.3.0.1-100000242024032211.el7.x86_64.tar.gz
[root@tidb01 db_ob]# ll
total 676708
drwxr-xr-x 6 root root 88 Mar 29 11:46 oceanbase-all-in-one
-rwxr-xr-x 1 root root 692947447 May 1 19:23 oceanbase-all-in-one-4.3.0.1-100000242024032211.el7.x86_64.tar.gz

2. 一键部署并添加到系统环境变量

[root@tidb01 db_ob]# cd oceanbase-all-in-one/bin/
[root@tidb01 bin]# ./install.sh
[root@tidb01 bin]# source ~/.oceanbase-all-in-one/bin/env.sh
[root@tidb01 bin]# obd demo

3. 连接数据库

#通过2881端口直连数据库
[root@tidb01 ~]# obclient -h127.0.0.1 -P2881 -uroot@sys -Doceanbase -A
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221497482
Server version: OceanBase_CE 4.3.0.1 (r100000242024032211-0193a343bc60b4699ec47792c3fc4ce166a182f9) (Built Mar 22 2024 13:19:48)

Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

obclient [oceanbase]>

#通过ODP代理访问数据库
[root@tidb01 ~]# obclient -h127.0.0.1 -P2883 -uroot@sys -Doceanbase -A
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 1815347202
Server version: OceanBase_CE 4.3.0.1 (r100000242024032211-0193a343bc60b4699ec47792c3fc4ce166a182f9) (Built Mar 22 2024 13:19:48)

Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

obclient [oceanbase]>

4. 查询数据库版本、字符集等基本信息

obclient [oceanbase]> SELECT VERSION();
+------------------------------+
| VERSION() |
+------------------------------+
| 5.7.25-OceanBase_CE-v4.3.0.1 |
+------------------------------+
1 row in set (0.002 sec)

obclient [oceanbase]>

#查看字符集
obclient [oceanbase]> SHOW SESSION VARIABLES LIKE 'character\_set\_%';
+--------------------------+---------+
| Variable_name | Value |
+--------------------------+---------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8mb4 |
+--------------------------+---------+
7 rows in set (0.003 sec)
obclient [oceanbase]> SHOW SESSION VARIABLES LIKE 'collation\_%';
+----------------------+--------------------+
| Variable_name | Value |
+----------------------+--------------------+
| collation_connection | utf8mb4_general_ci |
| collation_database | utf8mb4_general_ci |
| collation_server | utf8mb4_general_ci |
+----------------------+--------------------+
3 rows in set (0.003 sec)

版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。


report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK