实践练习一（必选）：OceanBase Docker 体验（小麦苗版）

实践练习一（必选）：OceanBase Docker 体验（小麦苗版）

说明

相关连接：

OceanBase Docker 容器，快速的体验 OceanBase 的 自动化部署过程，以及了解 OceanBase 集群安装成功后的目录特点和使用方法。

练习条件

有笔记本或服务器，内存至少12G 。操作系统不限，能安装 Docker 环境即可。

练习内容

请记录并分享下列内容：

（必选）下载Docker 镜像：。（必选）使用 OBD 命令完成后续的 OceanBase 集群部署。（必选）创建一个业务租户、一个业务数据库，以及一些表等。

安装Docker

参考：运行在 CentOS 7 上，要求系统为64位、系统内核版本为 3.10 以上。CentOS 7 的内核一般都是3.10的，而CentOS 6.X 的内核一般都是2.6，在2.6的内核下，Docker运行会比较卡，所以一般会选择升级到3.10版本。

1、卸载掉旧版本的 Docker：yum remove -y docker docker-client docker-client-latest docker-common docker-latest docker-latest-logrotate docker-logrotate docker-selinux docker-engine-selinux docker-engine2、执行以下安装命令去安装依赖包：yum install -y yum-utils device-mapper-persistent-data lvm2yum-config-manager --add-repo -y install docker-ce docker-ce-cli containerd.io# 若执行报错，则配置yum源wget -O /etc/yum.repos.d/CentOS-Base.repo -O /etc/yum.repos.d/epel.repo start dockersystemctl status docker3、检查版本docker versiondocker info

也可以一键安装Docker：

curl -fsSL get.docker.com -o get-docker.shsh get-docker.sh

安装完成：

[root@lhrdocker ~]# docker psCannot connect to the Docker daemon at unix:///var/run/docker.sock. Is the docker daemon running?[root@lhrdocker ~]# systemctl start dockersystemctl status docker[root@lhrdocker ~]# systemctl status docker● docker.service - Docker Application Container Engine Loaded: loaded (/usr/lib/systemd/system/docker.service; disabled; vendor preset: disabled) Active: active (running) since Wed 2020-06-24 13:12:56 CST; 1s ago Docs: Main PID: 9348 (dockerd) Memory: 38.4M CGroup: /system.slice/docker.service └─9348 /usr/bin/dockerd -H fd:// --containerd=/run/containerd/containerd.sockJun 24 13:12:56 lhrdocker dockerd[9348]: time="2020-06-24T13:12:56.403432651+08:00" level=info msg="ccResolverWrappe...e=grpcJun 24 13:12:56 lhrdocker dockerd[9348]: time="2020-06-24T13:12:56.403438749+08:00" level=info msg="ClientConn switc...e=grpcJun 24 13:12:56 lhrdocker dockerd[9348]: time="2020-06-24T13:12:56.422565741+08:00" level=info msg="Loading containe...tart."Jun 24 13:12:56 lhrdocker dockerd[9348]: time="2020-06-24T13:12:56.498364397+08:00" level=info msg="Default bridge (...dress"Jun 24 13:12:56 lhrdocker dockerd[9348]: time="2020-06-24T13:12:56.586263842+08:00" level=info msg="Loading containe...done."Jun 24 13:12:56 lhrdocker dockerd[9348]: time="2020-06-24T13:12:56.614176483+08:00" level=warning msg="Not using nat...erlay2Jun 24 13:12:56 lhrdocker dockerd[9348]: time="2020-06-24T13:12:56.614312232+08:00" level=info msg="Docker daemon" c....03.12Jun 24 13:12:56 lhrdocker dockerd[9348]: time="2020-06-24T13:12:56.614366802+08:00" level=info msg="Daemon has compl...ation"Jun 24 13:12:56 lhrdocker dockerd[9348]: time="2020-06-24T13:12:56.700953028+08:00" level=info msg="API listen on /v....sock"Jun 24 13:12:56 lhrdocker systemd[1]: Started Docker Application Container Engine.Hint: Some lines were ellipsized, use -l to show in full.

Cceanbase docker版本体验

下载ob docker镜像

