I’m having real issues aggregating Counters to give a Total Count from multiple cloud hosts, where hosts can come and go as the autoscaling kicks in.
Working with counters over transient hosts must be a common scenario, but I couldn’t find any information on the web.
For example, the query
select sum(*) FROM “measurement” WHERE time > :dashboardTime: AND time < :upperDashboardTime: GROUP BY time(:interval:) FILL(null)
and you can see that the graph goes down at 14:52 because one of the hosts is removed, but that host’s contribution should still be included in subsequent time periods, as if all the work had been done by a single host.