Right now we have one logstash node running in Docker that queries a database every 2 minutes using JDBC and sends it over to a collector. How does something like this work if you want to have this done by a swarm of nodes? Ideally we would like multiple nodes so that if the one fails the whole service doesn't go down.
Is it possible to do this? or is the nature of it being a scheduled query prevent such a thing?