How do you use multiple tracking_column at the same time. For example, my "table" is actually a view over multiple tables, so I need to have it select based on 2 columns (commandtime and commandid). I really don't want to have to build logstash task for each of the 10 tables in my view.
Concatenate those two columns in your SELECT clause and use that as the tracking column.
How do I handle auto reset of the sql_last_value? Everyday the base tables are renamed and new tables created at around midnight.
Won't this be fixed if you follow my suggestion above?