We are planning to use influxdb for our solution, however for our implementation we have some questions . It will help us if you will clarify the same.
1.) Our usecase contains tenant specific data. What is the optimal way of persisting tenantID ?
- Should we use separate measurement for each tenant?
- Can we use TAG for storing tenant-ID?
- Should we prefix TenantID to time series data?
2) As per guidelines we should keep searchable fields as tags. However, we have more than 5 searchable fields and 3 of them are id based values (e.g transaction id) - Is it recommended to define TAG type for all String type searchable fields?