SQWareWeb:cassandra

Presentation

It is the repository module, and stores rdbms indicators for all RDBMS.
It is a MySQL database.
Objects prefix by tsqw_% or isqw_% are generic.
Objects prefix by tsqwcas_% or isqwcas_% are specific for Cassandra.
Installation guide for SQWareRepository for Cassandra

Naming convention

All specific objects for Cassandra are named with prefixes:

• tsqwcas_% : for tables
• isqwcas_% : for index
• isqwcas_%_u : for uniques
• isqwcas_%_pk : for primary key

Specific database content for Cassandra

tsqwcas_InstanceDetail

This table contains : ...
Desc of tsqwcas_InstanceDetail :

Field Type
dbalias varchar(80)
nodename varchar(80)
gather_date datetime
size_instance decimal(12,2)
used decimal(12,2)
free decimal(12,2)
status varchar(80)
tokens decimal(12,2)
owns decimal(12,2)
hostid varchar(80)
rack varchar(80)
maj_version int(11)
version varchar(30)
cluster_name varchar(512)
data_center varchar(512)

tsqwcas_Keyspace

This table contains : ...
Desc of tsqwcas_Keyspace :

Field Type
dbalias varchar(80)
keyspace_name varchar(255)
gather_date datetime
size_keyspace decimal(12,2)
used decimal(12,2)
free decimal(12,2)
durable_writes varchar(255)
strategy_class varchar(1024)
strategy_options varchar(1024)

tsqwcas_KeyspaceDetail

This table contains : ...
Desc of tsqwcas_KeyspaceDetail :

Field Type
dbalias varchar(80)
nodename varchar(80)
keyspace_name varchar(255)
gather_date datetime
size_keyspace decimal(12,2)
used decimal(12,2)
free decimal(12,2)

tsqwcas_VolTables

This table contains : ...
Desc of tsqwcas_VolTables :

Field Type
dbalias varchar(80)
keyspace_name varchar(255)
table_name varchar(255)
gather_date datetime
size_table decimal(12,2)
used decimal(12,2)
free decimal(12,2)
CompressionRatio decimal(18,12)
Numberofkeys decimal(12,2)

tsqwcas_VolTablesDetail

This table contains : ...
Desc of tsqwcas_VolTablesDetail :

Field Type
dbalias varchar(80)
nodename varchar(80)
keyspace_name varchar(255)
table_name varchar(255)
gather_date datetime
size_table decimal(12,2)
used decimal(12,2)
free decimal(12,2)
CompressionRatio decimal(18,12)
Numberofkeys decimal(12,2)