在将连续查询添加到生产influxdb中之前测试连续查询的最佳方法? [英] Best way to test continuous queries before adding them to production influxdb?

问题描述

将新的连续查询添加到生产数据库influxdb的最佳方法是什么?克隆生产influxdb?我希望避免这种情况.是否可以通过Web管理员界面测试并尝试使用它们的好方法?

Whats the best way to add a new continuous query to a production db influxdb? Clone the production influxdb ? I was hoping to avoid that. Is there a good way to test and try them it just through the web admin interface?

推荐答案

我想您可以:

1. 创建一个临时测量..设置CQ ..插入一些样本数据并在CQ执行后检查结果

1. create a temporary measurement .. setup the CQ .. insert some sample data and check the result once the CQ executes

[更好的方法]将时间序列数据并行发送到2个不同的测量表.在其中一项上运行您的CQ实验，并在收到所需查询后将其丢弃.

[better approach] Send your timeseries data to 2 different measurement tables in parallel. Run your CQ experiments on one of them and discard it once you have the query you like.

Web界面可能对您没有太大帮助，因为CQ在执行时不会返回结果.他们只是将输出通过管道传递到您定义的新测量表.然后，一旦至少完成一次CQ迭代成功，您就可以在向下采样的测量表上运行查询.

The web interface might not help you much because CQ don't return results when you execute. They just pipe the output to a new measurement table you define. You can then run queries on the down sampled measurement table once at least 1 iteration of CQ finishes successfully.

虽然很想听听其他想法.

Would love to hear other thoughts though.

这篇关于在将连续查询添加到生产influxdb中之前测试连续查询的最佳方法?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！