原 在Docker环境中快速体验YMatrix数据库

发布日期 2023年4月6日 · 已更新 2023年12月12日  

0    155    1

Tags： 原创Docker快速体验容器MPP国产YMatrix

👉 本文共约674个字，系统预计阅读时间或需3分钟。

显示/隐藏全文目录

目录

• 环境准备
• 启动
• 远程访问
• web界面管理
• 数据库管理
• 监控检查
• 参考

环境准备

docker rm -f lhrmatrixdb docker run -itd --name lhrmatrixdb -h lhrmatrixdb \ -p 5432:5432 -p 8240:8240 -p 8086:8086 -p 33389:3389 \ -v /sys/fs/cgroup:/sys/fs/cgroup \ --privileged=true lhrbest/matrixdb:5.0 \ /usr/sbin/init

1 2 3 4 5 6 7 8

docker rm -f lhrmatrixdb docker run -itd --name lhrmatrixdb -h lhrmatrixdb \ -p 5432:5432 -p 8240:8240 -p 8086:8086 -p 33389:3389 \   -v /sys/fs/cgroup:/sys/fs/cgroup \   --privileged=true lhrbest/matrixdb:5.0 \   /usr/sbin/init

启动

docker exec -it lhrmatrixdb bash su - mxadmin mxstart -a

1 2 3 4

docker exec -it lhrmatrixdb bash   su - mxadmin mxstart -a

示例：

[root@lhrdb ~]# docker run -itd --name lhrmatrixdb -h lhrmatrixdb \ > -p 5432:5432 -p 8240:8240 -p 8086:8086 -p 33389:3389 \ > -v /sys/fs/cgroup:/sys/fs/cgroup \ > --privileged=true lhrbest/matrixdb:5.0 \ > /usr/sbin/init 8787d19fc67bd564929b48f09899fc7ef799ebd89db537d1030e388716854ca3 [root@lhrdb ~]# [root@lhrdb ~]# docker exec -it lhrmatrixdb bash [root@lhrmatrixdb /]# su - mxadmin Last login: Thu Apr 6 15:57:41 CST 2023 ********** MatrixDB Administrator ********** The MatrixDB on 5432 is not running Start the database with mxstart -a ******************************************** [mxadmin@lhrmatrixdb ~]$ mxstart -a 2023-04-06:16:08:12.735 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Starting MatrixDB cluster with: [no-prompt:true]. 2023-04-06:16:08:12.735 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Connecting to physical cluster's etcd cluster ... 2023-04-06:16:08:12.747 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Connected to physical cluster's etcd cluster: [http://172.71.0.2:4679]. 2023-04-06:16:08:12.747 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Collecting database cluster ID ... 2023-04-06:16:08:12.747 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Collected database cluster ID: K5wAqr8EDiRFPT8Dhbi9ew 2023-04-06:16:08:12.754 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Collecting cluster info ... 2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:---------------------------- 2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Master instance parameters 2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:---------------------------- 2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Master Host = lhrmatrixdb 2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Master Port = 5432 2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Master Directory = /mxdata_20230406130924/master/mxseg-1 2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:---------------------------------------- 2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Segment instances that will be started 2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:---------------------------------------- 2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Host Port DataDir Role 2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-lhrmatrixdb 6000 /mxdata_20230406130924/primary/mxseg0 PRIMARY 2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-lhrmatrixdb 6001 /mxdata_20230406130924/primary/mxseg1 PRIMARY 2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-lhrmatrixdb 6002 /mxdata_20230406130924/primary/mxseg2 PRIMARY 2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-lhrmatrixdb 6003 /mxdata_20230406130924/primary/mxseg3 PRIMARY 2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Commencing parallel primary and mirror segment instance startup, please wait ... 2023-04-06:16:08:12.763 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Send start to cluster service 2023-04-06:16:08:16.319 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-DB instances process started. Waiting for status in-sync ... 2023-04-06:16:08:17.328 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Database instance started and status is in sync. 2023-04-06:16:08:17.346 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Send reload request to cluster service 2023-04-06:16:08:18.410 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Cluster GUC reloaded. 2023-04-06:16:08:18.416 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-MatrixDB cluster successfully started. [mxadmin@lhrmatrixdb ~]$ [mxadmin@lhrmatrixdb ~]$ psql -d postgres psql (12) Type "help" for help. postgres=#

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51

