Aerospikeシリーズ:6:AerospikeTools&Utilities

1:Aerospike Query LanguageはSQLコマンドと似ています.インデックスとユーザー定義関数を管理したり、ほとんどのデータベースの機能をテストしたりすることができます.

[root@localhost ~]#aql OPTIONS

-h <host> #Default: 127.0.0.1
-p <port> #Default: 3000
-c <command>
-f <filepath>
-v #Enable verbose output.
-e #Enable echoing of commands.
-T <milliseconds> #Set the timeout (ms) for commands.#Default: 1000
-o (json | table) #Set the output mode.Default: table
-u <path> #Path to User managed UDF modules.
-s <path> #Path to the System managed UDF modules.
--help #Displays the usage information

Data Management

aql> show namespaces 
aql> show sets 
aql> show bins

　　

UDF Management

Index Management

SHOW INDEXES [<ns>]
  ：show indexes test


CREATE INDEX <index> ON <ns>[.<set>] (<bin>) <type>
  ：create index idx_ind2 on test.ind('uname') string

DROP INDEX <ns> <index>
  ：drop index test idx_ind2


asinfo -v "sindex-repair:ns=test;indexname=ind_name;set=set_name;"
+-------+--------------+
| state |  sync_state  |
+-------+--------------+
| "RW"  | "need_sync"  |
+-------+--------------+
  ：asinfo -v "sindex-repair:ns=test;indexname=idx_ind;set=ind;"

　　

Query and Scan Management

Record Operations

Querying Records

Statistics

Settings

2:Backup and RestoreUse a node outside the cluster and, in a distributed way, pull out all 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リアルタイムのモニタリングクラスタのサイズと健康状態.
4:Aerospike Adminリアルタイムでクラスタのサイズと健康状態を監視します.Aerospike Monitorをすぐに置き換える管理クラスタの関数も用意されています
5:Log Latency ToolAerospike 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はJSONのコマンドラインツールをサポートし、クラスタ内のデータの設定と照会、カスタム関数の管理が可能
7:Aerospike InfoThis low-level tool can make requests to an 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 UtilityThis simple tools allows setting and getting individual values from the cluster. Good for basic validation.