# 1) How to integrate Elasticsearch-Hadoop with MySQL DB at the backend and User interface developed in dhtmlx, Spring. 2) Also how to integrate Elasticsearch-Hadoop with Services written in Spring MVC **URL:** https://discuss.elastic.co/t/1-how-to-integrate-elasticsearch-hadoop-with-mysql-db-at-the-backend-and-user-interface-developed-in-dhtmlx-spring-2-also-how-to-integrate-elasticsearch-hadoop-with-services-written-in-spring-mvc/43223 **Category:** Elasticsearch **Tags:** es-hadoop **Created:** [March 2, 2016, 10:08am UTC](https://discuss.elastic.co/t/1-how-to-integrate-elasticsearch-hadoop-with-mysql-db-at-the-backend-and-user-interface-developed-in-dhtmlx-spring-2-also-how-to-integrate-elasticsearch-hadoop-with-services-written-in-spring-mvc/43223 "2016-03-02T10:08:49Z") **Posts on this page:** 1 **Showing post:** 7
### Author: ![prashanthrd](https://avatars.discourse-cdn.com/v4/letter/p/50afbb/32.png) [@prashanthrd](https://discuss.elastic.co/u/prashanthrd) #### Post date: [March 4, 2016, 6:35pm UTC](https://discuss.elastic.co/t/1-how-to-integrate-elasticsearch-hadoop-with-mysql-db-at-the-backend-and-user-interface-developed-in-dhtmlx-spring-2-also-how-to-integrate-elasticsearch-hadoop-with-services-written-in-spring-mvc/43223/7 "2016-03-04T18:35:00Z")
Hi Friends, I have a problem extracting data from MySQL to Elasticsearch via Logstash. Suppose I have two different schemas and one table in each of them. Now, we search data from those tables using a LEFT OUTER JOIN query. How do we configure in the config file. Schema xyz --\> Table1 ; Schema pqr --\> Table2 ; joined by a left outer join. Please suggest ways to extract data from MySQL to elasticsearch using logstash. Thank you in advance.... --- _[View the full topic](https://discuss.elastic.co/t/1-how-to-integrate-elasticsearch-hadoop-with-mysql-db-at-the-backend-and-user-interface-developed-in-dhtmlx-spring-2-also-how-to-integrate-elasticsearch-hadoop-with-services-written-in-spring-mvc/43223)._