# Error While loading mysql db
**URL:** https://discuss.elastic.co/t/error-while-loading-mysql-db/27098
**Category:** Logstash
**Created:** [August 10, 2015, 5:06am UTC](https://discuss.elastic.co/t/error-while-loading-mysql-db/27098 "2015-08-10T05:06:11Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@Dan](https://discuss.elastic.co/u/Dan)
#### Post date: [August 10, 2015, 5:06am UTC](https://discuss.elastic.co/t/error-while-loading-mysql-db/27098/1 "2015-08-10T05:06:11Z")
Hi All,
i am try to load mysql data into elastic search by using logstash.
when i create a index i am getting below error.
[2015-08-10 09:52:18,417][INFO][cluster.service] [Allison Blaire] added {[Robert "Bobby" Drake][sqIHmbFtSzW8-dSJCsR4WQ][WIN-18KR7AJA9OG][inet[/192.168.3.124:9301]],}, reason: zen-disco-receive(join from node[[Robert "Bobby" Drake][sqIHmbFtSzW8-dSJCsR4WQ][WIN-18KR7AJA9OG][inet[/192.168.3.124:9301]]])
[2015-08-10 09:52:47,093][INFO][cluster.service] [Allison Blaire] removed {[Robert "Bobby" Drake][sqIHmbFtSzW8-dSJCsR4WQ][**_][inet[/192.168.3.124:9301]],}, reason: zen-disco-node\_failed([Robert "Bobby" Drake][sqIHmbFtSzW8-dSJCsR4WQ][_**\*\*\*][inet[/192.168.3.124:9301]]), reason transport disconnected
Please help me.
Regards,
Dinesh.
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [August 10, 2015, 5:26am UTC](https://discuss.elastic.co/t/error-while-loading-mysql-db/27098/2 "2015-08-10T05:26:11Z")
Looks like it cannot connect to ES.
What does your config look like?
---
### Author:  [@Dan](https://discuss.elastic.co/u/Dan)
#### Post date: [August 10, 2015, 6:59am UTC](https://discuss.elastic.co/t/error-while-loading-mysql-db/27098/3 "2015-08-10T06:59:07Z")
Hi below is my config file
input {
jdbc {
jdbc\_driver\_library =\> "C:\ELK3\logstash-1.5.3\lib\mysql-connector-java-5.1.35-bin.jar"
jdbc\_driver\_class =\> "com.mysql.jdbc.Driver"
jdbc\_connection\_string =\> "jdbc:mysql://192.168.3.124:3306/datalake"
jdbc\_user =\> "datalake"
jdbc\_password =\> "datalake"
statement =\> "SELECT \* FROM product"
jdbc\_paging\_enabled =\> "true"
jdbc\_page\_size =\> "50000"
}
}
output {
stdout { codec =\> rubydebug }
elasticsearch {
embedded =\> true
index =\> "lake2"
protocol =\> "http"
port =\> "9200"
```
}
```
}
---
### Author:  [@talevy](https://discuss.elastic.co/u/talevy)
#### Post date: [August 11, 2015, 6:17pm UTC](https://discuss.elastic.co/t/error-while-loading-mysql-db/27098/4 "2015-08-11T18:17:12Z")
maybe try to run Elasticsearch externally and not in embedded mode. That may help resolve this issue.
Another thing I should note is that the `jdbc_paging` options do not preserve transaction or order. This is recommended for using with ordered queries that are not expected to change during the query.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 5:32am UTC](https://discuss.elastic.co/t/error-while-loading-mysql-db/27098/5 "2017-07-06T05:32:17Z")