With Mnesia don't worry about DB

mfoss — Thu, 24 Dec 2009 19:13:31 +0000

Quote:

We would need to serve several virtual domains, but each with only few accounts.

Serving serveral vhosts with ejabberd isn't a problem, as long as you don't mean thousands of vhosts :)

Quote:

All I found here in the forum is that I would need one database for each (virtual) domain.
Is that correct so far or

ejabberd uses by default the internal database Mnesia. Optionally, you can use MySQL, PgSQL, ... databases to store some of the content (authentication, rosters, vcards, pubsub...).

If you use the default Mnesia, you don't need to worry about DB configuration at all.

If you run a large server with many many accounts, big rosters, ... then you better use some SQL database instead of Mnesia. And it's in that case when you also have to use a different database for each vhost.

Quote:

is there any chance to concentrate those virtual domains in one database?

Not implemented in ejabberd. You can look at this recently proposed patch:
https://support.process-one.net/browse/EJAB-1131

Quote:

Furthermore, is there a posibility to prefix the database-tables to include them into our main services-configuration-database?

No: neither implemented in ejabberd, and not patch that I know.

ejabberd - Comments for "serving numbers of virtual domains"

With Mnesia don't worry about DB