# How can I merge onw ElasticSearch database into another?
**URL:** https://discuss.elastic.co/t/how-can-i-merge-onw-elasticsearch-database-into-another/12798
**Category:** Elasticsearch
**Created:** [July 16, 2013, 2:13am UTC](https://discuss.elastic.co/t/how-can-i-merge-onw-elasticsearch-database-into-another/12798 "2013-07-16T02:13:49Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Raymond\_Wang](https://discuss.elastic.co/u/Raymond_Wang)
#### Post date: [July 16, 2013, 2:13am UTC](https://discuss.elastic.co/t/how-can-i-merge-onw-elasticsearch-database-into-another/12798/1 "2013-07-16T02:13:49Z")
I have two ES instance deployed, and the two instance have some data in
common. I wanna to merge the two database into one.
So, is there a tool that can help me?
any help would be appreciated.
--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).
---
### Author:  [@Ivan](https://discuss.elastic.co/u/Ivan)
#### Post date: [July 16, 2013, 4:47am UTC](https://discuss.elastic.co/t/how-can-i-merge-onw-elasticsearch-database-into-another/12798/2 "2013-07-16T04:47:41Z")
You could always write code that executes a scan/scroll query from one
cluster and bulk loads them into the other. Perhaps one of the existing
reindex plugins can help:
> **[GitHub - karussell/elasticsearch-reindex: Simple re-indexing. To backup,...](https://github.com/karussell/elasticsearch-reindex)**
>
> Simple re-indexing. To backup, apply index settings changes and more ElasticMagic - GitHub - karussell/elasticsearch-reindex: Simple re-indexing. To backup, apply index settings changes and more El...
> **[GitHub - crate/elasticsearch-inout-plugin: An Elasticsearch plugin which...](https://github.com/crate/elasticsearch-inout-plugin)**
>
> An Elasticsearch plugin which provides the ability to export data by query on server side. - GitHub - crate/elasticsearch-inout-plugin: An Elasticsearch plugin which provides the ability to export...
--
Ivan
On Mon, Jul 15, 2013 at 7:13 PM, Raymond Wang [rmn190@gmail.com](mailto:rmn190@gmail.com) wrote:
> I have two ES instance deployed, and the two instance have some data in
> common. I wanna to merge the two database into one.
>
> So, is there a tool that can help me?
>
> any help would be appreciated.
>
> --
> You received this message because you are subscribed to the Google Groups
> "elasticsearch" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).
> For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).
--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).
---
### Author:  [@jprante](https://discuss.elastic.co/u/jprante)
#### Post date: [July 16, 2013, 7:26am UTC](https://discuss.elastic.co/t/how-can-i-merge-onw-elasticsearch-database-into-another/12798/3 "2013-07-16T07:26:07Z")
You can do this with the export/import functions of my knapsack plugin
> **[GitHub - jprante/elasticsearch-knapsack: Knapsack plugin is an import/export...](https://github.com/jprante/elasticsearch-knapsack)**
>
> Knapsack plugin is an import/export tool for Elasticsearch - GitHub - jprante/elasticsearch-knapsack: Knapsack plugin is an import/export tool for Elasticsearch
Jörg
Am 16.07.13 04:13, schrieb Raymond Wang:
> I have two ES instance deployed, and the two instance have some data
> in common. I wanna to merge the two database into one.
>
> So, is there a tool that can help me?
>
> any help would be appreciated.
--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).
---
### Author:  [@Raymond\_Wang](https://discuss.elastic.co/u/Raymond_Wang)
#### Post date: [July 16, 2013, 7:42am UTC](https://discuss.elastic.co/t/how-can-i-merge-onw-elasticsearch-database-into-another/12798/4 "2013-07-16T07:42:38Z")
there are rivers for mysql,mongodb, so is there a river for elasticsearch
it self?
On Tuesday, July 16, 2013 10:13:49 AM UTC+8, Raymond Wang wrote:
> I have two ES instance deployed, and the two instance have some data in
> common. I wanna to merge the two database into one.
>
> So, is there a tool that can help me?
>
> any help would be appreciated.
--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [July 16, 2013, 8:24am UTC](https://discuss.elastic.co/t/how-can-i-merge-onw-elasticsearch-database-into-another/12798/5 "2013-07-16T08:24:39Z")
No. IIRC relative issue has been closed in github.
--
David 😉
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs
Le 16 juil. 2013 à 09:42, Raymond Wang [rmn190@gmail.com](mailto:rmn190@gmail.com) a écrit :
> there are rivers for mysql,mongodb, so is there a river for elasticsearch it self?
>
> On Tuesday, July 16, 2013 10:13:49 AM UTC+8, Raymond Wang wrote:
>
> > I have two ES instance deployed, and the two instance have some data in common. I wanna to merge the two database into one.
> >
> > So, is there a tool that can help me?
> >
> > any help would be appreciated.
> > --
> > You received this message because you are subscribed to the Google Groups "elasticsearch" group.
> > To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).
> > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).
--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).
---
### Author:  [@jprante](https://discuss.elastic.co/u/jprante)
#### Post date: [July 16, 2013, 8:28am UTC](https://discuss.elastic.co/t/how-can-i-merge-onw-elasticsearch-database-into-another/12798/6 "2013-07-16T08:28:32Z")
You can start up remote nodes and connect them (directly or via IP
tunnels) to form a cluster so the nodes span data centers. With
awareness, you can configure ES to take the node distribution into
account, for shard allocation.
But heck no, there is no elasticsearch river. A river is primarily meant
being a one-way mechanism to fetch data from foreign sources. I think I
can plug code from my JDBC river and knapsack plugin together to achieve
this in a very naive style.
For ES 1.0, there were some feature announcements. One is the full
fledged backup/restore feature (maybe even on hot clusters) from which I
hope this feature can span clusters/data centers. No details yet, but
I'm excited. Maybe also with the feature of keeping two ES clusters in
sync on a slow connection.
Jörg
Am 16.07.13 09:42, schrieb Raymond Wang:
> there are rivers for mysql,mongodb, so is there a river for
> elasticsearch it self?
>
> On Tuesday, July 16, 2013 10:13:49 AM UTC+8, Raymond Wang wrote:
>
> ```
> I have two ES instance deployed, and the two instance have some
> data in common. I wanna to merge the two database into one.
>
> So, is there a tool that can help me?
>
> any help would be appreciated.
>
> ```
--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 2:26am UTC](https://discuss.elastic.co/t/how-can-i-merge-onw-elasticsearch-database-into-another/12798/7 "2017-07-06T02:26:17Z")