title: multiple inputs on logstash jdbc
body: <p>I am using logstash jdbc to keep the things syncd between mysql and elasticsearch. Its working fine for one table. But now I want to do it for multiple tables. Do I need to open multiple in terminal</p>
  
  <pre><code>logstash  agent -f /Users/logstash/logstash-jdbc.conf 
  </code></pre>
  
  <p>each with a select query or do we have a better way of doing it so we can have multiple tables being updated.</p>
  
  <p>my config file</p>
  
  <pre><code>input {
    jdbc {
      jdbc_driver_library =&gt; "/Users/logstash/mysql-connector-java-5.1.39-bin.jar"
      jdbc_driver_class =&gt; "com.mysql.jdbc.Driver"
      jdbc_connection_string =&gt; "jdbc:mysql://localhost:3306/database_name"
      jdbc_user =&gt; "root"
      jdbc_password =&gt; "password"
      schedule =&gt; "* * * * *"
      statement =&gt; "select * from table1"
    }
  }
  output {
      elasticsearch {
          index =&gt; "testdb"
          document_type =&gt; "table1"
          document_id =&gt; "%{table_id}"
          hosts =&gt; "localhost:9200"
      }
  }
  </code></pre>