-- 下载docker pull obpilot/oceanbase-ce:latestdocker run -itd -m 10G -p 2881:2881 -p 2883:2883 --name oceanbase-ce obpilot/oceanbase-ce:latest配置文件：/home/admin/.obd/cluster/obdemo/config.yamldocker exec -it oceanbase-ce bash-- 进入容器后，可以看看 readme.md 文档，然后启动集群：# 查看集群列表obd cluster list# 启动集群 obd cluster start obdemoadmin 用户的密码是 : adminPWD123 . 您可以使用 sudo yum 安装软件包。-- create an oceanbase mysql tenantobclient -h127.1 -uroot@sys#obce-single -P2883 -prootPWD123 -c -A oceanbasealter resource unit sys_unit_config min_cpu=5;CREATE resource unit S4C1G max_cpu=4, min_cpu=4, max_memory='1G', min_memory='1G', max_iops=10000, min_iops=1000, max_session_num=1000000, max_disk_size='1024G';CREATE resource pool my_pool unit = 'S4C1G', unit_num = 1;create tenant obmysql resource_pool_list=('my_pool'), primary_zone='RANDOM',comment 'mysql tenant/instance', charset='utf8' set ob_tcp_invited_nodes='%', ob_compatibility_mode='mysql';exit;-- log in to the obmysql tenantobclient -h 127.1 -uroot@obmysql#obdemo -P2883 -p -c -A testempty password.show databases;

地址：~]# docker pull obpilot/oceanbase-ceUsing default tag: latestlatest: Pulling from obpilot/oceanbase-ce7a0437f04f83: Already exists 615dc48ac9f1: Pull complete b10c1cdae3af: Pull complete 4f4fb700ef54: Pull complete c0f6c94a6a6a: Pull complete 792630f35e24: Pull complete Digest: sha256:7ac28415cf27ba19cb47acb67a55ebf9848ad73a63d80b7e2e85d653233dbaebStatus: Downloaded newer image for obpilot/oceanbase-ce:latestdocker.io/obpilot/oceanbase-ce:latest[root@docker35 ~]# docker images | grep oceanbaseobpilot/oceanbase-ce latest 943379e0b05b 4 weeks ago 2.25GBobpilot/oceanbase-ce c3ac45532094 4 months ago 2.24GBoceanbase/obce-mini latest 1a5ca6d233a7 4 months ago 690MB[root@docker35 ~]# docker run -itd -m 10G -p 2881:2881 -p 2883:2883 --name oceanbase-ce obpilot/oceanbase-ce:latestdocker: Error response from daemon: Conflict. The container name "/oceanbase-ce" is already in use by container "2a86c75456b5509b21e5e6981ba5fd53826c2f630d7b06d3145140436f024db3". You have to remove (or rename) that container to be able to reuse that name.See 'docker run --help'.[root@docker35 ~]# docker rm -f oceanbase-ceoceanbase-ce[root@docker35 ~]# docker run -itd -m 10G -p 2881:2881 -p 2883:2883 --name oceanbase-ce obpilot/oceanbase-ce:latest0209306f10bf1c49fb58ffee65ac2b17f3ce3c0b4c2884eca57f3af5464babf4[root@docker35 ~]# [root@docker35 ~]# docker exec -it oceanbase-ce bash

使用obd工具查看集群及启动

[root@docker35 ~]# docker exec -it oceanbase-ce bash[admin@0209306f10bf ~]$ obd cluster list+------------------------------------------------------------+| Cluster List |+--------+---------------------------------+-----------------+| Name | Configuration Path | Status (Cached) |+--------+---------------------------------+-----------------+| obdemo | /home/admin/.obd/cluster/obdemo | deployed |+--------+---------------------------------+-----------------+[admin@0209306f10bf ~]$ obd cluster start obdemoGet local repositories and plugins okOpen ssh connection okCluster param config check okCheck before start observer okCheck before start obproxy okStart observer okobserver program health check okConnect to observer okInitialize clusterCluster bootstrap okWait for observer init ok+---------------------------------------------+| observer |+-----------+---------+------+-------+--------+| ip | version | port | zone | status |+-----------+---------+------+-------+--------+| 127.0.0.1 | 3.1.1 | 2881 | zone1 | active |+-----------+---------+------+-------+--------+Start obproxy okobproxy program health check okConnect to obproxy okInitialize cluster+---------------------------------------------+| obproxy |+-----------+------+-----------------+--------+| ip | port | prometheus_port | status |+-----------+------+-----------------+--------+| 127.0.0.1 | 2883 | 2884 | active |+-----------+------+-----------------+--------+obdemo running[admin@0209306f10bf ~]$ obd cluster list +------------------------------------------------------------+| Cluster List |+--------+---------------------------------+-----------------+| Name | Configuration Path | Status (Cached) |+--------+---------------------------------+-----------------+| obdemo | /home/admin/.obd/cluster/obdemo | running |+--------+---------------------------------+-----------------+

登录ob数据库并创建租户

