[erlang-questions] MySQl vs. mnesia

Heinrich Venter heinrich@REDACTED
Mon Aug 6 09:51:17 CEST 2007


We have been using MySQL and Mnesia in production environments for a while
now.
The answer is that both have a place.  
MySQL has the advantage of interoperability and the SQL language that is
known and used by third party tools.
Mnesia has the advantage of being fast, distributed and embedded in Erlang.

Our rules of thumb are:
If it is data that is mostly read at runtime use mnesia (like configs and
internal queues).
If it is large volumes of data that needs to be reported on, use MySQL.
Mnesia == runtime data
MySQL == archived data

-]-[




More information about the erlang-questions mailing list