RE: How do you monitoring Cassandra Cluster?
I’m using Quest Foglight, very good if you have budget for it?? Jonathan Baynes DBA Tradeweb Europe Limited Moor Place • 1 Fore Street Avenue • London EC2Y 9DT P +44 (0)20 77760988 • F +44 (0)20 7776 3201 • M +44 (0)7884111546 jonathan.bay...@tradeweb.com [cid:image001.jpg@01CD26AD.4165F110]<http://www.tradeweb.com/> follow us: [cid:image002.jpg@01CD26AD.4165F110] <https://www.linkedin.com/company/tradeweb?trk=top_nav_home> [cid:image003.jpg@01CD26AD.4165F110] <http://www.twitter.com/Tradeweb> — A leading marketplace<http://www.tradeweb.com/About-Us/Awards/> for electronic fixed income, derivatives and ETF trading From: Rahul Singh [mailto:rahul.xavier.si...@gmail.com] Sent: 21 June 2018 15:15 To: user@cassandra.apache.org; user@cassandra.apache.org Subject: Re: How do you monitoring Cassandra Cluster? I’ve collected a bunch at http://leaves.anant.us/#!/?tag=cassandra,monitoring<https://urldefense.proofpoint.com/v2/url?u=http-3A__leaves.anant.us_-23-21_-3Ftag-3Dcassandra-2Cmonitoring&d=DwMFaQ&c=sA0VaJZJFLZREu2pbPeqjXHJ-Wd9NNzgHW3gpUOLSSk&r=CNKccIKIKCVbYTu1VxR8dIOP6NLpf4fYjidpNm-diQ8&m=ZIASPHopBGyBDLyYLE8hmO-g4WzF4M3QpMj4R-VcCLk&s=ppcLGaAXBihlMYI3iNod_cOkaYUEWIXCBbi5ZL5SMs0&e=> I reommend Grafana / Prometheus if you don’t have DSE (which has OpsCenter) -- Rahul Singh rahul.si...@anant.us<mailto:rahul.si...@anant.us> Anant Corporation On Jun 19, 2018, 1:06 PM -0400, Romain Gérard mailto:romain.ger...@erebe.eu>>, wrote: Hi Felipe, You can use this project https://github.com/criteo/cassandra_exporter<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_criteo_cassandra-5Fexporter&d=DwMFaQ&c=sA0VaJZJFLZREu2pbPeqjXHJ-Wd9NNzgHW3gpUOLSSk&r=CNKccIKIKCVbYTu1VxR8dIOP6NLpf4fYjidpNm-diQ8&m=ZIASPHopBGyBDLyYLE8hmO-g4WzF4M3QpMj4R-VcCLk&s=rW9TdHXho8o-6oWLMZUxHNFDS4gDMeDqjxMMixlomwc&e=> if you are using Prometheus (Disclamer, I am one of the author of it). There is included a Grafana dashboard that aggregate metrics per cluster for you, and in the "edit view" of each chart there are hidden queries that let you drill down by nodes. In any case, you can look at the json in order to grasp how to aggregate queries. Let me know if you need more information regarding the setup. If you end-up using the project, give a star to the project it is always pleasant, Regards, Romain Gérard On Jun 18 2018, at 3:25 pm, Felipe Esteves mailto:felipe.este...@b2wdigital.com>> wrote: Hi, everyone, I'm running some tests to monitor Cassandra 3.x with jmx_exporter + prometheus + grafana. I've managed to config it all and use the dashboard https://grafana.com/dashboards/5408<https://urldefense.proofpoint.com/v2/url?u=https-3A__grafana.com_dashboards_5408&d=DwMFaQ&c=sA0VaJZJFLZREu2pbPeqjXHJ-Wd9NNzgHW3gpUOLSSk&r=CNKccIKIKCVbYTu1VxR8dIOP6NLpf4fYjidpNm-diQ8&m=ZIASPHopBGyBDLyYLE8hmO-g4WzF4M3QpMj4R-VcCLk&s=P6v555HpxIkv4BSdpbTESNAuBGzo4RmKYZTCfwFlIFY&e=> However, I still can't aggregate metrics from all my cluster, just nodes individually. Any tips on how to do that? Also, Opscenter gives some datacenter aggregation, I think it comes from nodetool as I didn't seen any metrics about that. Anyone having success on that? cheers! Em qua, 28 de jun de 2017 às 19:43, Petrus Gomes mailto:petru...@gmail.com>> escreveu: I'm using JMX+Prometheus and Grafana. JMX = https://github.com/prometheus/jmx_exporter<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_prometheus_jmx-5Fexporter&d=DwMFaQ&c=sA0VaJZJFLZREu2pbPeqjXHJ-Wd9NNzgHW3gpUOLSSk&r=CNKccIKIKCVbYTu1VxR8dIOP6NLpf4fYjidpNm-diQ8&m=ZIASPHopBGyBDLyYLE8hmO-g4WzF4M3QpMj4R-VcCLk&s=7n7CnZc_rckkQ2h-lHuGpWuVIbdiinXYAD22IXQ8Ddc&e=> Prometheus + Grafana = https://prometheus.io/docs/visualization/grafana/<https://urldefense.proofpoint.com/v2/url?u=https-3A__prometheus.io_docs_visualization_grafana_&d=DwMFaQ&c=sA0VaJZJFLZREu2pbPeqjXHJ-Wd9NNzgHW3gpUOLSSk&r=CNKccIKIKCVbYTu1VxR8dIOP6NLpf4fYjidpNm-diQ8&m=ZIASPHopBGyBDLyYLE8hmO-g4WzF4M3QpMj4R-VcCLk&s=4e0XS2_1x-teGDTHdosxEP2g92IKFyH338kNZ5JY6Oc&e=> There are some dashboard examples like that: https://grafana.com/dashboards/371<https://urldefense.proofpoint.com/v2/url?u=https-3A__grafana.com_dashboards_371&d=DwMFaQ&c=sA0VaJZJFLZREu2pbPeqjXHJ-Wd9NNzgHW3gpUOLSSk&r=CNKccIKIKCVbYTu1VxR8dIOP6NLpf4fYjidpNm-diQ8&m=ZIASPHopBGyBDLyYLE8hmO-g4WzF4M3QpMj4R-VcCLk&s=EPiqDUO-0ZBgQuhHM6TX_uArTgViVWlJlp_NBX05Am0&e=> Looks good. Thanks, Petrus Silva On Wed, Jun 28, 2017 at 5:55 AM, Peng Xiao <2535...@qq.com<mailto:2535...@qq.com>> wrote: Dear All, we are currently using Cassandra 2.1.13,and it has grown to 5TB size with 32 nodes in one DC. For monitoring,opsCenter does not send alarm and not free in h
Re: How do you monitoring Cassandra Cluster?
I’ve collected a bunch at http://leaves.anant.us/#!/?tag=cassandra,monitoring I reommend Grafana / Prometheus if you don’t have DSE (which has OpsCenter) -- Rahul Singh rahul.si...@anant.us Anant Corporation On Jun 19, 2018, 1:06 PM -0400, Romain Gérard , wrote: > Hi Felipe, > > You can use this project https://github.com/criteo/cassandra_exporter if you > are using Prometheus (Disclamer, I am one of the author of it). > There is included a Grafana dashboard that aggregate metrics per cluster for > you, and in the "edit view" of each chart there are hidden queries that let > you drill down by nodes. > In any case, you can look at the json in order to grasp how to aggregate > queries. > > Let me know if you need more information regarding the setup. > > If you end-up using the project, give a star to the project it is always > pleasant, > Regards, > Romain Gérard > > > On Jun 18 2018, at 3:25 pm, Felipe Esteves > wrote: > > > > Hi, everyone, > > > > I'm running some tests to monitor Cassandra 3.x with jmx_exporter + > > prometheus + grafana. > > I've managed to config it all and use the dashboard > > https://grafana.com/dashboards/5408 > > > > However, I still can't aggregate metrics from all my cluster, just nodes > > individually. > > Any tips on how to do that? > > > > Also, Opscenter gives some datacenter aggregation, I think it comes from > > nodetool as I didn't seen any metrics about that. > > Anyone having success on that? > > > > cheers! > > > > Em qua, 28 de jun de 2017 às 19:43, Petrus Gomes > > escreveu: > > > I'm using JMX+Prometheus and Grafana. > > > JMX = https://github.com/prometheus/jmx_exporter > > > Prometheus + Grafana = https://prometheus.io/docs/visualization/grafana/ > > > > > > There are some dashboard examples like that: > > > https://grafana.com/dashboards/371 > > > Looks good. > > > > > > Thanks, > > > Petrus Silva > > > > > > On Wed, Jun 28, 2017 at 5:55 AM, Peng Xiao <2535...@qq.com> wrote: > > > > Dear All, > > > > > > > > we are currently using Cassandra 2.1.13,and it has grown to 5TB size > > > > with 32 nodes in one DC. > > > > For monitoring,opsCenter does not send alarm and not free in higher > > > > version.so we have to use a simple JMX+Zabbix template.And we plan to > > > > use Jolokia+JMX2Graphite to draw the metrics chart now. > > > > > > > > Could you please advise? > > > > > > > > Thanks, > > > > Henry > > > > > > > > > > > > > > > Esta mensagem pode conter informações confidenciais e somente o indivíduo > > > ou entidade a quem foi destinada pode utilizá-la. A transmissão incorreta > > > da mensagem não acarreta a perda de sua confidencialidade. Caso esta > > > mensagem tenha sido recebida por engano, solicitamos que o fato seja > > > comunicado ao remetente e que a mensagem seja eliminada de seu sistema > > > imediatamente. É vedado a qualquer pessoa que não seja o destinatário > > > usar, revelar, distribuir ou copiar qualquer parte desta mensagem. > > > Ambiente de comunicação sujeito a monitoramento. > > > > > > This message may include confidential information and only the intended > > > addresses have the right to use it as is, or any part of it. A wrong > > > transmission does not break its confidentiality. If you've received it > > > because of a mistake or erroneous transmission, please notify the sender > > > and delete it from your system immediately. This communication > > > environment is controlled and monitored. > > > > > > B2W Digital > > > > > > > > -- > > Felipe Esteves > > > > Tecnologia > > > > felipe.este...@b2wdigital.com > > > > Tel.: (21) 3504-7162 ramal 57162
Re: How do you monitoring Cassandra Cluster?
Hi Felipe, You can use this project https://github.com/criteo/cassandra_exporter if you are using Prometheus (Disclamer, I am one of the author of it). There is included a Grafana dashboard that aggregate metrics per cluster for you, and in the "edit view" of each chart there are hidden queries that let you drill down by nodes. In any case, you can look at the json in order to grasp how to aggregate queries. Let me know if you need more information regarding the setup. If you end-up using the project, give a star to the project it is always pleasant, Regards, Romain Gérard On Jun 18 2018, at 3:25 pm, Felipe Esteves wrote: > > Hi, everyone, > > I'm running some tests to monitor Cassandra 3.x with jmx_exporter + > prometheus + grafana. > I've managed to config it all and use the dashboard > https://grafana.com/dashboards/5408 > > However, I still can't aggregate metrics from all my cluster, just nodes > individually. > Any tips on how to do that? > > Also, Opscenter gives some datacenter aggregation, I think it comes from > nodetool as I didn't seen any metrics about that. > Anyone having success on that? > > cheers! > Em qua, 28 de jun de 2017 às 19:43, Petrus Gomes (mailto:petru...@gmail.com)> escreveu: > > I'm using JMX+Prometheus and Grafana. > > JMX = https://github.com/prometheus/jmx_exporter > > Prometheus + Grafana = https://prometheus.io/docs/visualization/grafana/ > > > > There are some dashboard examples like that: > > https://grafana.com/dashboards/371 > > Looks good. > > > > > > Thanks, > > Petrus Silva > > > > > > > > > > On Wed, Jun 28, 2017 at 5:55 AM, Peng Xiao <2535...@qq.com > > (mailto:2535...@qq.com)> wrote: > > > Dear All, > > > > > > we are currently using Cassandra 2.1.13,and it has grown to 5TB size with > > > 32 nodes in one DC. > > > For monitoring,opsCenter does not send alarm and not free in higher > > > version.so we have to use a simple JMX+Zabbix template.And we plan to use > > > Jolokia+JMX2Graphite to draw the metrics chart now. > > > > > > Could you please advise? > > > > > > Thanks, > > > Henry > > > > > > > > > > > > Esta mensagem pode conter informações confidenciais e somente o indivíduo > > ou entidade a quem foi destinada pode utilizá-la. A transmissão incorreta > > da mensagem não acarreta a perda de sua confidencialidade. Caso esta > > mensagem tenha sido recebida por engano, solicitamos que o fato seja > > comunicado ao remetente e que a mensagem seja eliminada de seu sistema > > imediatamente. É vedado a qualquer pessoa que não seja o destinatário usar, > > revelar, distribuir ou copiar qualquer parte desta mensagem. Ambiente de > > comunicação sujeito a monitoramento. > > This message may include confidential information and only the intended > > addresses have the right to use it as is, or any part of it. A wrong > > transmission does not break its confidentiality. If you've received it > > because of a mistake or erroneous transmission, please notify the sender > > and delete it from your system immediately. This communication environment > > is controlled and monitored. > > B2W Digital > -- > Felipe Esteves > > Tecnologia > felipe.este...@b2wdigital.com (mailto:seu.em...@b2wdigital.com) > Tel.: (21) 3504-7162 ramal 57162
Re: How do you monitoring Cassandra Cluster?
Hi, everyone, I'm running some tests to monitor Cassandra 3.x with jmx_exporter + prometheus + grafana. I've managed to config it all and use the dashboard https://grafana.com/dashboards/5408 However, I still can't aggregate metrics from all my cluster, just nodes individually. Any tips on how to do that? Also, Opscenter gives some datacenter aggregation, I think it comes from nodetool as I didn't seen any metrics about that. Anyone having success on that? cheers! Em qua, 28 de jun de 2017 às 19:43, Petrus Gomes escreveu: > I'm using JMX+Prometheus and Grafana. > JMX = https://github.com/prometheus/jmx_exporter > Prometheus + Grafana = https://prometheus.io/docs/visualization/grafana/ > > There are some dashboard examples like that: > https://grafana.com/dashboards/371 > Looks good. > > Thanks, > Petrus Silva > > On Wed, Jun 28, 2017 at 5:55 AM, Peng Xiao <2535...@qq.com> wrote: > >> Dear All, >> >> we are currently using Cassandra 2.1.13,and it has grown to 5TB size with >> 32 nodes in one DC. >> For monitoring,opsCenter does not send alarm and not free in higher >> version.so we have to use a simple JMX+Zabbix template.And we plan to use >> Jolokia+JMX2Graphite to draw the metrics chart now. >> >> Could you please advise? >> >> Thanks, >> Henry >> > > > -- > > Esta mensagem pode conter informações confidenciais e somente o indivíduo > ou entidade a quem foi destinada pode utilizá-la. A transmissão incorreta > da mensagem não acarreta a perda de sua confidencialidade. Caso esta > mensagem tenha sido recebida por engano, solicitamos que o fato seja > comunicado ao remetente e que a mensagem seja eliminada de seu sistema > imediatamente. É vedado a qualquer pessoa que não seja o destinatário usar, > revelar, distribuir ou copiar qualquer parte desta mensagem. Ambiente de > comunicação sujeito a monitoramento. > > This message may include confidential information and only the intended > addresses have the right to use it as is, or any part of it. A wrong > transmission does not break its confidentiality. If you've received it > because of a mistake or erroneous transmission, please notify the sender > and delete it from your system immediately. This communication environment > is controlled and monitored. > > B2W Digital > > > -- Felipe Esteves Tecnologia felipe.este...@b2wdigital.com Tel.: (21) 3504-7162 ramal 57162 --
Re: How do you monitoring Cassandra Cluster?
I'm using JMX+Prometheus and Grafana. JMX = https://github.com/prometheus/jmx_exporter Prometheus + Grafana = https://prometheus.io/docs/visualization/grafana/ There are some dashboard examples like that: https://grafana.com/dashboards/371 Looks good. Thanks, Petrus Silva On Wed, Jun 28, 2017 at 5:55 AM, Peng Xiao <2535...@qq.com> wrote: > Dear All, > > we are currently using Cassandra 2.1.13,and it has grown to 5TB size with > 32 nodes in one DC. > For monitoring,opsCenter does not send alarm and not free in higher > version.so we have to use a simple JMX+Zabbix template.And we plan to use > Jolokia+JMX2Graphite to draw the metrics chart now. > > Could you please advise? > > Thanks, > Henry >
How do you monitoring Cassandra Cluster?
Dear All, we are currently using Cassandra 2.1.13,and it has grown to 5TB size with 32 nodes in one DC. For monitoring,opsCenter does not send alarm and not free in higher version.so we have to use a simple JMX+Zabbix template.And we plan to use Jolokia+JMX2Graphite to draw the metrics chart now. Could you please advise? Thanks, Henry