Volta Control user manual
Contents
1. SATELLITE VOLTA AIN Volta Control user manual www satellitevolta com SATELLITE VOLTA TABLE OF CONTENTS I VOLTA CONTROL ee tat eee Da EE a Es EE a 3 Z SYSTEM REQUIREMENT 04665 5007 rare ina resina an 3 5 HOW TO USE VOLTA CONTROL ases EROE TERREI 3 HW USER MANUAL aviaria a a dida 4 4 1 CONNECTIONS TO APACHE CASSANDRA 20000 4 4 2 SETUP A NEW CONNECTION ccoo coo a 5 Hu CONNECTIONS EDITOR 4 6s 200 008 6S 0446 00 daa Noi HELP soglia Pew POS ae eee ses ese eeeoesacueg es 8 Hao LANGUAGE cerradas danesa A 8 i QUERY MANAGER t bcc rabbia 9 La Dedo KEV OPACES 42450940 OW TOLTI 10 4 02 MUERE EDITOR eli LI 45 3 COLUMNS DESCRIPTION iri iva a di ELA bw A 15 LO QUERY LOG sacro e e k ae a e ri e di 15 gt VOLTA CONTROL LICENSE ssi Iii 13 www satellitevolta com 2 SATELLITE VOLTA Volta Control is a visual tool for designing implementing and managing databases on Apache Cassandra With Volta Control you can control keyspaces and tables in each cluster node and read write delete data using CQL code 1 VOLTA CONTROL For further information about Volta Control manual latest release etc and Satellite Volta project please visit www satellitevolta com or send an email to Support satellitevolta com for technical support 2 SYSTEM REQUIREMENTS To use Volta Control a JRE Java Runtime Environment version 6 or greater www java com is required 4 How TO USE VOLTA CONTROL Volta Contro2. com Volta Control includes software distributed under the following licenses cassandra driver core 2 1 0 jar Copyright 2012 DataStax Inc Licensed under the Apache License Version 2 0 the License guava 16 0 1 jar Copyright 2015 The Guava Authors Licensed under the Apache License Version 2 0 the License l094J ap1 2 0 2 Jar Copyright 1999 2015 Apache Software Foundation Licensed under the Apache License Version 2 0 the License 1 LAS www satellitevolta com SATELLITE VOLTA log4j core 2 0 2 jar Copyright O 1999 2015 Apache Software Foundation Licensed under the Apache License Version 2 0 the License metrics core 3 0 2 jar Copyright 2010 2015 Coda Hale Yammer com Licensed under the Apache License Version 2 0 the License netty 3 9 0 Final jar Copyright O 2015 The Netty project Licensed under the Apache License Version 2 0 the License sif4j api 1 7 5 jar Copyright 2004 2015 QOS ch All rights reserved Permission is hereby granted free of charge to any person obtaining a copy of this software and associated documentation files the Softvvare to deal in the Software without restriction including without limitation the rights to use copy modify merge publish distribute sublicense and or sell copies of the Software and to permit persons to whom the Software is furnished to do so subject to the following conditions The above copyright notice and t
3. heck the configuration Cancel Cancels the action OK Saves connection for later use www satellitevolta com SATELLITE VOLTA 4 4 CONNECTIONS EDITOR Clicking the button Edit Connections you can configure connections to Apache Cassandra nodes I Volta Control CONNECTIONS EDITOR Connection 35 Connection name Connection 36 Parameters Connection s IP address Anonymous Usemame Password Default keyspace The leftmost list shows the available connections Clicking on one of them you can change the parameters node IP type of access username password default keyspace and execute the following actions Test connection Connects to the node to check the configuration Cancel Cancels the action OK Saves connection for later use Moreover you can also execute the following actions Create www satellitevolta com T SATELLITE VOLTA Creates a new connection filling the form on the right Delete Deletes the connection to the Apache Cassandra node selected Clone Duplicates the selected connection cloning parameters 4 4 HELP The Help button shows a menu with 2 items Volta Control License with Information about the terms of use and About Volta Control with details on current version The Help button is also available in the query manager 4 5 LANGUAGE Using the Language button you can select the favorite language The Language button is also ava
4. his permission notice shall be included in all copies or substantial portions of the Software The software is provided as is without warranty of any kind Express or implied including but not limited to the warranties of Merchantability fitness for a particular purpose and Noninfringement In no event shall the authors or copyright holders be Liable for any claim damages or other liability whether in an action Of contract tort or otherwise arising from out of or in connection With the software or the use or other dealings in the software www satellitevolta com
5. ilable in the query manager www satellitevolta com 8 SATELLITE VOLTA AIN 4 6 QUERY MANAGER In the main panel Connections to Apache Cassandra you can click on a connection to start the query manager and connect to an Apache Cassandra node II Volta Control File Language Help KEYSPACES system FE batchlog EE compactions in progress EE compaction history EE hints EEE Indexinfo E local EE range xfers EE schema_columnfamilies EE schema_columns E schema_keyspaces EE schema triggers FE crhoma meertinas COLUMNS Name id Partition bytes_in bytes_out columnfamily_name compacted_at Keyspace name rows_merged UID BIGINT _ __ BIGINT nar TIMESTAMP TEXT MAP F Limitresults 500 e gt L SELECT id bytes_in bytes_out columnfamily name compacted at keyspace name rows merged FROM system compaction history bytes_in bytes_out 7134fde0 ca20 1184 9420c 4f4fd5 240098 60837 aa29fad0 ca36 11e4 942c 4f4fd5 250106 OUTPUT Time Message Duration Fetch 19 03 2015 13 29 SELECT id byte 95 Row s 0 015 sec 0 022 The query manager has four areas Keyspaces Query editor Columns description www satellitevolta com SATELLITE VOLTA 4 6 1 KEYSPACES Query log The keyspaces area shows a tree of objects connection to the Apache Cassandra node the keyspaces of the node the default keyspace if any is bold
6. l is available on www satellitevolta com both as a distribution package for Windows system in zip format and Linux system in tar gz format and as an installer for Debian and Ubuntu distributions in deb format and CentOS distributions in rpm format If you chose the distribution package to start using Volta Control follow these steps Decompress the Volta Control distribution package Launch Volta Control by double clicking on volta control x y z jar or from a shell command prompt execute Java yar volta control x y z Jar where x y z is the Volta Control version you have just downloaded If you chose the installer package to install it run one of the following commands depending on your distribution On Debian Ubuntu www satellitevolta com SATELLITE VOLTA AIN sudo dpkg i volta control_x y z k_all deb Qn CentOS sudo rpm 1 volta controlx y z k_noarch rpm where x y z k is the Volta Control version you have just downloaded Once the installation ended you can start Volta Control by running the following command volta control At first launch Volta Monitor creates the folder volta control in the user account folder in that folder the application will save connections data logs preferences etc 4 USER MANUAL The next pages introduce the Volta Control tool giving details about the main features available 4 1 CONNECTIONS TO APACHE CASSANDRA Launch Volta Control and after the s
7. le DROP statement Writes a CQL query in the query editor to execute a DROP of the current table QUERY EDITOR In the query editor you can write and execute CQL queries for databases in Apache Cassandra separated by taking advantage of suggestions and autocomplete features invoked by pressing CTRL TAB Several queries can be executed all at once pressing Execute button or you can execute only the selected query pressing Execute selection button You can also limit the number of rows returned inserting a number in Limit results box Query results are shown below the query editor in a tab You can export results in CVS comma separated values using the context menu activated by right click www satellitevolta com SATELLITE VOLTA AIN SATELLITE VOLTA 4 6 3 COLUMNS DESCRIPTION The columns description area shows information about columns of the table selected In the keyspace tree Clicking on each table you can see names and types of columns available 4 6 4 QUERY LOG The query log traces details of all queries executed The Query Log can be cleared by context menu activated by right click 5 VOLTA CONTROL LICENSE Volta Control Copyright 2014 2015 Sogetel S r l All rights reserved Volta Control is available for free under the terms of the license Satellite Volta Software License Version 1 0 September 2014 For more details visit the website www satellitevolta
8. plash screen you will see the list of connections to Apache Cassandra nodes IN Volta Control CONNECTIONS TO APACHE CASSANDRA CONNECTIONDS5 CONNECTION 36 CONNECTION 3 3 Anonymous system amp cassandra system 3 Anonymous S 192 168 0 35 9042 192 168 0 36 9042 192 168 0 37 9042 Each connection shows some details as name of connection user name default keyspace if defined IP address and port www satellitevolta com 4 SATELLITE VOLTA With a right click on a connection you can use the context menu for executing the following actions Open connection Starts a connection to an Apache Cassandra node and opens the query manager Edit connection Opens the connection manager panel to change the connection parameters Delete connection Removes a connection permanently Delete all connections Removes all connections in one time If you click on a connection an Apache Cassandra node will be selected to be queried and the query manager will be opened 4 2 SETUP A NEW CONNECTION Clicking the button Setup a new connection in the connections panel you can create anew connection to an Apache Cassandra node iy Volta Control SETUP NEW CONNECTION Connection name Parameters IP address Fort Anonymous Username Password Default keyspace www satellitevolta com 5 SATELLITE VOLTA I Fill in the form and then click on Connection test Connects to the node to c
9. the tables of each keyspace The context menu of the tree root activated by a right click on Apache Cassandra node has the item Refresh all that reloads the tree objects You can also refresh the tree pressing F5 The context menu of a keyspace element activated by a right click has the following items Set as default keyspace Sets the current keyspace as the default keyspace for CQL query execution Refresh all F5 Refreshes the tree CREATE statement Writes a COL query for current keyspace creation in the query editor DROP statement Writes a CQL query for current keyspace deletion in the query editor The context menu of a table element activated by a right click has the following items Refresh all F5 Refreshes the tree SELECT statement Writes a CQL query in the query editor to execute a SELECT in the current table INSERT statement www satellitevolta com 10 4 6 2 www satellitevolta com SATELLITE VOLTA Writes a CQL query in the query editor to execute an INSERT in the current table CREATE statement Writes a CQL query in the query editor to execute a CREATE of the current table UPDATE statement Writes a CQL query in the query editor to execute an UPDATE of the current table DELETE statement Writes a CQL query in the query editor to execute a DELETE in the current table DELETE ALL statement Writes a CQL query in the query editor to execute a DELETE ALL in the current tab
Download Pdf Manuals
Related Search