[root@lhrdb ~]# docker run -itd --name lhrmatrixdb -h lhrmatrixdb \ >  -p 5432:5432 -p 8240:8240 -p 8086:8086 -p 33389:3389 \ >   -v /sys/fs/cgroup:/sys/fs/cgroup \ >   --privileged=true lhrbest/matrixdb:5.0 \ >   /usr/sbin/init 8787d19fc67bd564929b48f09899fc7ef799ebd89db537d1030e388716854ca3 [root@lhrdb ~]# [root@lhrdb ~]# docker exec -it lhrmatrixdb bash [root@lhrmatrixdb /]# su - mxadmin Last login: Thu Apr  6 15:57:41 CST 2023   ********** MatrixDB Administrator **********   The MatrixDB on 5432 is not running   Start the database with      mxstart -a ********************************************   [mxadmin@lhrmatrixdb ~]$  mxstart -a 2023-04-06:16:08:12.735 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Starting MatrixDB cluster with: [no-prompt:true]. 2023-04-06:16:08:12.735 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Connecting to physical cluster's etcd cluster ... 2023-04-06:16:08:12.747 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Connected to physical cluster's etcd cluster: [http://172.71.0.2:4679]. 2023-04-06:16:08:12.747 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Collecting database cluster ID ... 2023-04-06:16:08:12.747 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Collected database cluster ID: K5wAqr8EDiRFPT8Dhbi9ew 2023-04-06:16:08:12.754 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Collecting cluster info ... 2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:---------------------------- 2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Master instance parameters 2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:---------------------------- 2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Master Host         = lhrmatrixdb 2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Master Port         = 5432 2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Master Directory    = /mxdata_20230406130924/master/mxseg-1 2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:---------------------------------------- 2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Segment instances that will be started 2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:---------------------------------------- 2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Host          Port    DataDir                                 Role       2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-lhrmatrixdb   6000    /mxdata_20230406130924/primary/mxseg0   PRIMARY   2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-lhrmatrixdb   6001    /mxdata_20230406130924/primary/mxseg1   PRIMARY   2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-lhrmatrixdb   6002    /mxdata_20230406130924/primary/mxseg2   PRIMARY   2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-lhrmatrixdb   6003    /mxdata_20230406130924/primary/mxseg3   PRIMARY   2023-04-06:16:08:12.756 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Commencing parallel primary and mirror segment instance startup, please wait ... 2023-04-06:16:08:12.763 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Send start to cluster service 2023-04-06:16:08:16.319 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-DB instances process started. Waiting for status in-sync ... 2023-04-06:16:08:17.328 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Database instance started and status is in sync. 2023-04-06:16:08:17.346 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Send reload request to cluster service 2023-04-06:16:08:18.410 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-Cluster GUC reloaded. 2023-04-06:16:08:18.416 mxstart:mxadmin:lhrmatrixdb:000505-[INFO]:-MatrixDB cluster successfully started. [mxadmin@lhrmatrixdb ~]$ [mxadmin@lhrmatrixdb ~]$ psql -d postgres psql (12) Type "help" for help.   postgres=#

远程访问

[root@lhrdb ~]# psql -U mxadmin -h 192.18.0.14 -p5432 -d postgres Password for user mxadmin: psql (14.7, server 12) Type "help" for help. postgres=# \l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+---------+----------+------------+------------+--------------------- matrixmgr | mxadmin | UTF8 | en_US.utf8 | en_US.utf8 | postgres | mxadmin | UTF8 | en_US.utf8 | en_US.utf8 | template0 | mxadmin | UTF8 | en_US.utf8 | en_US.utf8 | =c/mxadmin + | | | | | mxadmin=CTc/mxadmin template1 | mxadmin | UTF8 | en_US.utf8 | en_US.utf8 | =c/mxadmin + | | | | | mxadmin=CTc/mxadmin (4 rows) postgres=# select version(); version --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- PostgreSQL 12 (MatrixDB 5.0.0+community) (Greenplum Database 7.0.0+dev.20476.g346be35d90 build commit:346be35d90d3b69877dc6262b163f68bd08b902c) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.2.1 20220127 (Red Hat 11.2.1-9), 64-bit compiled on Mar 31 2023 08:22:55 (1 row) postgres=# postgres=# select * from gp_segment_configuration ; dbid | content | role | preferred_role | mode | status | port | hostname | address | datadir ------+---------+------+----------------+------+--------+------+-------------+-------------+--------------------------------------- 1 | -1 | p | p | n | u | 5432 | lhrmatrixdb | lhrmatrixdb | /mxdata_20230406130924/master/mxseg-1 2 | 0 | p | p | n | u | 6000 | lhrmatrixdb | lhrmatrixdb | /mxdata_20230406130924/primary/mxseg0 5 | 3 | p | p | n | u | 6003 | lhrmatrixdb | lhrmatrixdb | /mxdata_20230406130924/primary/mxseg3 3 | 1 | p | p | n | u | 6001 | lhrmatrixdb | lhrmatrixdb | /mxdata_20230406130924/primary/mxseg1 4 | 2 | p | p | n | u | 6002 | lhrmatrixdb | lhrmatrixdb | /mxdata_20230406130924/primary/mxseg2 (5 rows) postgres=#

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35

