视频源
- 两分钟快速试玩 OceanBase 数据库
系统配置信息
操作系统:CentOS Linux release 7.8.2003 (Core)
硬件配置:8c 16g
安装 yum-utils
[root@ecs-7732 ~]# yum install -y yum-utils Loaded plugins: fastestmirror Determining fastest mirrors base | 3.6 kB 00:00 epel | 4.7 kB 00:00 extras | 2.9 kB 00:00 updates | 2.9 kB 00:00 (1/7): epel/x86_64/group_gz | 96 kB 00:00 (2/7): base/7/x86_64/primary_db | 6.1 MB 00:00 (3/7): base/7/x86_64/group_gz | 153 kB 00:00 (4/7): epel/x86_64/primary_db | 7.0 MB 00:00 (5/7): epel/x86_64/updateinfo | 1.0 MB 00:00 (6/7): updates/7/x86_64/primary_db | 13 MB 00:00 (7/7): extras/7/x86_64/primary_db | 243 kB 00:00 Resolving Dependencies --> Running transaction check ---> Package yum-utils.noarch 0:1.1.31-54.el7_8 will be installed --> Processing Dependency: python-kitchen for package: yum-utils-1.1.31-54.el7_8.noarch --> Running transaction check ---> Package python-kitchen.noarch 0:1.1.1-5.el7 will be installed --> Processing Dependency: python-chardet for package: python-kitchen-1.1.1-5.el7.noarch --> Running transaction check ---> Package python-chardet.noarch 0:2.2.1-3.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved ====================================================================== Package Arch Version Repository Size ====================================================================== Installing: yum-utils noarch 1.1.31-54.el7_8 base 122 k Installing for dependencies: python-chardet noarch 2.2.1-3.el7 base 227 k python-kitchen noarch 1.1.1-5.el7 base 267 k Transaction Summary ====================================================================== Install 1 Package (+2 Dependent packages) Total download size: 616 k Installed size: 2.8 M Downloading packages: (1/3): python-chardet-2.2.1-3.el7.noarch.rpm | 227 kB 00:00 (2/3): python-kitchen-1.1.1-5.el7.noarch.rpm | 267 kB 00:00 (3/3): yum-utils-1.1.31-54.el7_8.noarch.rpm | 122 kB 00:00 ---------------------------------------------------------------------- Total 2.3 MB/s | 616 kB 00:00 Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : python-chardet-2.2.1-3.el7.noarch 1/3 Installing : python-kitchen-1.1.1-5.el7.noarch 2/3 Installing : yum-utils-1.1.31-54.el7_8.noarch 3/3 Verifying : python-kitchen-1.1.1-5.el7.noarch 1/3 Verifying : yum-utils-1.1.31-54.el7_8.noarch 2/3 Verifying : python-chardet-2.2.1-3.el7.noarch 3/3 Installed: yum-utils.noarch 0:1.1.31-54.el7_8 Dependency Installed: python-chardet.noarch 0:2.2.1-3.el7 python-kitchen.noarch 0:1.1.1-5.el7 Complete!
添加 OceanBase .repo
[root@ecs-7732 ~]# echo $LANG en_US.UTF-8 [root@ecs-7732 ~]# yum-config-manager --add-repo https://mirrors.aliyun.com/oceanbase/OceanBase.repo Loaded plugins: fastestmirror adding repo from: https://mirrors.aliyun.com/oceanbase/OceanBase.repo grabbing file https://mirrors.aliyun.com/oceanbase/OceanBase.repo to /etc/yum.repos.d/OceanBase.repo repo saved to /etc/yum.repos.d/OceanBase.repo
安装 OBD
[root@ecs-7732 ~]# yum install -y ob-deploy Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile oceanbase.community.stable | 3.0 kB 00:00 oceanbase.development-kit | 3.0 kB 00:00 (1/2): oceanbase.development-kit/7/x86_64/primar | 15 kB 00:00 (2/2): oceanbase.community.stable/7/x86_64/prima | 19 kB 00:00 Resolving Dependencies --> Running transaction check ---> Package ob-deploy.x86_64 0:1.1.2-1.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved ====================================================================== Package Arch Version Repository Size ====================================================================== Installing: ob-deploy x86_64 1.1.2-1.el7 oceanbase.community.stable 14 M Transaction Summary ====================================================================== Install 1 Package Total download size: 14 M Installed size: 19 M Downloading packages: warning: /var/cache/yum/x86_64/7/oceanbase.community.stable/packages/ob-deploy-1.1.2-1.el7.x86_64.rpm: Header V4 RSA/SHA1 Signature, key ID e9b4a7aa: NOKEY Public key for ob-deploy-1.1.2-1.el7.x86_64.rpm is not installed ob-deploy-1.1.2-1.el7.x86_64.rpm | 14 MB 00:07 Retrieving key from http://mirrors.aliyun.com/oceanbase/RPM-GPG-KEY-OceanBase Importing GPG key 0xE9B4A7AA: Userid : "OceanBase" Fingerprint: ef7d e8e3 6987 b60c acf9 9a53 2ff8 45a6 e9b4 a7aa From : http://mirrors.aliyun.com/oceanbase/RPM-GPG-KEY-OceanBase Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : ob-deploy-1.1.2-1.el7.x86_64 1/1 Installation of obd finished successfully Please source /etc/profile.d/obd.sh to enable it Verifying : ob-deploy-1.1.2-1.el7.x86_64 1/1 Installed: ob-deploy.x86_64 0:1.1.2-1.el7 Complete!
上传配置文件
从这里获取mini-local-example.yaml文件
gitee mini-local-example.yaml
oceanbase-ce:servers:# Please don't use hostname, only IP can be supported- 127.0.0.1global:# The working directory for OceanBase Database. OceanBase Database is started under this directory. This is a required field.home_path: /root/observer# The directory for data storage. The default value is $home_path/store.# data_dir: /data# The directory for clog, ilog, and slog. The default value is the same as the data_dir value.# redo_dir: /redo# Please set devname as the network adaptor's name whose ip is in the setting of severs.# if set severs as "127.0.0.1", please set devname as "lo"# if current ip is 192.168.1.10, and the ip's network adaptor's name is "eth0", please use "eth0"devname: lomysql_port: 2881 # External port for OceanBase Database. The default value is 2881. DO NOT change this value after the cluster is started.rpc_port: 2882 # Internal port for OceanBase Database. The default value is 2882. DO NOT change this value after the cluster is started.zone: zone1cluster_id: 1# please set memory limit to a suitable value which is matching resource. memory_limit: 8G # The maximum running memory for an observersystem_memory: 4G # The reserved system memory. system_memory is reserved for general tenants. The default value is 30G.stack_size: 512Kcpu_count: 16cache_wash_threshold: 1G__min_full_resource_pool_memory: 268435456workers_per_cpu_quota: 10schema_history_expire_time: 1d# The value of net_thread_count had better be same as cpu's core number. net_thread_count: 4sys_bkgd_migration_retry_num: 3minor_freeze_times: 10enable_separate_sys_clog: 0enable_merge_by_turn: FALSEdatafile_disk_percentage: 20 # The percentage of the data_dir space to the total disk space. This value takes effect only when datafile_size is 0. The default value is 90.syslog_level: INFO # System log level. The default value is INFO.enable_syslog_wf: false # Print system logs whose levels are higher than WARNING to a separate log file. The default value is true.enable_syslog_recycle: true # Enable auto system log recycling or not. The default value is false.max_syslog_file_count: 4 # The maximum number of reserved log files before enabling auto recycling. The default value is 0.# root_password: # root user password, can be empty [root@ecs-7732 ~]# yum -y install lrzsz Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile Resolving Dependencies --> Running transaction check ---> Package lrzsz.x86_64 0:0.12.20-36.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved ======================================================================Package Arch Version Repository Size ====================================================================== Installing:lrzsz x86_64 0.12.20-36.el7 base 78 k Transaction Summary ====================================================================== Install 1 Package Total download size: 78 k Installed size: 181 k Downloading packages: lrzsz-0.12.20-36.el7.x86_64.rpm | 78 kB 00:00 Running transaction check Running transaction test Transaction test succeeded Running transactionInstalling : lrzsz-0.12.20-36.el7.x86_64 1/1 Verifying : lrzsz-0.12.20-36.el7.x86_64 1/1 Installed:lrzsz.x86_64 0:0.12.20-36.el7 Complete! [root@ecs-7732 ~]# rz -E rz waiting to receive. [root@ecs-7732 ~]# ls mini-local-example.yaml [root@ecs-7732 ~]#
root 用户快速启动本地单节点数据库
[root@ecs-7732 ~]# obd cluster deploy demo -c mini-local-example.yaml Update OceanBase-community-stable-el7 ok Update OceanBase-development-kit-el7 ok Download oceanbase-ce-3.1.1-4.el7.x86_64.rpm (46.21 M): 100% [######################################################################] Time: 0:00:32 1.47 MB/s Package oceanbase-ce-3.1.1 is available. install oceanbase-ce-3.1.1 for local ok +-----------------------------------------------------------------------------+ | Packages | +--------------+---------+---------+------------------------------------------+ | Repository | Version | Release | Md5 | +--------------+---------+---------+------------------------------------------+ | oceanbase-ce | 3.1.1 | 4.el7 | f19f8bfb67723712175fb0dfd60579196b3168f1 | +--------------+---------+---------+------------------------------------------+ Repository integrity check ok Parameter check ok Open ssh connection ok Remote oceanbase-ce-3.1.1-f19f8bfb67723712175fb0dfd60579196b3168f1 repository install ok Remote oceanbase-ce-3.1.1-f19f8bfb67723712175fb0dfd60579196b3168f1 repository lib check !! [WARN] 127.0.0.1 oceanbase-ce-3.1.1-f19f8bfb67723712175fb0dfd60579196b3168f1 require: libmariadb.so.3 [WARN] 127.0.0.1 oceanbase-ce-3.1.1-f19f8bfb67723712175fb0dfd60579196b3168f1 require: libaio.so.1 Try to get lib-repository Download oceanbase-ce-libs-3.1.1-4.el7.x86_64.rpm (155.15 K): 100% [################################################################] Time: 0:00:00 3.16 MB/s Package oceanbase-ce-libs-3.1.1 is available. install oceanbase-ce-libs-3.1.1 for local ok Use oceanbase-ce-libs-3.1.1-58384f7ab4ee736e9d530f4bdd63c20ced0e7aba for oceanbase-ce-3.1.1-f19f8bfb67723712175fb0dfd60579196b3168f1 Remote oceanbase-ce-libs-3.1.1-58384f7ab4ee736e9d530f4bdd63c20ced0e7aba repository install ok Remote oceanbase-ce-3.1.1-f19f8bfb67723712175fb0dfd60579196b3168f1 repository lib check ok Cluster status check ok Initializes observer work home ok demo deployed
安装 obclient 客户端
[root@ecs-7732 ~]# yum install -y obclient Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile Resolving Dependencies --> Running transaction check ---> Package obclient.x86_64 0:2.0.0-2.el7 will be installed --> Processing Dependency: libobclient >= 2.0.0 for package: obclient-2.0.0-2.el7.x86_64 --> Running transaction check ---> Package libobclient.x86_64 0:2.0.0-2.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved ================================================================================= Package Arch Version Repository Size ================================================================================= Installing: obclient x86_64 2.0.0-2.el7 oceanbase.community.stable 40 M Installing for dependencies: libobclient x86_64 2.0.0-2.el7 oceanbase.community.stable 643 k Transaction Summary ================================================================================= Install 1 Package (+1 Dependent package) Total download size: 41 M Installed size: 188 M Downloading packages: (1/2): libobclient-2.0.0-2.el7.x86_64.rpm | 643 kB 00:00:00 (2/2): obclient-2.0.0-2.el7.x86_64.rpm 44% [======================== ] 1.3 MB/s | 18 MB 00:00:16 ETA (2/2): obclient-2.0.0-2.el7.x86_64.rpm 44% [===========(2/2): obclient-2.0.0-2.el7.x86_64.rpm 44% [===========(2/2): obclient-2.0.0-2.el7.x86_64.rpm | 40 MB 00:00:30 --------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 1.3 MB/s | 41 MB 00:00:30 Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : libobclient-2.0.0-2.el7.x86_64 1/2 Installing : obclient-2.0.0-2.el7.x86_64 2/2 Verifying : libobclient-2.0.0-2.el7.x86_64 1/2 Verifying : obclient-2.0.0-2.el7.x86_64 2/2 Installed: obclient.x86_64 0:2.0.0-2.el7 Dependency Installed: libobclient.x86_64 0:2.0.0-2.el7 Complete!
启动集群并尝试登录
[root@ecs-7732 ~]# obd cluster start demo Get local repositories and plugins ok Open ssh connection ok Cluster param config check ok Check before start observer ok [WARN] (127.0.0.1) The recommended value of fs.aio-max-nr is 1048576 (Current value: 65536) [WARN] (127.0.0.1) The recommended number of open files is 655350 (Current value: 65535) [WARN] (127.0.0.1) clog and data use the same disk (/) Start observer ok observer program health check ok Connect to observer ok Initialize cluster Cluster bootstrap ok Wait for observer init ok +---------------------------------------------+ | observer | +-----------+---------+------+-------+--------+ | ip | version | port | zone | status | +-----------+---------+------+-------+--------+ | 127.0.0.1 | 3.1.1 | 2881 | zone1 | active | +-----------+---------+------+-------+--------+ demo running [root@ecs-7732 ~]# obclient -h127.0.01 -P2881 -uroot Welcome to the OceanBase. Commands end with ; or \g. Your MySQL connection id is 3221487629 Server version: 5.7.25 OceanBase 3.1.1 (r4-8c615943cbd25a6f7b8bdfd8677a13a21709a05e) (Built Oct 21 2021 10:33:14) Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MySQL [(none)]> \q Bye [root@ecs-7732 ~]#
OceanBase 社区版入门到实战教程直播正在进行中~
快和小伙伴一起进群交流学习吧~
加入直播群方式一:
钉钉群号 3582 5151
加入直播群方式二:
扫码下方二维码加入