[OpenSER-Users] Openser DB with Mysql-cluster

[Sasa Coh]

Hi!

If you use openser_mysql script (version 1.2.x)

1) create a resource file /etc/openser/.opensermysqlrc and enter the
following line:
TABLE_TYPE="ENGINE=NDBCLUSTER"

2) run the script (don't forget to backup data): openser_mysql create or
openser_mysql reinit,...
The script (deletes and) creates all openser tables with table_type =
ndbcluster

Regards,
Sasa


On Mon, Mar 10, 2008 at 10:34 AM, samuel <samu60 at gmail.com> wrote:

> MySQL has several storage engines where info is kept and if you want to
> implement MySQL cluster you MUST use the dedicated storage engine that
> provides de HA solution, ndbcluster.
>
> If you have the cluster setup, you could try to use ALTER commands but
> it's not recommended...It's better you change the engine parameter in the
> MySQL creation scripts to use the MySQL cluster features.
>
> Hope it helps,
> Samuel.
>
>
> 2008/3/10, Antonio Reale <ant.reale at gmail.com>:
> >
> > 2008/3/6, Henning Westerholt <henning.westerholt at 1und1.de>:
> > >
> > >
> > > i think that you can't use MyISAM if you want to use MySQL cluster.
> > > But for
> > > information about setting this you should consult the MySQL
> > > documentation,
> > > there is also a cluster FAQ available.
> >
> >
> > Probably I can use MyISAM, but tables using this engine are not
> > clustered.
> > Thanks.
> >
> > Regards,
> > Antonio.
> >
> > _______________________________________________
> > Users mailing list
> > Users at lists.openser.org
> > http://lists.openser.org/cgi-bin/mailman/listinfo/users
> >
> >
>
> _______________________________________________
> Users mailing list
> Users at lists.openser.org
> http://lists.openser.org/cgi-bin/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20080310/76247d97/attachment.htm>