[ejabberd] mnesia vs MySQL

mark peleus mark.peleus at gmail.com
Sat May 24 01:32:18 MSD 2008


In our case the roster will be of 20 users so I guess we can support more
then 10K users.

That is a valuable information.

I appreciate it.

On Fri, May 23, 2008 at 2:29 PM, anders conbere <aconbere at gmail.com> wrote:

> On Fri, May 23, 2008 at 2:24 PM, mark peleus <mark.peleus at gmail.com>
> wrote:
> > How can you tell that the database is thrashing to your disks?
>
> We were monitoring disk use on the server (to be fair we were
> monitoring all server resources, but the disks were the bottle neck)
>
> >
> > How many users did cause the problem and how big was the roster?
>
> aprox: 10k users, with 200 roster items in each roster
>
> >
> > Do you know if it is easier to cluster with mnesia compared to mysql?
>
> I don't, that's something I'm sure we'll be getting to soon as well.
>
> ~ Anders
>
> >
> > Thanks
> >
> > On Fri, May 23, 2008 at 9:46 AM, anders conbere <aconbere at gmail.com>
> wrote:
> >>
> >> On Fri, May 23, 2008 at 9:36 AM, mark peleus <mark.peleus at gmail.com>
> >> wrote:
> >> > Hi,
> >> >
> >> > I've read how to work with ejabberd and  mnesia or MySQL but it is not
> >> > clear
> >> > to me which one is better and for what purpose.
> >> >
> >> > Can you please tell me which one:
> >> >
> >> > - have better performance
> >> > - easier to cluster
> >> > - works better with large amount of registered users
> >>
> >> In our tests with large numbers of users, with large rosters, mnesia
> >> started thrashing our disks. This was mitigated by moving to MySQL.
> >> That being said... we're not Mnesia engineers and could be doing
> >> something wrong.
> >>
> >> ~ Anders
> >>
> >> > - easier to manage. I use phpmyadmin for mysql. Is there an
> >> > administration
> >> > tool for mnesia?
> >> >
> >> > Thanks.
> >> >
> >> > _______________________________________________
> >> > ejabberd mailing list
> >> > ejabberd at jabber.ru
> >> > http://lists.jabber.ru/mailman/listinfo/ejabberd
> >> >
> >> >
> >> _______________________________________________
> >> ejabberd mailing list
> >> ejabberd at jabber.ru
> >> http://lists.jabber.ru/mailman/listinfo/ejabberd
> >
> >
> > _______________________________________________
> > ejabberd mailing list
> > ejabberd at jabber.ru
> > http://lists.jabber.ru/mailman/listinfo/ejabberd
> >
> >
> _______________________________________________
> ejabberd mailing list
> ejabberd at jabber.ru
> http://lists.jabber.ru/mailman/listinfo/ejabberd
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jabber.ru/pipermail/ejabberd/attachments/20080523/7bd2c1b6/attachment.htm 


More information about the ejabberd mailing list