Difference between revisions of "SQWareWeb:cassandra"

From Wiki_dbSQWare
Jump to: navigation, search
(Replaced content with '{{SQWareWebPres|Cassandra|cassandra|instance|Global, databases, backups| }}')
 
Line 1: Line 1:
{{SQWareRepositoryPresSgbd|Cassandra|database|CAS_SID|cas}}
+
{{SQWareWebPres|Cassandra|cassandra|instance|Global, databases, backups|
== 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>
 
 
}}
 
}}

Latest revision as of 18:29, 8 August 2015

Presentation

Usage

It is the specific part of 'graphic' restitution of dbSQWare for Cassandra.
SQWareWeb Cassandra formats (graphs or tables) datas uploaded in SQWareRepository Cassandra by many scripts of SQWareProduction module for Cassandra. Almost all of the data presented are dynamically generated (volumes, versions, ...), only the data type repository or settings are stored manually in the relevant tables.
Example of static table : tsqw_Repository

Examples of pages presented for Cassandra:

  • Inventory of instances Cassandra with volumetry, version, environnement, ...
  • Distribution of instance in number/volumetry per environnement/client/version
  • Detail of volumetry (Global, databases, backups)
  • Trace of scripts executions of SQWareProduction Cassandra (beginning, end, options, duration, return code, ...)
  • Performances datas
  • Capacity planning
  • ...


Presentation model of SQWareWeb for Cassandra.

Explanation of directories

Directories located in $gvsqw_RootexpdbWebdba/htdocs/cassandra :

  • bin : Directory containing standard scripts
  • general : Directory containing general reports for all managed instances
  • detail : Directory containing contient specific report for one selected instance Cassandra
  • tech : Directory containing contient "technical" reports, some general and others specific per instance Cassandra
  • dashboard : Directory containing contient changes on instances (removed/created, patched/upgraded), and distributions



Nuvola apps important.png
Warning:
Do not change the standard configuration files of dbSQWare.

Use directories $gvsqw_RootexpdbWebdba/custom/* for customizations. This will facilitate version upgrades.