Difference between revisions of "SQWareWeb:cassandra"
Expdbtools (talk | contribs) (Created page with '{{SQWareRepositoryPresSgbd|Cassandra|database|CAS_SID|cas}} == Specific database content for Cassandra ==') |
Expdbtools (talk | contribs) |
||
| Line 1: | Line 1: | ||
{{SQWareRepositoryPresSgbd|Cassandra|database|CAS_SID|cas}} | {{SQWareRepositoryPresSgbd|Cassandra|database|CAS_SID|cas}} | ||
== Specific database content for Cassandra == | == Specific database content for Cassandra == | ||
| + | |||
| + | {{SQWareRepositoryTables|tsqwcas_InstanceDetail| | ||
| + | <nowiki>...</nowiki>| | ||
| + | <pre> | ||
| + | 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) | ||
| + | </pre> | ||
| + | }} | ||
| + | |||
| + | {{SQWareRepositoryTables|tsqwcas_Keyspace| | ||
| + | <nowiki>...</nowiki>| | ||
| + | <pre> | ||
| + | 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) | ||
| + | </pre> | ||
| + | }} | ||
| + | |||
| + | {{SQWareRepositoryTables|tsqwcas_KeyspaceDetail| | ||
| + | <nowiki>...</nowiki>| | ||
| + | <pre> | ||
| + | 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) | ||
| + | </pre> | ||
| + | }} | ||
| + | |||
| + | {{SQWareRepositoryTables|tsqwcas_VolTables| | ||
| + | <nowiki>...</nowiki>| | ||
| + | <pre> | ||
| + | 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) | ||
| + | </pre> | ||
| + | }} | ||
| + | |||
| + | {{SQWareRepositoryTables|tsqwcas_VolTablesDetail| | ||
| + | <nowiki>...</nowiki>| | ||
| + | <pre> | ||
| + | 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) | ||
| + | </pre> | ||
| + | }} | ||
Revision as of 18:07, 8 August 2015
Contents
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)
