Couchbase query metrics on couchbase-exporter

Couchbase Server
1

Hello Guys, how are you?

Finally, we defined the best setup for our production environment using the Couchbase community edition.

To improve the observability we deployed the couchbase-exporter to collect cluster metrics. But we face these exporter (https://github.com/blakelead/couchbase_exporter) don’t get Query metrics.

What would be the best way (and best practices) to get all Cluster metrics like the screenshot below?

Captura de tela de 2021-09-06 13-03-17
Captura de tela de 2021-09-06 13-03-171443×388 33.2 KB

Best Regards

Diego

2

Hi Diego, Congratulations !!!

Could you please let us know how are you getting CB certificates and how you are passing it as exporter command line parameters ?

Thanks in advance,

3

Hi Dhaval, how are you?

Thanks for the reply.

We still using the official community exporter to get metrics, we setup the exporter running on Docker with the command bellow:

sudo docker run --restart=always -d --name cb_exporter
–memory=100m --cpus=0.1
–publish 9191:9191
–env CB_EXPORTER_LISTEN_ADDR=:9191
–env CB_EXPORTER_TELEMETRY_PATH=/metrics
–env CB_EXPORTER_SERVER_TIMEOUT=10s
–env CB_EXPORTER_LOG_LEVEL=debug
–env CB_EXPORTER_LOG_FORMAT=json
–env CB_EXPORTER_DB_URI=http://${MASTER_IP}:8091
–env CB_EXPORTER_DB_TIMEOUT=10s
–env CB_EXPORTER_DB_USER=dott_admin
–env CB_EXPORTER_DB_PASSWORD=${PASSWD}
–env CB_EXPORTER_SCRAPE_CLUSTER=true
–env CB_EXPORTER_SCRAPE_NODE=true
–env CB_EXPORTER_SCRAPE_BUCKET=true
–env CB_EXPORTER_SCRAPE_XDCR=true
blakelead/couchbase-exporter:0.9.6

So, I check on this exporter, and Index and query metrics aren’t available for the community version and only for EE version.

Best Regards

Diego

4

Thanks for Quick Reply Diego … Appreciate !!

In our case CB URL is secure and we are accessing through SSL/TLS. Do you know how can we collect certificate and use it properly ?

FYI, In our CB server we are using self signed certificate and exporter is triggering error message during the metrics scrap process for cluster, node and bucket.

Thanks,

5

Hi Dhaval,

So, if we start to connect the couchbase-exporter with SSL, then will the agent be able to collect the index and query metrics correctly?

Best Regards

6

Hi Diego,

Yes, Look at the other options/parameters that we are passing during the start up of exporter. We can pass on certificates as well.

Thanks,

7

Nice Dhaval, I’ll try this approach and let you know if works

Thank you a lot!

Best Regards

8

Hey Diego, Finally we’ve resolved the issue !!

We found the certificates in below path of Couchbase server installation folder:
→ Server\var\lib\couchbase\config

After adding below three parameters it is working now:
CB_EXPORTER_TLS_CLIENT_CERT
CB_EXPORTER_TLS_CA_CERT
CB_EXPORTER_TLS_CLIENT_KEY

Thanks you so much !!

Regards,

9

Hi Dhaval, could you kindly share what is the name of the metric that was available for scrap after this change? I still don’t see any query or index metrics, only buckets metrics.

Best Regards