Matrixdb添加mirror

最新推荐文章于 2024-06-07 23:53:47 发布
最新推荐文章于 2024-06-07 23:53:47 发布
阅读量262 收藏
点赞数
分类专栏： Matrixdb 文章标签： database 大数据 时序数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_31493587/article/details/123901318
版权

Matrixdb添加mirror

查看系统配置表

[mxadmin@mdw ~]$ psql
psql (12)
Type "help" for help.

postgres=# SELECT * from gp_segment_configuration order by 1;
 dbid | content | role | preferred_role | mode | status | port | hostname | address |                datadir                
------+---------+------+----------------+------+--------+------+----------+---------+---------------------------------------
    1 |      -1 | p    | p              | n    | u      | 5432 | mdw      | mdw     | /mxdata_20220401161459/master/mxseg-1
    2 |       0 | p    | p              | n    | u      | 6000 | sdw1     | sdw1    | /mxdata_20220401161459/primary/mxseg0
    3 |       1 | p    | p              | n    | u      | 6000 | sdw2     | sdw2    | /mxdata_20220401161459/primary/mxseg1
    4 |       2 | p    | p              | n    | u      | 6000 | sdw3     | sdw3    | /mxdata_20220401161459/primary/mxseg2
    5 |       3 | p    | p              | n    | u      | 6000 | sdw4     | sdw4    | /mxdata_20220401161459/primary/mxseg3
(5 rows)

postgres=#

创建数据目录

在所有需要添加mirror的主机，创建存放mirror的数据目录

可以使用gpssh命令

[mxadmin@mdw ~]$ cat conf/seg_hosts 
sdw1
sdw2
sdw3
sdw4

[mxadmin@mdw ~]$ gpssh -f conf/seg_hosts -e 'mkdir -p /mxdata_20220401161459/mirror'
[sdw1] mkdir -p /mxdata_20220401161459/mirror
[sdw4] mkdir -p /mxdata_20220401161459/mirror
[sdw2] mkdir -p /mxdata_20220401161459/mirror
[sdw3] mkdir -p /mxdata_20220401161459/mirror
[mxadmin@mdw ~]$

生成addmirror文件

[mxadmin@mdw ~]$ gpaddmirrors -o ./addmirror
20220401:16:16:55:021712 gpaddmirrors:mdw:mxadmin-[INFO]:-Starting gpaddmirrors with args: -o ./addmirror
20220401:16:16:55:021712 gpaddmirrors:mdw:mxadmin-[INFO]:-local Greenplum Version: 'postgres (MatrixDB) 4.4.2-enterprise (Greenplum Database) 7.0.0+dev.17321.gcec99aeb59 build commit:cec99aeb598f5cc510ea6f2e8ebf828e71dc97d0'
20220401:16:16:55:021712 gpaddmirrors:mdw:mxadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 12 (MatrixDB 4.4.2-enterprise) (Greenplum Database 7.0.0+dev.17321.gcec99aeb59 build commit:cec99aeb598f5cc510ea6f2e8ebf828e71dc97d0) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 7.3.1 20180303 (Red Hat 7.3.1-5), 64-bit compiled on Mar 21 2022 09:09:55'
20220401:16:16:55:021712 gpaddmirrors:mdw:mxadmin-[INFO]:-Obtaining Segment details from master...
20220401:16:16:56:021712 gpaddmirrors:mdw:mxadmin-[INFO]:-Heap checksum setting consistent across cluster
Enter mirror segment data directory location 1 of 1 >
/mxdata_20220401161459/mirror
20220401:16:17:08:021712 gpaddmirrors:mdw:mxadmin-[INFO]:-Configuration file output to ./addmirror successfully.

查看文件内容如下

contentid  | host | port | data_dir   #contentid递增，但是primary=mirror
[mxadmin@mdw ~]$ cat addmirror 
0|sdw2|7000|/mxdata_20220401161459/mirror/mxseg0
1|sdw3|7000|/mxdata_20220401161459/mirror/mxseg1
2|sdw4|7000|/mxdata_20220401161459/mirror/mxseg2
3|sdw1|7000|/mxdata_20220401161459/mirror/mxseg

执行添加命令

