Approaches to PubSub Item Message Storage

Openfire Openfire Support
1

Hi All,

I know in the db table ofpubsubitem that the last item send to a specific pubsub node is stored. But what I want is to store every message that is sent to a pubsub node. Im not sure if anyone has done this specifically but would setting up a trigger on that table to add every new item insert into another table that stores every item published work ok?

Im just a little jumpy because potentially a high volume of messages will be transfered to each pubsub node.

Thanks

Mike

2

You don’t have to do anything to the db. This is actually a configuration option on the node. I don’t know what API you are using to create or manage the node, but you simply set pubsub#persist_items field to true. You can also set the maximum number of items that will be persisted if this helps with your volume issues.