Aerospike series: 6:aerospiketools & Utilities

1:aerospike Query Language
Similar to the SQL command. Can be used to manage indexes and user-defined functions, or to test the functionality of most databases.

1 2 3 4 5 6 7 8 9 10 11 12 13

[root@localhost ~] #aql options-h

Data Management?

1 2 3

Aql> Show Namespaces aql> Show sets aql> show bins

UDF Management Index Management?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

Show INDEXES [<ns>] Example: Show INDEXES Test CREATE Index < index > on <ns>[.< set;] (<bin> <type> Example: Create INDEX Idx_ind2 on Test.ind (' uname ') string DROP index <ns> < index > Example: DROP in Dex Test Idx_ind2 asinfo-v "sindex-repair:ns=test;indexname=ind_name;set=set_name;" +-------+--------------+ |  State | Sync_state | + -------+--------------+ | "RW" | "Need_sync" | +-------+--------------+ Example: asinfo-v "Sindex-repair:ns=test;indexname=idx_ind;set=ind;"

Query and Scan Management Record Operations querying Records Statistics Settings

2:backup and Restore
Use a node outside the cluster and, in a distributed-out-of-the-cluster ' s data into a text file. Or, restore the data from one of these files. Source is included, allowing this tool to be modified.

3:aerospike Monitor
Real-time monitoring of cluster size and health status.

4:aerospike Admin
Real-time monitoring of cluster size and health status. and provides a function to manage the cluster, which will soon replace the Aerospike Monitor

5:log Latency Tool
Aerospike contains a number of settings that allow latency issues in a server to be diagnosed. This tool analyzes a logfile and displays, the different components of a transaction.

6:aerospike Command Line
Support for JSON-enabled command-line tools to set up and query data in a cluster, or to manage custom functions

7:aerospike Info
This low-level tool can make requests to a individual server over Aerospike ' s command language. Useful for gathering statistics, and also setting a variety of tuning parameters. Often used by higher level scripts.

8:command Line Utility
This simple tools allows setting and getting individual values from the cluster. Good for basic validation.