emqtt数据存储mysql,数据存储 - MongoDB 消息存储 - 《EMQ X Enterprise v3.0 中文文档》 - 书栈网 · BookStack...

MongoDB 消息存储

配置 MongoDB 消息存储

配置文件: emqx_backend_mongo.conf

配置 MongoDB 服务器

支持配置多台 MongoDB 服务器连接池:## MongoDB 集群类型: single | unknown | sharded | rs

backend.mongo.pool1.type=single

## 如果 type = rs; 需要配置 setname

## backend.mongo.pool1.rs_set_name = testrs

## MongoDB 服务器地址列表

backend.mongo.pool1.server=127.0.0.1:27017

## MongoDB 连接池大小

backend.mongo.pool1.c_pool_size=8

## 连接的数据库名称

backend.mongo.pool1.database=mqtt

## MongoDB 认证用户名密码

## backend.mongo.pool1.login = emqtt

## backend.mongo.pool1.password = emqtt

## MongoDB 认证源

## backend.mongo.pool1.auth_source = admin

## 是否开启 SSL

## backend.mongo.pool1.ssl = false

## SSL 密钥文件路径

## backend.mongo.pool1.keyfile =

## SSL 证书文件路径

## backend.mongo.pool1.certfile =

## SSL CA 证书文件路径

## backend.mongo.pool1.cacertfile =

## MongoDB 数据写入模式: unsafe | safe

## backend.mongo.pool1.w_mode = safe

## MongoDB 数据读取模式: master | slaver_ok

## backend.mongo.pool1.r_mode = slave_ok

## MongoDB 底层 driver 配置, 保持默认即可

## backend.mongo.topology.pool_size = 1

## backend.mongo.topology.max_overflow = 0

## backend.mongo.topology.overflow_ttl = 1000

## backend.mongo.topology.overflow_check_period = 1000

## backend.mongo.topology.local_threshold_ms = 1000

## backend.mongo.topology.connect_timeout_ms = 20000

## backend.mongo.topology.socket_timeout_ms = 100

## backend.mongo.topology.server_selection_timeout_ms = 30000

## backend.mongo.topology.wait_queue_timeout_ms = 1000

## backend.mongo.topology.heartbeat_frequency_ms = 10000

## backend.mongo.topology.min_heartbeat_frequency_ms = 1000

## MongoDB Backend Hooks

backend.mongo.hook.client.connected.1={"action":{"function":"on_client_connected"},"pool":"pool1"}

backend.mongo.hook.session.created.1={"action":{"function":"on_subscribe_lookup"},"pool":"pool1"}

backend.mongo.hook.client.disconnected.1={"action":{"function":"on_client_disconnected"},"pool":"pool1"}

backend.mongo.hook.session.subscribed.1={"topic":"#","action":{"function":"on_message_fetch"},"pool":"pool1","offline_opts":{"time_range":"2h","max_returned_count":500}}

backend.mongo.hook.session.subscribed.2={"topic":"#","action":{"function":"on_retain_lookup"},"pool":"pool1"}

backend.mongo.hook.session.unsubscribed.1={"topic":"#","action":{"function":"on_acked_delete"},"pool":"pool1"}

backend.mongo.hook.message.publish.1={"topic":"#","action":{"function":"on_message_publish"},"pool":"pool1"}

backend.mongo.hook.message.publish.2={"topic":"#","action":{"function":"on_message_retain"},"pool":"pool1"}

backend.mongo.hook.message.publish.3={"topic":"#","action":{"function":"on_retain_delete"},"pool":"pool1"}

backend.mongo.hook.message.acked.1={"topic":"#","action":{"function":"on_message_acked"},"pool":"pool1"}

## 获取离线消息

## "offline_opts": 获取离线消息的配置

## - max_returned_count: 单次拉去的最大离线消息数目

## - time_range: 仅拉去在当前时间范围的消息

## backend.mongo.hook.session.subscribed.1 = {"topic": "#", "action": {"function": "on_message_fetch"}, "pool": "pool1", "offline_opts": {"time_range": "2h", "max_returned_count": 500}}

## 如果需要存储 Qos0 消息, 可开启以下配置

## 警告: 当开启以下配置时, 需关闭 'on_message_fetch', 否则 qos1, qos2 消息会被存储俩次

## backend.mongo.hook.message.publish.4 = {"topic": "#", "action": {"function": "on_message_store"}, "pool": "pool1", "payload_format": "mongo_json"}

backend 消息存储规则包括:hooktopicaction说明client.connectedon_client_connected存储客户端在线状态

