Re: Which open source or free tool do you use to monitor cassandra clusters?

[Alex Ott]

Look onto https://github.com/datastax/metric-collector-for-apache-cassandra

On Wed, Jun 16, 2021 at 5:21 PM Surbhi Gupta 
wrote:

> Hi,
>
> Which open source or free tool do you use to monitor cassandra clusters
> which have similar features like Opscenter?
>
> Thanks
> Surbhi
>
>

-- 
With best wishes,Alex Ott
http://alexott.net/
Twitter: alexott_en (English), alexott (Russian)

Re: Which open source or free tool do you use to monitor cassandra clusters?

[Joe Obernberger]

I've been using Grafana+Prometheus and the 
jmx_prometheus_javaagent-0.15.0.jar agent on the cassandra cluster.

Then use CassandraReaper for scheduled repairs.

Used this guide:

https://www.cloudwalker.io/2020/05/17/monitoring-cassandra-with-prometheus/

-Joe

On 6/16/2021 11:21 AM, Surbhi Gupta wrote:

Hi,

Which open source or free tool do you use to monitor cassandra 
clusters which have similar features like Opscenter?


Thanks
Surbhi


 
	Virus-free. www.avg.com 
 



<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Which open source or free tool do you use to monitor cassandra clusters?

[Surbhi Gupta]

Hi,

Which open source or free tool do you use to monitor cassandra clusters
which have similar features like Opscenter?

Thanks
Surbhi

Regarding static column added in compact tables through Cassandra-stress tool

[Radha Wadhera]

Hi,

I have Cassandra 3.11 installed on my setup.* I used the Cassandra-stress
tool to create data for my cluster.*


*# cassandra-stress write n=800 -log file=/tmp/1 level=verbose -mode native
cql3 user=cassandra password=cassandra -node nodeip*
I saw that two tables were created "counter1 and standard1".
*The "counter1" table had no data and also was created with the following
configuration:*

CREATE TABLE keyspace1.counter1 (

key blob,

column1 text,

*"C0" counter static,*

*"C1" counter static,*

*"C2" counter static,*

*"C3" counter static,*

*"C4" counter static*,

value counter,

PRIMARY KEY (key, column1)

) *WITH COMPACT STORAGE*

AND CLUSTERING ORDER BY (column1 ASC)

AND bloom_filter_fp_chance = 0.01

AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}

AND comment = ''

AND compaction = {'class':
'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy',
'max_threshold': '32', 'min_threshold': '4'}

AND compression = {'enabled': 'false'}

AND crc_check_chance = 1.0

AND dclocal_read_repair_chance = 0.1

AND default_time_to_live = 0

AND gc_grace_seconds = 864000

AND max_index_interval = 2048

AND memtable_flush_period_in_ms = 0

AND min_index_interval = 128

AND read_repair_chance = 0.0

AND speculative_retry = '99PERCENTILE';




*Now if I try to create a similar schema manually with above-mentioned
schema, I get the following error. *InvalidRequest: Error from server:
code=2200 [Invalid query] message="*Static columns are not supported in
COMPACT STORAGE tables*"



I further read more about this error and found that *static columns cannot
be used with COMPACT STORAGE tables*.
Here is the documentation for the same :

   1.
   https://docs.datastax.com/en/cql-oss/3.3/cql/cql_using/useCompactStorage.html
   2. https://programmersought.com/article/81431553936/


*If the above configuration is not supported schema then can you please let
me know how the "Cassandra-stress" tool is able to create a table with not
supported schema configuration?*

*Any help will be much appreciated.*

Regards
Radha Wadhera