# Synchronization of Elasticsearch and relational databases with Logstash and JDBC disconnected EC2

**URL:** https://discuss.elastic.co/t/synchronization-of-elasticsearch-and-relational-databases-with-logstash-and-jdbc-disconnected-ec2/290140
**Category:** Logstash
**Created:** [November 25, 2021, 8:17am UTC](https://discuss.elastic.co/t/synchronization-of-elasticsearch-and-relational-databases-with-logstash-and-jdbc-disconnected-ec2/290140 "2021-11-25T08:17:58Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Soongu\_Jeon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/soongu_jeon/32/97583_2.png) [@Soongu\_Jeon](https://discuss.elastic.co/u/Soongu_Jeon)
#### Post date: [November 25, 2021, 8:17am UTC](https://discuss.elastic.co/t/synchronization-of-elasticsearch-and-relational-databases-with-logstash-and-jdbc-disconnected-ec2/290140/1 "2021-11-25T08:17:58Z")

</div>

hi.

> **[Logstash와 JDBC를 사용해 RDBMS와 Elasticsearch의 동기화를 유지하는 방법](https://www.elastic.co/kr/blog/how-to-keep-elasticsearch-synchronized-with-a-relational-database-using-logstash)**
>
> Elasticsearch가 기존 관계형 데이터베이스(RDBMS)와 더불어 검색 솔루션으로 배포될 때, 두 데이터 저장소 간에 데이터 동기화를 유지하는 것이 중요합니다. Logstash JDBC 입력 플러그인을 이용해 손쉽게 데이터를 동기화하는 방법을 알아보세요.

After reading the above site article, I set the schedule for jdbc and mysql every 5 minutes, but the next day I turned on the background and checked, and the server was disconnected. How can I solve this problem?

---

<div class="post-metadata">

### Author: ![Alex\_Marquardt](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alex_marquardt/32/42925_2.png) [@Alex\_Marquardt](https://discuss.elastic.co/u/Alex_Marquardt)
#### Post date: [November 25, 2021, 11:03am UTC](https://discuss.elastic.co/t/synchronization-of-elasticsearch-and-relational-databases-with-logstash-and-jdbc-disconnected-ec2/290140/2 "2021-11-25T11:03:46Z")

</div>

Do you have any information in the Logstash logs that indicate the reason for the disconnection?

---

<div class="post-metadata">

### Author: ![Soongu\_Jeon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/soongu_jeon/32/97583_2.png) [@Soongu\_Jeon](https://discuss.elastic.co/u/Soongu_Jeon)
#### Post date: [November 25, 2021, 11:43am UTC](https://discuss.elastic.co/t/synchronization-of-elasticsearch-and-relational-databases-with-logstash-and-jdbc-disconnected-ec2/290140/3 "2021-11-25T11:43:00Z")

</div>

If you update mysqldb information after a certain period of time, it will not be searched in search, but you have to disconnect the existing connection and make a new connection to search.

Thank you for your quick reply.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 23, 2021, 11:43am UTC](https://discuss.elastic.co/t/synchronization-of-elasticsearch-and-relational-databases-with-logstash-and-jdbc-disconnected-ec2/290140/4 "2021-12-23T11:43:23Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
