一、安裝并啟動(dòng)
zhinian@192 ~ % docker pull centos:7
zhinian@192 ~ % mkdir -p ~/Desktop/docker_test
zhinian@192 ~ % cd ~/Desktop/docker_test
zhinian@192 docker_test % mkdir script ob_rpm
zhinian@192 docker_test % touch Dockerfile
zhinian@192 ob_rpm % wget https://mirrors.aliyun.com/oceanbase/community/stable/el/7/aarch64/oceanbase-ce-3.1.3-10100032022041510.el7.aarch64.rpm
zhinian@192 ob_rpm % wget https://mirrors.aliyun.com/oceanbase/community/stable/el/7/aarch64/oceanbase-ce-libs-3.1.3-10100032022041510.el7.aarch64.rpm
zhinian@192 ob_rpm % wget http://mirror.centos.org/altarch/7/os/aarch64/Packages/libatomic-8.3.1-2.1.1.el7.aarch64.rpm
zhinian@192 ob_rpm % wget https://mirrors.aliyun.com/oceanbase/community/stable/el/7/aarch64/libobclient-2.0.1-3.el7.aarch64.rpm
zhinian@192 ob_rpm % wget https://mirrors.aliyun.com/oceanbase/community/stable/el/7/aarch64/obclient-2.0.1-2.el7.aarch64.rpm
zhinian@192 docker_test % ls -lrt ob_rpm
total 424152
-rw-r--r--@ 1 zhinian staff 148136 12 13 00:30 oceanbase-ce-libs-3.1.3-10100032022041510.el7.aarch64.rpm
-rw-r--r--@ 1 zhinian staff 35284 12 13 00:30 libatomic-8.3.1-2.1.1.el7.aarch64.rpm
-rw-r--r--@ 1 zhinian staff 38365872 12 13 00:30 oceanbase-ce-3.1.3-10100032022041510.el7.aarch64.rpm
-rw-r--r--@ 1 zhinian staff 859640 12 13 00:30 libobclient-2.0.1-3.el7.aarch64.rpm
-rw-r--r--@ 1 zhinian staff 177748640 12 13 00:34 obclient-2.0.1-2.el7.aarch64.rpm
zhinian@192 script % vim mkdir_ob.sh
mkdir -p /home/admin/oceanbase/store/obtest/{sstable,clog,ilog,slog}
chown -R admin:admin /home/admin/oceanbase
zhinian@192 script % vim mkdir_ob.sh
echo 'export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:~/oceanbase/lib' >> ~/.bash_profile
source ~/.bash_profile
cd ~/oceanbase && bin/observer -i lo -p 2881 -P 2882 -z zone1 -d ~/oceanbase/store/obtest -r '127.0.0.1' -c 1 -n obtest -o "memory_limit=8G,cache_wash_threshold=1G,__min_full_resource_pool_memory=268435456,system_memory=4G,memory_chunk_cache_size=128M,cpu_count=16,net_thread_count=4,datafile_size=10G,stack_size=1536K"
zhinian@192 docker_test % vim Dockerfile
FROM centos:7
RUN useradd -ms /bin/bash admin
ADD ./ob_rpm/*.rpm /opt/ob_rpm/
RUN yum install -y /opt/ob_rpm/*.rpm && yum clean all && rm -rf /opt/ob_rpm
COPY ./script/mkdir_ob.sh /home/admin
RUN sh /home/admin/mkdir_ob.sh
USER admin
COPY ./script/init_ob.sh /home/admin
WORKDIR /home/admin
RUN sh /home/admin/init_ob.sh
CMD ["/bin/bash"]
zhinian@192 docker_test % mv obce-3.1.3-for-mac-m1-v1 Dockerfile
zhinian@192 docker_test % docker run -itd --name obce-3.1.3-bp1 --privileged obce-3.1.3-for-mac-m1-v1
2b5d75e03403bc8bd5bff1ed6cd7c3e87305e256dd2624b6510097cfdb25679c
docker exec -it obce-3.1.3-bp1 /bin/bash
sh init_ob.sh
[admin@2b5d75e03403 ~]$ obclient -h127.0.0.1 -P2881 -uroot -p
Enter password:
Welcome to the OceanBase. Commands end with ; or \g.
Your MySQL connection id is 3221225472
Server version: 5.7.25 OceanBase 3.1.3 (r10100032022041510-a09d3134c10665f03fd56d7f8bdd413b2b771977) (Built Apr 15 2022 02:16:17)
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)]> set ob_query_timeout=100000000000;
Query OK, 0 rows affected (0.002 sec)
MySQL [(none)]> alter system bootstrap ZONE 'zone1' SERVER '127.0.0.1:2882';
Query OK, 0 rows affected (14.895 sec)
MySQL [(none)]> select version();
+--------------------+
| version() |
+--------------------+
| 3.1.3-OceanBase CE |
+--------------------+
1 row in set (0.001 sec)
測(cè)試登錄
設(shè)置密碼
SET PASSWORD = PASSWORD('xxx');
參考
如何在MAC M1玩OceanBase
關(guān)于Docker中failed to solve with frontend dockerfile.v0: failed to read dockerfile:報(bào)錯(cuò)
Navicat 現(xiàn)已支持 OceanBase 企業(yè)版
OceanBase 社區(qū)版圖形化客戶(hù)端推薦
噗…
# 根據(jù)當(dāng)前容器部署最大規(guī)格的實(shí)例
docker run -p 2881:2881 --name obstandalone -d oceanbase/oceanbase-ce
## 部署 mini 的獨(dú)立實(shí)例
docker run -p 2881:2881 --name obstandalone -e MINI_MODE=1 -d oceanbase/oceanbase-ce
$ docker logs obstandalone | tail -1
boot success!
docker exec -it obstandalone ob-mysql sys # 連接 sys 租戶(hù)的 root 用戶(hù)
docker exec -it obstandalone ob-mysql root # 連接 test 租戶(hù)的 root 用戶(hù)
docker exec -it obstandalone ob-mysql test # 連接 test 租戶(hù)的 test 用戶(hù)
set password = Password('your password');
文章來(lái)源：http://www.zghlxwxcb.cn/news/detail-814372.html
參考: 安裝OB navicat連接ob
Navicat連接OB成功！文章來(lái)源地址http://www.zghlxwxcb.cn/news/detail-814372.html
到了這里，關(guān)于MacM1Pro安裝OceanBase的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
