Aerospike系列：6：AerospikeTools & Utilities

最新推荐文章于 2024-10-24 09:15:00 发布

转载最新推荐文章于 2024-10-24 09:15:00 发布 · 1.1k 阅读

Aerospike 专栏收录该内容

9 篇文章

订阅专栏

本文介绍了Aerospike数据库的管理工具集，包括查询语言(AQL)、备份与恢复工具、实时监控工具、命令行工具等，这些工具帮助用户更好地管理和操作Aerospike数据库。

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 Restore
Use 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 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
支持JSON的命令行工具，可以设置和查询集群中的数据，也可以管理自定义函数

7：Aerospike Info
This 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 Utility
This simple tools allows setting and getting individual values from the cluster. Good for basic validation.