ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > > Aerospike入坑导读

Aerospike入坑导读

作者：gaokeke123 时间：2022-06-21 15:37:28 0 删除 编辑

  Aerospike是一个以分布式为核心，T级别大数据高并发的结构化数据存储解决方案，读写操作达微妙级，索引内存化数据固态化，自动感知集群状态，节点间数据强一致性，平滑扩展以及丰富的开发语言支持，和redis相比aql介入的更有亲和力，对RDBMS的支持更好，熟悉sql的小哥哥小姐姐表示毫无压力，不过稳定性和普及率还有相当的差距，据说许多互联网广告相关业务都用它存储中间数据，难道我这些年混的都是假的互联网广告公司吗，有用的请举个爪儿。

AerospikeMySQL
namespacedb
settable
bincolumn
keyprimary key
recordrow

    下载地址：https://www.aerospike.com/artifacts/aerospike-server-community/，解压执行asinstall，service aerospike [start|stop|status]管理服务，/etc/aerospike/aerospike.conf服务端配置文件中network块中heartbeat部分配置了集群的组播地址与端口，namespace块定义自己的业务命名空间；/etc/aerospike/astools.conf为aql端配置文件，其中aql块中timeout项被屏蔽默认1000毫秒，实操经验显示太短，建议改为2000以上；

  1. （解压缩）
  2. [root@localhost ~]# tar xvf aerospike-server-community-4.2.0.5-el7.tgz 
  3. aerospike-server-community-4.2.0.5-el7/
  4. aerospike-server-community-4.2.0.5-el7/SHA256SUMS
  5. aerospike-server-community-4.2.0.5-el7/aerospike-tools-3.15.3.8-1.el7.x86_64.rpm
  6. aerospike-server-community-4.2.0.5-el7/LICENSE
  7. aerospike-server-community-4.2.0.5-el7/asinstall
  8. aerospike-server-community-4.2.0.5-el7/aerospike-server-community-4.2.0.5-1.el7.x86_64.rpm
  9.  
  10. （进入安装目录）
  11. [root@localhost ~]# cd aerospike-server-community-4.2.0.5-el7/
  12.  
  13. （安装）
  14. [root@localhost aerospike-server-community-4.2.0.5-el7]# ./asinstall 
  15. Installing tools
  16. rpm -Uvh aerospike-tools-3.15.3.8-1.el7.x86_64.rpm
  17. 准备中...                          ################################# [100%]
  18. 	软件包 aerospike-tools-3.15.3.8-1.el7.x86_64 已经安装
  19. Installing server
  20. rpm -Uvh aerospike-server-community-4.2.0.5-1.el7.x86_64.rpm
  21. 准备中...                          ################################# [100%]
  22. 	软件包 aerospike-server-community-4.2.0.5-1.el7.x86_64 已经安装
  23.  
  24. （启动服务）
  25. [root@localhost aerospike-server-community-4.2.0.5-el7]# service aerospike start
  26. /bin/mountpoint: /usr/local/lib/libuuid.so.1: no version information available (required by /lib64/libblkid.so.1)
  27. /bin/mountpoint: /usr/local/lib/libuuid.so.1: no version information available (required by /lib64/libblkid.so.1)
  28. Redirecting to /bin/systemctl start  aerospike.service
  29.  
  30. （查看服务状态）
  31. [root@localhost aerospike-server-community-4.2.0.5-el7]# service aerospike status
  32. /bin/mountpoint: /usr/local/lib/libuuid.so.1: no version information available (required by /lib64/libblkid.so.1)
  33. /bin/mountpoint: /usr/local/lib/libuuid.so.1: no version information available (required by /lib64/libblkid.so.1)
  34. Redirecting to /bin/systemctl status  aerospike.service
  35. ● aerospike.service - Aerospike Server
  36.    Loaded: loaded (/usr/lib/systemd/system/aerospike.service; disabled; vendor preset: disabled)
  37.   Drop-In: /etc/systemd/system/aerospike.service.d
  38.            └─aerospike.conf
  39.    Active: active (running) since 一 2018-07-23 16:25:21 CST; 17s ago
  40.   Process: 7452 ExecStartPre=/bin/systemctl start aerospike_telemetry (code=exited, status=0/SUCCESS)
  41.   Process: 7444 ExecStartPre=/usr/bin/asd-systemd-helper (code=exited, status=0/SUCCESS)
  42.  Main PID: 7455 (asd)
  43.    CGroup: /system.slice/aerospike.service
  44.            └─7455 /usr/bin/asd --config-file /etc/aerospike/aerospike.conf --fgdaemon
  45.  
  46. 7月 23 16:25:31 localhost.localdomain asd[7455]: Jul 23 2018 08:25:31 GMT: INFO (info): (ticker.c:291)    in-progress: tsvc-q 0 info-q 0 nsup-delete-q 0 rw-hash 0 proxy-hash 0 tree-gc-q 0
  47. 7月 23 16:25:31 localhost.localdomain asd[7455]: Jul 23 2018 08:25:31 GMT: INFO (info): (ticker.c:313)    fds: proto (0,3,3) heartbeat (0,0,0) fabric (0,0,0)
  48. 7月 23 16:25:31 localhost.localdomain asd[7455]: Jul 23 2018 08:25:31 GMT: INFO (info): (ticker.c:322)    heartbeat-received: self 67 foreign 0
  49. 7月 23 16:25:31 localhost.localdomain asd[7455]: Jul 23 2018 08:25:31 GMT: INFO (info): (ticker.c:353)    fabric-bytes-per-second: bulk (0,0) ctrl (0,0) meta (0,0) rw (0,0)
  50. 7月 23 16:25:31 localhost.localdomain asd[7455]: Jul 23 2018 08:25:31 GMT: INFO (info): (ticker.c:408) {test} objects: all 0 master 0 prole 0 non-replica 0
  51. 7月 23 16:25:31 localhost.localdomain asd[7455]: Jul 23 2018 08:25:31 GMT: INFO (info): (ticker.c:469) {test} migrations: complete
  52. 7月 23 16:25:31 localhost.localdomain asd[7455]: Jul 23 2018 08:25:31 GMT: INFO (info): (ticker.c:488) {test} memory-usage: total-bytes 0 index-bytes 0 sindex-bytes 0>
    7月 23 16:25:31 localhost.localdomain asd[7455]: Jul 23 2018 08:25:31 GMT: INFO (info): (ticker.c:408) {3gu} objects: all 0 master 0 prole 0 non-replica 0
  53. 7月 23 16:25:31 localhost.localdomain asd[7455]: Jul 23 2018 08:25:31 GMT: INFO (info): (ticker.c:469) {3gu} migrations: complete
  54. 7月 23 16:25:31 localhost.localdomain asd[7455]: Jul 23 2018 08:25:31 GMT: INFO (info): (ticker.c:488) {3gu} memory-usage: total-bytes 0 index-bytes 0 sindex-bytes 0>
     
  55. （客户端接入）
  56. [root@localhost aerospike-server-community-4.2.0.5-el7]# aql 
  57. Seed:         127.0.0.1
  58. User:         None
  59. Config File:  /etc/aerospike/astools.conf /root/.aerospike/astools.conf 
  60. Aerospike Query Client
  61. Version 3.15.3.8
  62. C Client Version 4.3.12
  63. Copyright 2012-2017 Aerospike. All rights reserved.
  64. aql> show namespaces
  65. +------------+
  66. | namespaces |
  67. +------------+
  68. | "test"     |
  69. | "myns"      |
  70. +------------+
  71. [127.0.0.1:3000] 2 rows in set (0.003 secs)
  72.  
  73. OK
  74.  
  75. （查看接入配置）
  76. aql> get all
  77. ECHO = false
  78. VERBOSE = false
  79. OUTPUT = TABLE
  80. OUTPUT_TYPES = true
  81. TIMEOUT = 3000
  82. LUA_USERPATH = /opt/aerospike/usr/udf/lua
  83. LUA_SYSPATH = /opt/aerospike/sys/udf/lua
  84. USE_SMD = false
  85. RECORD_TTL = 0
  86. RECORD_PRINT_METADATA = false
  87. REPLICA_ANY = false
  88. KEY_SEND = false
  89. DURABLE_DELETE = false
  90. FAIL_ON_CLUSTER_CHANGE = true
  91. SCAN_PRIORITY = AUTO
  92. NO_BINS = false
  93. LINEARIZE_READ = false
  94.  
  95. （执行插入操作）
  96. aql> insert into myns(pk,id,name,host,port,info) values('key1','001','AAA','192.168.0.1','10001','设备一')
  97. OK, 1 record affected.
  98.  
  99. （执行查询操作）
  100. aql> select * from myns
  101. +-------+-------+---------------+---------+-------------+
  102. | id    | name  | host          | port    | info        |
  103. +-------+-------+---------------+---------+-------------+
  104. | "001" | "AAA" | "192.168.0.1" | "10001" | "设备一" 	|
  105. +-------+-------+---------------+---------+-------------+
  106. 1 row in set (1.311 secs)
  107.  
  108. （执行删除操作）
  109. aql> delete from myns where pk='key1'
  110. OK, 1 record affected.
  111.  
  112. （执行查询操作）
  113. aql> select * from myns
  114. 0 rows in set (1.269 secs)
  115.  
  116. OK
wAAACH5BAEKAAAALAAAAAABAAEAAAICRAEAOw==wAAACH5BAEKAAAALAAAAAABAAEAAAICRAEAOw==

    Aerospike从安装到启动到操作上面都逐一演示了一遍，下一篇文章打算选择一个开发语言来实现远程连接和执行上述操作，为使用Aerospike的研发小伙伴抛砖引玉。

来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26692020/viewspace-3170354/ ，如需转载，请注明出处，否则将追究法律责任。

0
0
上一篇： lokijs可以用mysql_JavaScript实现的内存数据库LokiJS介绍和入门实例_jav
下一篇： 给usql添加DuckDB支持
请登录后发表评论 登录
全部评论
gaokeke123
大家好

注册时间：2013-08-14

  • 博文量
    1432
  • 访问量
    31637

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593