[mxadmin@mdw ~]$ gpaddmirrors -i addmirror 
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Starting gpaddmirrors with args: -i addmirror
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-local Greenplum Version: 'postgres (MatrixDB) 4.4.2-enterprise (Greenplum Database) 7.0.0+dev.17321.gcec99aeb59 build commit:cec99aeb598f5cc510ea6f2e8ebf828e71dc97d0'
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 12 (MatrixDB 4.4.2-enterprise) (Greenplum Database 7.0.0+dev.17321.gcec99aeb59 build commit:cec99aeb598f5cc510ea6f2e8ebf828e71dc97d0) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 7.3.1 20180303 (Red Hat 7.3.1-5), 64-bit compiled on Mar 21 2022 09:09:55'
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Obtaining Segment details from master...
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Heap checksum setting consistent across cluster
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Greenplum Add Mirrors Parameters
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:----------------------------------------------------------
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Greenplum master data directory          = /mxdata_20220401161459/master/mxseg-1
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Greenplum master port                    = 5432
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Parallel batch limit                     = 16
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:----------------------------------------------------------
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Mirror 1 of 4
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:----------------------------------------------------------
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Primary instance host        = sdw1
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Primary instance address     = sdw1
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Primary instance directory   = /mxdata_20220401161459/primary/mxseg0
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Primary instance port        = 6000
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Mirror instance host         = sdw2
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Mirror instance address      = sdw2
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Mirror instance directory    = /mxdata_20220401161459/mirror/mxseg0
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Mirror instance port         = 7000
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:----------------------------------------------------------
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Mirror 2 of 4
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:----------------------------------------------------------
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Primary instance host        = sdw2
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Primary instance address     = sdw2
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Primary instance directory   = /mxdata_20220401161459/primary/mxseg1
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Primary instance port        = 6000
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Mirror instance host         = sdw3
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Mirror instance address      = sdw3
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Mirror instance directory    = /mxdata_20220401161459/mirror/mxseg1
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Mirror instance port         = 7000
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:----------------------------------------------------------
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Mirror 3 of 4
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:----------------------------------------------------------
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Primary instance host        = sdw3
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Primary instance address     = sdw3
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Primary instance directory   = /mxdata_20220401161459/primary/mxseg2
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Primary instance port        = 6000
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Mirror instance host         = sdw4
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Mirror instance address      = sdw4
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Mirror instance directory    = /mxdata_20220401161459/mirror/mxseg2
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Mirror instance port         = 7000
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:----------------------------------------------------------
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Mirror 4 of 4
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:----------------------------------------------------------
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Primary instance host        = sdw4
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Primary instance address     = sdw4
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Primary instance directory   = /mxdata_20220401161459/primary/mxseg3
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Primary instance port        = 6000
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Mirror instance host         = sdw1
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Mirror instance address      = sdw1
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Mirror instance directory    = /mxdata_20220401161459/mirror/mxseg3
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-   Mirror instance port         = 7000
20220401:16:17:40:021769 gpaddmirrors:mdw:mxadmin-[INFO]:----------------------------------------------------------

Continue with add mirrors procedure Yy|Nn (default=N):
> y
20220401:16:17:42:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Starting to modify pg_hba.conf on primary segments to allow replication connections
20220401:16:17:45:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Successfully modified pg_hba.conf on primary segments to allow replication connections
20220401:16:17:45:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-4 segment(s) to add
20220401:16:17:45:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Validating remote directories
20220401:16:17:45:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Configuring new segments
sdw2 (dbid 6): pg_basebackup: base backup completed
sdw3 (dbid 7): pg_basebackup: base backup completed
sdw4 (dbid 8): pg_basebackup: base backup completed
sdw1 (dbid 9): pg_basebackup: base backup completed
20220401:16:17:50:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Updating configuration with new mirrors
20220401:16:17:50:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Updating mirrors
20220401:16:17:50:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Starting mirrors
20220401:16:17:50:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-era is 801aaccd18b22093_220401161509
20220401:16:17:50:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Commencing parallel segment instance startup, please wait...
20220401:16:17:51:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Process results...
20220401:16:17:51:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-
20220401:16:17:51:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-
20220401:16:17:51:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-
20220401:16:17:51:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-
20220401:16:17:51:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-******************************************************************
20220401:16:17:51:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Mirror segments have been added; data synchronization is in progress.
20220401:16:17:51:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Data synchronization will continue in the background.
20220401:16:17:51:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-Use  gpstate -s  to check the resynchronization progress.
20220401:16:17:51:021769 gpaddmirrors:mdw:mxadmin-[INFO]:-******************************************************************

