Mnesia vs MySQL

[Michael McDaniel]

I use MySQL (via ODBC) right now for an erlang application.

I have thought of using Mnesia as the immediate data sink, and then
have it flush out to MySQL.  The reason for this would be so that I
can replicate the incoming data across other nodes without having to
use MySQL replication.  MySQL would still be used for the permanent
data store so that other (non-erlang) applications can easily access
the data.


~Michael


On Wed, Aug 10, 2005 at 03:07:41PM +0200, Ulf Wiger (AL/EAB) wrote:
> 
>    Mnesia is different from MySQL in several ways. Whether or not the
>    differences are in Mnesia's favour certainly depends on what you need
>    to do:
> 
>    - No semantic gap for erlang programmers. Mnesia operates directly on
>    Erlang terms
> 
>      and uses Erlang semantics for accesses
> 
>    - Low latency. E.g. dirty_read from a mnesia table takes only a few
>    microseconds. There is no way you
> 
>      can read a MySQL object as quickly. This assumes that your
>    application is written in erlang, of course.
> 
>    - In-service upgrade. Mnesia can be upgraded without service
>    interruption.
> 
>    - Small memory footprint (not that I know how much MySQL uses)
> 
>    There are certainly other differences. I'll let someone else continue.
> 
>    /Uffe
> 
>    -----Original Message-----
>    From: owner-erlang-questions@REDACTED
>    [mailto:owner-erlang-questions@REDACTED]On Behalf Of Inswitch
>    Solutions
>    Sent: den 10 augusti 2005 14:56
>    To: erlang-questions@REDACTED
>    Subject: Mnesia vs MySQL
> 
>    Hi,
> 
> 
> 
>    MySql database has been improved a lot and we are evaluating it using
>    ODBC Erlang application.
> 
>    As far as I know MySql has all mnesia features (replicas,
>    distribution, ..), plus GUI administration and SQL.
> 
> 
> 
>    What points in favour does Mnesia database have over MySQL?
>    Perfomarnce issues?
> 
> 
> 
> 
> 
>    thanks, Eduardo
> 
> 
> 
> 
> 
>    [cid:562555912@REDACTED]
> 
>    Prepaid Expertise - Programmable Switches
>    Powered by Ericsson Licensed Technology
>    Eng. Eduardo Figoli - Development Center - IN Switch Solutions Inc.
>    Headquarters - Miami-U.S.A. Tel: 1305-3578076 Fax: 1305-7686260
>    Development Center - Montevideo - Uruguay Tel/Fax: 5982-7104457
>    e-mail: [1]eduardo@REDACTED
>    
> 
> References
> 
>    1. mailto:eduardo@REDACTED