Is there a document or a page that describes each of the tables ejabberd uses in the mnesia DB? I need a clear and concise page detailing each of the tables so I know which tables need to be fragmented (will grow larger than 4 GB, which tables can be lost with RAM only options set, and which must be copied to disk).
I'm looking at a rather large deployment (hopefully) with several million users and am looking to performance test clustering of ejabberd servers. I want information on the tables to know which mnesia settings to give each table and how to manage security. I plan on having one machine be behind a firewall as part of the cluster and will be the ONLY instance to have secretive information such as users and passwords.
Thank you,
Zach Calvert
In typical ejabberd servers
In typical ejabberd servers with typical instant messaging users, the larger mnesia tables (in size, not in number of elements) are (from larger to shorter): vcard, roster, offline_msg, pubsub_item, private_storage, last_activity, caps_features, ...
Which tables can be lost, and which not? it depends on your usage, but usually the default configuration used by ejabberd is the best one for common usage.
Thank you for the reply, but
Thank you for the reply, but I'm trying to figure out exactly which tables I need to be backing up. This is why I was curious if there is a full description of the tables documented somewhere. I can't seem to find docs on it though, so I'm going to try it through trial and error.
However, I do believe you are correct in that the default settings are probably appropriate for my usage.