[admin@0209306f10bf ~]$ obclient -h127.1 -uroot@sys#obce-single -P2883 -prootPWD123 -c -A oceanbaseWelcome to the OceanBase. Commands end with ; or \g.Your MySQL connection id is 4Server version: 5.6.25 OceanBase 3.1.1 (r4-8c615943cbd25a6f7b8bdfd8677a13a21709a05e) (Built Oct 21 2021 10:52:05)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 [oceanbase]> show databases; +--------------------+| Database |+--------------------+| oceanbase || information_schema || mysql || SYS || LBACSYS || ORAAUDITOR || test |+--------------------+7 rows in set (0.005 sec)

创建资源单元、资源池、租户

MySQL [oceanbase]> CREATE resource unit S4C1G max_cpu=4, min_cpu=4, max_memory='1G', min_memory='1G', max_iops=10000, min_iops=1000, max_session_num=1000000, max_disk_size='1024G'; Query OK, 0 rows affected (0.006 sec)MySQL [oceanbase]> CREATE resource pool my_pool unit = 'S4C1G', unit_num = 1;Query OK, 0 rows affected (0.011 sec)MySQL [oceanbase]> create tenant obmysql resource_pool_list=('my_pool'), primary_zone='RANDOM',comment 'mysql tenant/instance', charset='utf8' set ob_tcp_invited_nodes='%', ob_compatibility_mode='mysql';Query OK, 0 rows affected (0.612 sec)MySQL [oceanbase]>

登录obmysql tenant并创建数据库及表等

[admin@0209306f10bf ~]$ obclient -h 127.1 -uroot@obmysql#obce-single -P2883 -p -c -A testEnter password: Welcome to the OceanBase. Commands end with ; or \g.Your MySQL connection id is 8Server version: 5.6.25 OceanBase 3.1.1 (r4-8c615943cbd25a6f7b8bdfd8677a13a21709a05e) (Built Oct 21 2021 10:52:05)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 [test]> show databases;+--------------------+| Database |+--------------------+| oceanbase || information_schema || mysql || test |+--------------------+4 rows in set (0.017 sec)MySQL [test]> create database lhrdb charset utf8mb4;Query OK, 1 row affected (0.168 sec)MySQL [test]> use lhrdb;Database changedMySQL [lhrdb]> source /tmp/mysql_employees.sqlQuery OK, 0 rows affected (0.001 sec)Query OK, 0 rows affected (0.001 sec)Query OK, 0 rows affected (0.001 sec)Query OK, 0 rows affected (0.001 sec)Query OK, 0 rows affected (0.001 sec)Query OK, 0 rows affected, 1 warning (0.004 sec)Query OK, 0 rows affected (0.001 sec)Query OK, 0 rows affected (0.001 sec)Query OK, 0 rows affected (0.001 sec).....MySQL [lhrdb]> show tables;+-----------------+| Tables_in_lhrdb |+-----------------+| departments || job_grades || jobs || late || locations |+-----------------+5 rows in set (0.018 sec)MySQL [lhrdb]> select * from jobs;+------------+---------------------------------+------------+------------+| job_id | job_title | min_salary | max_salary |+------------+---------------------------------+------------+------------+| AC_ACCOUNT | Public Accountant | 4200 | 9000 || AC_MGR | Accounting Manager | 8200 | 16000 || AD_ASST | Administration Assistant | 3000 | 6000 || AD_PRES | President | 20000 | 40000 || AD_VP | Administration Vice President | 15000 | 30000 || FI_ACCOUNT | Accountant | 4200 | 9000 || FI_MGR | Finance Manager | 8200 | 16000 || HR_REP | Human Resources Representative | 4000 | 9000 || IT_PROG | Programmer | 4000 | 10000 || MK_MAN | Marketing Manager | 9000 | 15000 || MK_REP | Marketing Representative | 4000 | 9000 || PR_REP | Public Relations Representative | 4500 | 10500 || PU_CLERK | Purchasing Clerk | 2500 | 5500 || PU_MAN | Purchasing Manager | 8000 | 15000 || SA_MAN | Sales Manager | 10000 | 20000 || SA_REP | Sales Representative | 6000 | 12000 || SH_CLERK | Shipping Clerk | 2500 | 5500 || ST_CLERK | Stock Clerk | 2000 | 5000 || ST_MAN | Stock Manager | 5500 | 8500 |+------------+---------------------------------+------------+------------+19 rows in set (0.003 sec)

总结

OB的docker版本比较简单。可以体验MySQL租户，缺点是不能体验Oracle租户。

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。