Elasticsearch通过kibana将生产环境的表同步到测试环境

最新推荐文章于 2024-06-20 20:41:45 发布

AAA服务器重启王师傅

最新推荐文章于 2024-06-20 20:41:45 发布

阅读量607

点赞数

分类专栏： Elasticsearch单表同步文章标签： elasticsearch 大数据 big data

本文链接：https://blog.csdn.net/w184414332/article/details/125368883

版权

Elasticsearch单表同步专栏收录该内容

1 篇文章 0 订阅

订阅专栏

一、修改es存储路径

集群状态下三个都需要更改把测试路径修改成生产环境路径，这个生产环境es集群存储路径挂载的是NFS，所以直接修改即可

#修改es存储路径
#echo "es节点192.168.7.14正在配置线上快照库路径....."
sed -ri 's/^path.repo:\ \/data\/backup/#path.repo:\ \/data\/backup/g' /etc/elasticsearch/elasticsearch.yml
sed -ri 's/^#path.repo:\ \/data\/prod_esbak/path.repo:\ \/data\/prod_esbak/g' /etc/elasticsearch/elasticsearch.yml
systemctl restart elasticsearch

#echo "es节点192.168.7.15正在配置线上快照库路径......"
ssh root@192.168.10.15 "sed -ri 's/^path.repo:\ \/data\/backup/#path.repo:\ \/data\/backup/g' /etc/elasticsearch/elasticsearch.yml"
ssh root@192.168.7.15 "sed -ri 's/^#path.repo:\ \/data\/prod_esbak/path.repo:\ \/data\/prod_esbak/g' /etc/elasticsearch/elasticsearch.yml"
ssh root@192.168.7.15 "systemctl restart elasticsearch"

#echo "es节点192.168.7.16正在配置线上快照库路径......"
ssh root@192.168.7.16 "sed -ri 's/^path.repo:\ \/data\/backup/#path.repo:\ \/data\/backup/g' /etc/elasticsearch/elasticsearch.yml"
ssh root@192.168.7.16 "sed -ri 's/^#path.repo:\ \/data\/prod_esbak/path.repo:\ \/data\/prod_esbak/g' /etc/elasticsearch/elasticsearch.yml"
ssh root@192.168.7.16 "systemctl restart elasticsearch"

二、打开kibana

三、修改路径变更为(生产环境路径)

然后点击保存即可

四、打开es-head插件

输入http://192.168.7.14:9200

五、点击要同步的表

把这个关闭，不关闭不让同步

返回这个提示关闭成功

六、去kibana进行同步

默认是第一个

同步单表

选中要同步的表

然后直接点击下一步即可

还原成功，开发那边验证是没问题的我这里就不贴出来了

七、回到192.168.7.14把之前的路径还原回去

#还原es存储路径
3echo "es节点192.168.7.14正在还原默认配置....."
sed -ri 's/^path.repo:\ \/data\/prod_esbak/#path.repo:\ \/data\/prod_esbak/g' /etc/elasticsearch/elasticsearch.yml
sed -ri 's/^#path.repo:\ \/data\/backup/path.repo:\ \/data\/backup/g' /etc/elasticsearch/elasticsearch.yml
systemctl restart elasticsearch

echo "es节点192.168.7.15正在还原默认配置....."
ssh root@192.168.7.15 "sed -ri 's/^path.repo:\ \/data\/prod_esbak/#path.repo:\ \/data\/prod_esbak/g' /etc/elasticsearch/elasticsearch.yml"
ssh root@192.168.7.15 "sed -ri 's/^#path.repo:\ \/data\/backup/path.repo:\ \/data\/backup/g' /etc/elasticsearch/elasticsearch.yml"
ssh root@192.168.7.15 "systemctl restart elasticsearch"

echo "es节点192.168.7.16正在还原默认配置....."
ssh root@192.168.7.16 "sed -ri 's/^path.repo:\ \/data\/prod_esbak/#path.repo:\ \/data\/prod_esbak/g' /etc/elasticsearch/elasticsearch.yml"
ssh root@192.168.7.16 "sed -ri 's/^#path.repo:\ \/data\/backup/path.repo:\ \/data\/backup/g' /etc/elasticsearch/elasticsearch.yml"
ssh root@192.168.7.16 "systemctl restart elasticsearch"