查看节点状态

[mxadmin@mdw ~]$ psql
psql (12)
Type "help" for help.

postgres=# SELECT * from gp_segment_configuration order by 1;
 dbid | content | role | preferred_role | mode | status | port | hostname | address |                datadir                
------+---------+------+----------------+------+--------+------+----------+---------+---------------------------------------
    1 |      -1 | p    | p              | n    | u      | 5432 | mdw      | mdw     | /mxdata_20220401161459/master/mxseg-1
    2 |       0 | p    | p              | s    | u      | 6000 | sdw1     | sdw1    | /mxdata_20220401161459/primary/mxseg0
    3 |       1 | p    | p              | s    | u      | 6000 | sdw2     | sdw2    | /mxdata_20220401161459/primary/mxseg1
    4 |       2 | p    | p              | s    | u      | 6000 | sdw3     | sdw3    | /mxdata_20220401161459/primary/mxseg2
    5 |       3 | p    | p              | s    | u      | 6000 | sdw4     | sdw4    | /mxdata_20220401161459/primary/mxseg3
    6 |       0 | m    | m              | s    | u      | 7000 | sdw2     | sdw2    | /mxdata_20220401161459/mirror/mxseg0
    7 |       1 | m    | m              | s    | u      | 7000 | sdw3     | sdw3    | /mxdata_20220401161459/mirror/mxseg1
    8 |       2 | m    | m              | s    | u      | 7000 | sdw4     | sdw4    | /mxdata_20220401161459/mirror/mxseg2
    9 |       3 | m    | m              | s    | u      | 7000 | sdw1     | sdw1    | /mxdata_20220401161459/mirror/mxseg3
(9 rows)

