# Adding search bar for my web application
**URL:** https://discuss.elastic.co/t/adding-search-bar-for-my-web-application/192841
**Category:** Elasticsearch
**Created:** [July 30, 2019, 7:16am UTC](https://discuss.elastic.co/t/adding-search-bar-for-my-web-application/192841 "2019-07-30T07:16:02Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@saurabhbora](https://discuss.elastic.co/u/saurabhbora)
#### Post date: [July 30, 2019, 7:16am UTC](https://discuss.elastic.co/t/adding-search-bar-for-my-web-application/192841/1 "2019-07-30T07:16:02Z")
My web application has all the data stored in the MySQL database.
I want to develop a search bar using elastic search for retrieving results faster.
How should I go about this?
---
### Author:  [@aravindputrevu](https://discuss.elastic.co/u/aravindputrevu)
#### Post date: [July 30, 2019, 7:48am UTC](https://discuss.elastic.co/t/adding-search-bar-for-my-web-application/192841/2 "2019-07-30T07:48:26Z")
Welcome to Elastic Discussion Forums!
There are a couple of ways to approach this one.
1. You can use [Logstash JDBC input plugin](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html) and ingest data to Elasticsearch. Thereby, creating a search experience on your web application. [Link](https://www.elastic.co/blog/logstash-jdbc-input-plugin) to the blog post.
2. You can use [Self Managed App Search](https://www.elastic.co/blog/elastic-app-search-beta-released), but you need to send the data from your app to it directly.
I'd also want to introduce you to [Search-UI](https://github.com/elastic/search-ui/) which is a open source project and lets you get started easily with creating a Search experience.
Happy to help!
Aravind.
---
### Author:  [@saurabhbora](https://discuss.elastic.co/u/saurabhbora)
#### Post date: [July 30, 2019, 9:45am UTC](https://discuss.elastic.co/t/adding-search-bar-for-my-web-application/192841/3 "2019-07-30T09:45:26Z")
Thanks for the information.
Which method will be the most efficient and get real time update changes based on any modifications in MySQL database?
Also for using App search do i need to migrate all the data from MySQL to elastic search ?
---
### Author:  [@aravindputrevu](https://discuss.elastic.co/u/aravindputrevu)
#### Post date: [July 30, 2019, 10:15am UTC](https://discuss.elastic.co/t/adding-search-bar-for-my-web-application/192841/4 "2019-07-30T10:15:20Z")
I'd choose App Search. App Search follows below Architecture
`ES -> App Search Server -> Your App`
Search on plain Elasticsearch follows below Architecture
`ES-> Your App`
In the second case, If you'd want the data to be synced in real time, I'd choose to write data directly using one the [clients of Elasticsearch](https://www.elastic.co/guide/en/elasticsearch/client/index.html). You can write data to MySQL and ES at the same point.
That being said, App search is a solution built on Elasticsearch itself, either-or you are storing data in Elasticsearch. Just App Search allows you to manage your search experience better.
For more details on App search, please refer the documentation.
---
### Author:  [@saurabhbora](https://discuss.elastic.co/u/saurabhbora)
#### Post date: [July 30, 2019, 11:12am UTC](https://discuss.elastic.co/t/adding-search-bar-for-my-web-application/192841/5 "2019-07-30T11:12:03Z")
Okay Thanks !
---
### Author:  [@saurabhbora](https://discuss.elastic.co/u/saurabhbora)
#### Post date: [August 8, 2019, 5:01am UTC](https://discuss.elastic.co/t/adding-search-bar-for-my-web-application/192841/6 "2019-08-08T05:01:00Z")
Can you provide some example on how should i get started?
Also i found that elastic app search is not yet supported for windows?
---
### Author:  [@aravindputrevu](https://discuss.elastic.co/u/aravindputrevu)
#### Post date: [August 8, 2019, 5:18am UTC](https://discuss.elastic.co/t/adding-search-bar-for-my-web-application/192841/7 "2019-08-08T05:18:07Z")
We support linux/mac for now.
You can find samples on App Search [here](https://github.com/swiftype?utf8=%E2%9C%93&q=app+search&type=&language=) & documentation for Self-managed App Search [here](https://swiftype.com/documentation/app-search/self-managed/overview)
---
### Author:  [@saurabhbora](https://discuss.elastic.co/u/saurabhbora)
#### Post date: [August 8, 2019, 6:12am UTC](https://discuss.elastic.co/t/adding-search-bar-for-my-web-application/192841/8 "2019-08-08T06:12:52Z")
I am going by the first method using jdbc input plugin. I have a single database with 15+ tables with different structures and linking. How should i ingest them in elasticsearch with same format and how many indexes must be used?
---
### Author:  [@aravindputrevu](https://discuss.elastic.co/u/aravindputrevu)
#### Post date: [August 8, 2019, 6:23am UTC](https://discuss.elastic.co/t/adding-search-bar-for-my-web-application/192841/9 "2019-08-08T06:23:57Z")
Kindly raise a different discuss question for that.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [September 5, 2019, 6:23am UTC](https://discuss.elastic.co/t/adding-search-bar-for-my-web-application/192841/10 "2019-09-05T06:23:59Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.