# How to keep Database and Elasticsearch consistent using Logstash
**URL:** https://discuss.elastic.co/t/how-to-keep-database-and-elasticsearch-consistent-using-logstash/157718
**Category:** Elasticsearch
**Created:** [November 21, 2018, 1:50pm UTC](https://discuss.elastic.co/t/how-to-keep-database-and-elasticsearch-consistent-using-logstash/157718 "2018-11-21T13:50:27Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@patrick007](https://discuss.elastic.co/u/patrick007)
#### Post date: [November 21, 2018, 1:50pm UTC](https://discuss.elastic.co/t/how-to-keep-database-and-elasticsearch-consistent-using-logstash/157718/1 "2018-11-21T13:50:27Z")
I have a Relational database, I have used Logstash to migrate my Relational Postgres data to elasticsearch.
Now how can I keep my Database and Elasticsearch Server in sync?
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [November 21, 2018, 2:27pm UTC](https://discuss.elastic.co/t/how-to-keep-database-and-elasticsearch-consistent-using-logstash/157718/2 "2018-11-21T14:27:48Z")
I shared most of my thoughts there: [http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/](http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/)
Basically, I'd recommend modifying the application layer if possible and send data to elasticsearch in the same "transaction" as you are sending your data to the database.
---
### Author:  [@patrick007](https://discuss.elastic.co/u/patrick007)
#### Post date: [November 21, 2018, 2:34pm UTC](https://discuss.elastic.co/t/how-to-keep-database-and-elasticsearch-consistent-using-logstash/157718/3 "2018-11-21T14:34:57Z")
@dadoonet Is there any other way of doing it ?
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [November 21, 2018, 3:16pm UTC](https://discuss.elastic.co/t/how-to-keep-database-and-elasticsearch-consistent-using-logstash/157718/4 "2018-11-21T15:16:00Z")
Did you read my blog? The start of it at least?
---
### Author:  [@patrick007](https://discuss.elastic.co/u/patrick007)
#### Post date: [November 22, 2018, 10:09am UTC](https://discuss.elastic.co/t/how-to-keep-database-and-elasticsearch-consistent-using-logstash/157718/5 "2018-11-22T10:09:47Z")
@dadoonet Yes I had gone through it earlier. The blog is very helpful. It is great help
I was able to find the solution I used 'record\_last\_run' to record the last run the logstash and used the scheduler to check for changes in the Database
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [November 22, 2018, 10:58am UTC](https://discuss.elastic.co/t/how-to-keep-database-and-elasticsearch-consistent-using-logstash/157718/6 "2018-11-22T10:58:15Z")
Awesome.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 20, 2018, 10:58am UTC](https://discuss.elastic.co/t/how-to-keep-database-and-elasticsearch-consistent-using-logstash/157718/7 "2018-12-20T10:58:29Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.