Logstash Plugin
GitHub. This is a plugin for Logstash.
It is fully free and fully open source.
How install
sudo /usr/share/logstash/bin/logstash-plugin install logstash-input-elastic_jdbc.gem
Documentation
This plugin inherit of elasticsearch(ES) input plugin, and added a tracking_column using in jdbc input plugin for make a query to obtain the updates values Sample :
input{
elastic_jdbc{
hosts => "localhost"
index => "documents"
tracking_column => "last_update"
query => '{"query":{"range":{"created":{"gte":"2021-08-13T00:17:58+00:00"}}}}'
last_run_metadata_path => "/opt/logstash/last_run/elastic_jdbc_documents"
}
}
filter {
}
output{
stdout{}
}
In the sample before, we read from ES cluster, documents index, where documents hits have last_update field as
a date type field (recommend use Ingest pipelines),
then we look for all documents that have a field value last_update greater than the value stored in /opt/logstash/last_run/elastic jdbc_documents"
.
Required parameters:
hosts
: ES cluster urlindex
: ES indextracking_column
: Date field to tracking in ES indexlast_run_metadata_path
: File path where stored the last value from last hist readed from ES index. By the default have the date1960-01-01
Optional parameters:
- All logstash-input-elasticsearch parameters can use in this plugins.
query
: By the default we use a bool query where we get a hits withtracking column
greater that last value stored inlast_run_metadata_path
. you can insert a query, but keep in mind that your query always be appended with the default query ( if you don't need search by tracking column, please use logstash-input-elasticsearch plugin). Sample, for this query parameterquery => '{"query":{"range":{"created":{"gte":"2021-08-13T00:17:58+00:00"}}}}'
, the final query using this plugin would be:
```{ "query":{ "bool":{ "must":[ {"last_update":{"gt": "date_time_value_stored"}}, "2021-08-13T00:17:58+00:00"}} ] } }, sort: ["last_update"=>{:order=>"asc"}] }
**Note:** If you insert a ranking attribute within the query, we always overwrite it with the ranking values shown above.
### 1. Plugin Developement and Testing
#### Code
- To get started, you'll need JRuby with the Bundler gem installed.
- Create a new plugin or clone and existing from the GitHub [logstash-plugins](https://github.com/logstash-plugins) organization. We also provide [example plugins](https://github.com/logstash-plugins?query=example).
- Install dependencies
```sh
bundle install
Test
- Update your dependencies
bundle install
- Run tests
bundle exec rspec
2. Running your unpublished Plugin in Logstash
2.1 Run in a local Logstash clone
- Edit Logstash
Gemfile
and add the local plugin path, for example:ruby gem "logstash-filter-awesome", :path => "/your/local/logstash-filter-awesome"
- Install plugin ```sh # Logstash 2.3 and higher bin/logstash-plugin install --no-verify
Prior to Logstash 2.3
bin/plugin install --no-verify
- Run Logstash with your plugin
```sh
bin/logstash -e 'filter {awesome {}}'
At this point any modifications to the plugin code will be applied to this local Logstash setup. After modifying the plugin, simply rerun Logstash.
2.2 Run in an installed Logstash
You can use the same 2.1 method to run your plugin in an installed Logstash by editing its Gemfile
and pointing the :path
to your local plugin development directory or you can build the gem and install it using:
- Build your plugin gem
sh gem build logstash-filter-awesome.gemspec
- Install the plugin from the Logstash home ```sh # Logstash 2.3 and higher bin/logstash-plugin install --no-verify
Prior to Logstash 2.3
bin/plugin install --no-verify
- Start Logstash and proceed to test the plugin
## Contributing
All contributions are welcome: ideas, patches, documentation, bug reports, complaints, and even something you drew up on a napkin.
Programming is not a required skill. Whatever you've seen about open source and maintainers or community members saying "send patches or die" - you will not see that here.
It is more important to the community that you are able to contribute.
For more information about contributing, see the [CONTRIBUTING](https://github.com/elastic/logstash/blob/master/CONTRIBUTING.md) file.