Hi all. Today I have tried to get dynamic data from mysql db via logstash. I have installed elastic search and have run, than have installed logstash and configured db.config , which in I have parameters => {"user_name" => "Jhon"} stament => "SELECT * FROM user where name= :user_name " I need t…

Getting dynamic data from mysql db

eperry (Ed) March 18, 2017, 1:50pm 4

yah as I mentioned in answer 1 pull all your user data in to elasticsearch not just one user
"SELECT * FROM user"

then from php just add your user to what ever your existing PHP query is

Topic		Replies	Views
How create dynamic query in logstash? Logstash	2	2183	April 15, 2017
Join mysql table with ealsticsearch index Elasticsearch	2	510	March 20, 2019
Enrich Elasticsearch via MySQL based on field value Elasticsearch	4	620	July 5, 2017
How elasticsearch will fetch data from MySQL database? Logstash	8	18849	August 13, 2018
MYSQL DB to fetch data from table and push the same to elastic Logstash	1	692	December 25, 2017