postgres=#
dba-石头
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
maven添加mirror_Maven mirror 配置
weixin_40008946的博客
12-19 1248
使用maven时，从来没仔细注意过setting配置节点的作用，直到今天配置总是不起作用，总是报错才开始去认识这些节点的含义。这里就说mirrorOf，因为其他的怎么配置基本上都不会出错，只有mirrorOf会导致莫名其妙的错误，如果你还不了解mirrorOf，请往下看，你会认识到mirrorOf的重要作用的。主要参考来自：或者在这里继续看下去：先说mirrors中mirror的作用，mirror...
maven添加mirror_maven 中配置多个mirror的问题
weixin_39612297的博客
12-19 1987
公司搭建的maven私服做镜像，有使用aliyun的镜像，还有其他地方的，默认情况下配置多个mirror的情况下，只有第一个生效。那么我们可以将最后一个作为默认值，前面配置的使用环境变量动态切换。通过 尝试settings.xml 使用变量解决。centralbeijinghttp://172.16.230.111:8081/nexus/content/groups/public/nexus-...
maven添加mirror_maven配置多个镜像如何实现 maven配置多个镜像实现方法
weixin_39543478的博客
12-19 2477
maven配置多个镜像如何实现？本篇文章小编给大家分享一下maven配置多个镜像实现方法，小编觉得挺不错的，现在分享给大家供大家参考，有需要的小伙伴们可以来看看。问题场景1、国内访问maven默认远程中央镜像特别慢2、用阿里的镜像替代远程中央镜像3、大部分jar包都可以在阿里镜像中找到，部分jar包在阿里镜像中没有，需要单独配置镜像解决方案settings.xml 中可以使用变量，可以尝试使用变量...
CodeMirror设置高度自适应
PiaoMiaoXiaodao的博客
04-12 1790
1.添加全局样式 .CodeMirror { border: 1px solid #eee; height: auto !important; /*min-height: 100px;*/ } .CodeMirror-scroll { height: auto !important; min-height: 100px; /*overflow-y: hidden;*/ /*overflow-x: auto;*/ } 2.html 允许设置最小高度
codeMirror 光标定位问题
qq_40197149的博客
10-26 1930
codeMirror 光标定位问题setCursor 方法的使用 setCursor 方法的使用 codeMirror.focus() setTimeout(()=>{ codeMirror.setCursor({line:1,ch:5}) },0)
maven mirror 优先级
心有猛虎细嗅蔷薇
08-15 7776
我的settings.xml一般这样设置： <?xml version="1.0" encoding="UTF-8"?> <settings xmlns="http://maven.apache.org/SETTINGS/1.0.0"           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instan...
CodeMirror文字比对
juliotang的博客
03-19 5581
因为一直想写一个文字比对的工具，所以研究了一下，采用了CodeViewer，官方地址：https://codemirror.net/ CodeViewer的核心是代码编辑器，但是文件比对的话可以直接用它的merge插件MergeView 因为我想放在自己的主站上，而我的主站采用angular7作为技术栈，所以这里以angular为例使用MergeView制作自己的文字比对工具 Angular引用C...
Vue 中使用 codemirror
前端技术
02-08 9519
一、安装 官网地址：https://codemirror.net/ npm 插件地址：https://www.npmjs.com/package/vue-codemirror vue 项目中安装， npminstallvue-codemirror--save 可在 package.json 文件中看到，当前是 4.0.6 版 二、使用 1、引入 这里是局部引入，vue 文件中引入 主题dracula 是目前我觉得还比较好看的样式，可在路径 node_modules\codem...
codemirror 光标定位_CodeMirror
weixin_34943809的博客
02-23 3090
下载后，解压开到的文件夹中，lib下是放的是核心库和核心css，模式下放的是各种支持语言的语法定义，主题目录下是支持的主题样式。一般在开发中，添加lib下的引用和模式下的引用就够了。使用示例首先，要引用是lib目录下的codemirror.js，还有一个就是同目录下的codemirror.css文件接下来要引用的就是在mode目录下编辑器中要编辑的语言对应的js文件，下面以js文件为例：引用的文件...
codemirror 简单使用
u013466380的博客
04-02 1806
代码压缩包地址 https://github.com/codemirror/codemirror1. 网页引用<script src="js/codemirror.js"></script>2. 网页引用<script src="js/clike.js"></script>（mode属性需要的js文件）3. 初始化编辑框生成var myTextare...
codemirror下载包
02-02
codemirror是一款代码在线编辑插件，这里是我下载的codemirror-5.65.11资源包，上传上来方便大家下载，尽快进入业务开发
Greenplum清除mirror
12-03
可以作为greenplummirror的参考，注意脚本内容和实际环境的区别，注意关注数据完整性。
chatgpt-mirror.rar
06-06
ChatGPT Mirror Based on model gpt-3.5-turbo. Installation Tested on Node.js 18.x. $ pnpm install Running the app Create a .env file in the root directory and add your OpenAI API key: OPENAI_API_KEY...
codemirror5.59.1
01-12
codemirror5.59.1
CodeMirror-master
11-03
CodeMirror-master，html可进行code编写并进行高亮显示。
常用的文件系统、存储类型小整理
Hehuyi_In的博客
02-07 3262
最近接触到了五花八门的文件系统、存储类型，名词听得头大，趁假期整理学习一番~
kafka-生产者监听器（SpringBoot整合Kafka）
小丁的博客
06-04 658
kafka-生产者监听器（SpringBoot整合Kafka）
大数据如何更好地助力乡村振兴战略的实施？
最新发布
xy520521的博客
06-07 184
智慧乡村建设：通过大数据技术和物联网技术，可以实现乡村各种设施的互联互通，构建智慧乡村，提供智能交通、智能安防、智能环保等服务，提高乡村的生活便利性和安全性。优化资源配置：通过大数据分析，可以了解到乡村的资源分布和利用情况，帮助政府和相关机构更好地进行资源调配和规划，确保资源的合理利用，提高决策的科学性和精确性。教育和医疗服务：大数据可以帮助乡村优化教育和医疗资源的分配，提供远程教育和医疗服务，弥补乡村教育和医疗资源的不足，提高乡村居民的生活质量。大数据可以在乡村振兴战略的实施中发挥重要的作用。
大数据的并行推理技术很重要，尤其在私有化部署大模型中，AI人工智能用到的技术
zhang9880000的博客
06-04 361
并行推理技术的原理基于并行计算的概念，即利用多个计算资源同时处理推理任务，以提高推理速度和效率。在深度学习中，推理是指使用已经训练好的模型对输入数据进行预测或分类的过程。而并行推理技术则是在这个推理过程中，将计算任务分配给多个计算资源同时进行计算，从而加速整个推理过程。
codemirror 添加对齐线
09-07
要在 CodeMirror 编辑器中添加对齐线，你可以使用 CSS 来实现。首先，你需要在 CodeMirror 的样式表中添加以下 CSS 代码： ```css .cm-align-line { position: absolute; pointer-events: none; border-left: 1...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值