mnesia vs. MySQL

After living with Ejabberd in development for a few months and coming to the point of clustering, I've come to some realizations.

I wonder if some more experienced Ejabberd folks could verify my thoughts or offer some advice.

Ejabberd is built for mnesia. (I know, captain obvious).
It will work with MySQL but I get the impression across many posts and opinions that the core Ejabberd/Erlang people think this is a silly idea because mnesia is a purpose built database for just this kind of function.

So, I'm considering switching it all over to mnesia.
1. I'm going to test this but... one of my problems is that mod_rest (sometimes with mod_admin_extra), for many calls, doesn't return errors or data or anything. Maybe switching to mnesia will be more friendly to this?
2. The mnesia database performs just fine and in some cases will perform better than MySQL. I may have made the incorrect assumption that MySQL is a more powerful database, especially in clustered form (which it turns out I can't use anyway). It's the mistake of preferring what I know to what may be the better solution.

Thanks.

Syndicate content