jdbc - How do I keep Logstash running so it syncs data from my RDBMS to ES? -

-

i'm complete newbie elk stack, please excuse ignorance. i've been able logstash send data database elasticsearch, exits once it's done transfer. how keep running keeps them in sync? thanks

you need specify schedule in jdbc input:

the schedule below (* * * * *) run every minute , select records database , select records have been updated after last time query ran. updated timestamp field might named differently, feel free adjust fit case. 

input {   jdbc {     jdbc_driver_library => "mysql-connector-java-5.1.36-bin.jar"     jdbc_driver_class => "com.mysql.jdbc.driver"     jdbc_connection_string => "jdbc:mysql://localhost:3306/mydb"     jdbc_user => "mysql"     parameters => { "some_field" => "value" }     schedule => "* * * * *"     statement => "select * songs some_field = :some_field , updated > :sql_last_value"   } }

Comments

Post a Comment

Popular posts from this blog

Lists in Python -

-
i noticed can multiply list scalar behavior weird if multiply: [2,3,4] * 3 i get: [2,3,4,2,3,4,2,3,4 ] understand results it's for? there other weird operations that? the main purpose of operand initialisation. example, if want initialize list 20 equal numbers can using loop: arr=[] in range(20): arr.append(3) an alternative way using operator: arr = [3] * 20 more weird , normal list operation on lists can find here http://www.discoversdk.com/knowledge-base/using-lists-in-python
Read more

android - can not access to progress bar in an other activity -

-
i have objects in layout video view,text view , on comes this: <?xml version="1.0" encoding="utf-8"?> <android.support.v7.widget.cardview android:id="@+id/cardview_mypost" android:layout_width="match_parent" android:layout_height="wrap_content" android:layout_marginbottom="@dimen/activity_vertical_margin" app:cardcornerradius="@dimen/activity_vertical_margin" app:cardelevation="@dimen/activity_vertical_margin" xmlns:android="http://schemas.android.com/apk/res/android" xmlns:app="http://schemas.android.com/apk/res-auto"> <relativelayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="fill_parent" android:layout_height="wrap_content" android:background="@color/web_withe_color" android:animatelayoutchanges="@anim/anim_list" android:padding="8dp" > <!-- thu...
Read more

html - Not able to access next element of an array javascript -

-
i new js, trying access next element of array using onclick function no luck. var i, len; function quiz() { var quiz_questions = [ "who founder of facebook?", "who founder of google?" ]; len = quiz_questions.length; for(i = 0; < len; i++) { document.getelementbyid("demo").innerhtml = quiz_questions[i]; } } <button onclick="quiz();">click</button> <p id="demo"></p> can explain me did wrong here. your problem is, iterate through every question, every time click. remove loop , put i++ after setting question. maybe checking, if less array length before it, wouldnt bad idea. var i, len; = 0; function quiz() { var quiz_questions = [ "who founder of facebook?", "who founder of google?" ]; len = quiz_questions.length; document.gete...
Read more