[root@lhrdb ~]# psql -U mxadmin -h 192.18.0.14 -p5432 -d postgres Password for user mxadmin: psql (14.7, server 12) Type "help" for help.   postgres=# \l                                List of databases    Name    |  Owner  | Encoding |  Collate   |   Ctype    |  Access privileges   -----------+---------+----------+------------+------------+--------------------- matrixmgr | mxadmin | UTF8     | en_US.utf8 | en_US.utf8 | postgres  | mxadmin | UTF8     | en_US.utf8 | en_US.utf8 | template0 | mxadmin | UTF8     | en_US.utf8 | en_US.utf8 | =c/mxadmin         +            |         |          |            |            | mxadmin=CTc/mxadmin template1 | mxadmin | UTF8     | en_US.utf8 | en_US.utf8 | =c/mxadmin         +            |         |          |            |            | mxadmin=CTc/mxadmin (4 rows)   postgres=# select version();                                                                                                                                   version                                                                                                                                   --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- PostgreSQL 12 (MatrixDB 5.0.0+community) (Greenplum Database 7.0.0+dev.20476.g346be35d90 build commit:346be35d90d3b69877dc6262b163f68bd08b902c) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.2.1 20220127 (Red Hat 11.2.1-9), 64-bit compiled on Mar 31 2023 08:22:55 (1 row)   postgres=# postgres=# select * from gp_segment_configuration ; dbid | content | role | preferred_role | mode | status | port |  hostname   |   address   |                datadir                 ------+---------+------+----------------+------+--------+------+-------------+-------------+---------------------------------------     1 |      -1 | p    | p              | n    | u      | 5432 | lhrmatrixdb | lhrmatrixdb | /mxdata_20230406130924/master/mxseg-1     2 |       0 | p    | p              | n    | u      | 6000 | lhrmatrixdb | lhrmatrixdb | /mxdata_20230406130924/primary/mxseg0     5 |       3 | p    | p              | n    | u      | 6003 | lhrmatrixdb | lhrmatrixdb | /mxdata_20230406130924/primary/mxseg3     3 |       1 | p    | p              | n    | u      | 6001 | lhrmatrixdb | lhrmatrixdb | /mxdata_20230406130924/primary/mxseg1     4 |       2 | p    | p              | n    | u      | 6002 | lhrmatrixdb | lhrmatrixdb | /mxdata_20230406130924/primary/mxseg2 (5 rows)   postgres=#

web界面管理

http://192.18.0.14:8240 密码：lhr

本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！

后续精彩内容已被站长无情隐藏，请输入验证码解锁本文！

验证码：

获取验证码： 请先关注本站微信公众号，然后回复“验证码”，获取验证码。在微信里搜索“AiDBA”或者“dbaup6”或者微信扫描右侧二维码都可以关注本站微信公众号。

相关文章

• 在Docker中快速体验CBDB数据库
• 在官方Docker环境中快速体验YMatrix数据库
• 在Docker中运行Windows系统（把 Windows 装进 Docker 容器里）
• 在Docker中快速体验崖山YashanDB数据库
• 在Docker中快速使用各个版本的GreenPlum数据库
• 在Docker中快速体验GreenPlum 7.0.0和gpcc 7.0.0
• YMatrix数据库单机安装
• YMatrix数据库巡检脚本
• 在Docker中快速使用各个版本的MySQL数据库
• 在Docker中快速使用各个版本（从10g到23ai）的Oracle数据库
• 【DB宝14】在Docker中只需2步即可拥有Oracle 11g企业版环境（11.2.0.4）
• 【DB宝13】在Docker中只需2步即可拥有Oracle 12cR1(12.1.0.2)企业版环境
• 【DB宝11】在Docker中只需2步即可拥有Oracle 11g企业版环境（11.2.0.3）
• 【DB宝10】在Docker中只需2步即可拥有Oracle 18c环境
• 【DB宝4】只需2步即可拥有Oracle19c的ASM+DB环境
• 人大金仓KingBase KES官方Docker版使用
• CBDB的单机安装
• 国内Docker Hub镜像加速器还有哪些可用？ 解决Docker镜像无法拉取问题（持续更新）
• 创建或启动容器报错Error response from daemon network bridge is ambiguous (2 matches found on name)及删除多余的bridge时报错Error response from daemon bridge is a pre-defined network and cannot be removed
• docker容器内不能ping通宿主机的网络环境

打赏赞(1)分享

标签： 原创Docker快速体验容器MPP国产YMatrix

小麦苗

学习或考证，均可联系麦老师，请加微信db_bao或QQ646634621

• 下一篇 在Docker中快速体验Oracle 23c免费开发者版
• 上一篇 YMatrix数据库单机安装

您可能还喜欢...

• 0

  小麦苗数据库巡检脚本，支持Oracle、MySQL、SQL Server、PG等21种数据库

  2021年5月31日

   由 小麦苗 · Published 2021年5月31日 · Last modified 2024年4月30日

  · 已更新 2024年4月30日  

  0    44761    35
• 0

  GreenPlum备份恢复工具之gpbackup和gprestore

  2023年3月3日

   由 小麦苗 · Published 2023年3月3日 · Last modified 2024年10月25日

  · 已更新 2024年10月25日  

  0    440    3
• 0

  docker容器内不能ping通宿主机的网络环境

  2023年8月7日

   由 小麦苗 · Published 2023年8月7日

   

  0    276    1