SQWareRepository:cassandra

From Wiki_dbSQWare
Jump to: navigation, search

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


Nuvola apps important.png
Warning:
Do not change the standard tables of the tool. For your custom objects, use another name convention than dbSQWare.

This will facilitate version upgrades.


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)