session.createdon_subscribe_lookup订阅主题

client.disconnectedon_client_disconnected存储客户端离线状态

session.subscribed#on_message_fetch获取离线消息

session.subscribed#on_retain_lookup获取retain消息

session.unsubscribed#on_acked_delete删除 acked 消息

message.publish#on_message_publish存储发布消息

message.publish#on_message_retain存储retain消息

message.publish#on_retain_delete删除retain消息

message.acked#on_message_acked消息ACK处理

MongoDB 数据库初始化usemqtt

db.createCollection("mqtt_client")

db.createCollection("mqtt_sub")

db.createCollection("mqtt_msg")

db.createCollection("mqtt_retain")

db.createCollection("mqtt_acked")

db.mqtt_client.ensureIndex({clientid:1,node:2})

db.mqtt_sub.ensureIndex({clientid:1})

db.mqtt_msg.ensureIndex({sender:1,topic:2})

db.mqtt_retain.ensureIndex({topic:1})

Tip

数据库名称可自定义

MongoDB 用户状态集合(Client Collection)

mqtt_client 存储设备在线状态:{

clientid:string,

state:0,1,//0离线 1在线

node:string,

online_at:timestamp,

offline_at:timestamp

}

查询设备在线状态:db.mqtt_client.findOne({clientid:${clientid}})

例如 ClientId 为 test 客户端上线:db.mqtt_client.findOne({clientid:"test"})

{

"_id":ObjectId("58646c9bdde89a9fb9f7fb73"),

"clientid":"test",

"state":1,

"node":"emqx@127.0.0.1",

"online_at":1482976411,

"offline_at":null

}

例如 ClientId 为 test 客户端下线:db.mqtt_client.findOne({clientid:"test"})

{

"_id":ObjectId("58646c9bdde89a9fb9f7fb73"),

"clientid":"test",

"state":0,

"node":"emqx@127.0.0.1",

"online_at":1482976411,

"offline_at":1482976501

}

MongoDB 用户订阅主题集合(Subscription Collection)

mqtt_sub 存储订阅关系:{

clientid:string,

topic:string,

qos:0,1,2

}

用户 test 分别订阅主题 test_topic0 test_topic1 test_topic2:db.mqtt_sub.insert({clientid:"test",topic:"test_topic1",qos:1})

db.mqtt_sub.insert({clientid:"test",topic:"test_topic2",qos:2})

某个客户端订阅主题:db.mqtt_sub.find({clientid:${clientid}})

查询 ClientId 为 “test” 的客户端已订阅主题:db.mqtt_sub.find({clientid:"test"})

{"_id":ObjectId("58646d90c65dff6ac9668ca1"),"clientid":"test","topic":"test_topic1","qos":1}

{"_id":ObjectId("58646d96c65dff6ac9668ca2"),"clientid":"test","topic":"test_topic2","qos":2}

MongoDB 发布消息集合(Message Collection)

mqtt_msg 存储 MQTT 消息:{

_id:int,

topic:string,

msgid:string,

sender:string,

qos:0,1,2,

retain:boolean(true,false),

payload:string,

arrived:timestamp

}

查询某个客户端发布的消息:db.mqtt_msg.find({sender:${clientid}})

查询 ClientId 为 “test” 的客户端发布的消息:db.mqtt_msg.find({sender:"test"})

{

"_id":1,

"topic":"/World",

"msgid":"AAVEwm0la4RufgAABeIAAQ==",

"sender":"test",

"qos":1,

"retain":1,

"payload":"Hello world!",

"arrived":1482976729

}

MongoDB 保留消息集合(Retain Message Collection)

mqtt_retain 存储 Retain 消息:{

topic:string,

msgid:string,

sender:string,

qos:0,1,2,

payload:string,

arrived:timestamp

}

查询 retain 消息:db.mqtt_retain.findOne({topic:${topic}})

查询topic为 “t/retain” 的 retain 消息:db.mqtt_retain.findOne({topic:"t/retain"})

{

"_id":ObjectId("58646dd9dde89a9fb9f7fb75"),

"topic":"t/retain",

"msgid":"AAVEwm0la4RufgAABeIAAQ==",

"sender":"c1",

"qos":1,

"payload":"Hello world!",

"arrived":1482976729

}

MongoDB 接收消息 ack 集合(Message Acked Collection)

mqtt_acked 存储客户端消息确认:{

clientid:string,

topic:string,

mongo_id:int

}

启用 MongoDB 数据存储插件./bin/emqx_ctl plugins load emqx_backend_mongo