[OpenSER-Users] MyISAM or InnoDB in MySQL tables?

[Joseph Bajin]

On Nov 13, 2007 12:13 PM, Iñaki Baz Castillo <ibc at in.ilimit.es> wrote:

> Hi, MySQL tables of OpenSer created by the script are "MyISAM". Is there
> any
> reason for that instead of using InnoDB?
>
> As I know:
>
> MyISAM:
> - Is faster reading and writting (except writting various entries to same
> table since it blocks the entire table).
> - No transactions or rollbacks.
> - Small disc space requeriments.
>
> InnoDB:
> - Transactions, rollbacks, restrictions in foreing keys.
> - Faster writting various entries in same table (entry lock instead of
> table
> lock).
> - More disc space and RAM requeriments.
>
>
> Yes, it can be obvious that for OpenSer the engine MyISAM can be a good
> choice
> but I would like to know if there is more data for this choice.
>
> Regards.
>
>
> --
> Iñaki Baz Castillo
> ibc at in.ilimit.es
>
> _______________________________________________
> Users mailing list
> Users at lists.openser.org
> http://lists.openser.org/cgi-bin/mailman/listinfo/users
>

Depending on how much data you have, you should also look at mysql Cluster.
Since it is an in memory database, it will be super fast.

I have used SER with Mysql Cluster and it works well.

Joe
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20071114/624db5c7/attachment.htm>