[OpenSIPS-Users] OpenSIPS Data Base tables in a MySQL Cluster

Bogdan-Andrei Iancu bogdan at opensips.org
Tue Aug 4 14:32:37 CEST 2015


Hi,

The easiest way to change the engine for all the tables is by changing 
the MYSQL_TABLE_TYPE in db/schema/entities.xml and to run "make 
dbschema" to re-generate the SQL files again.

Most probably we will switch to InnoDB as default engine type.

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 30.07.2015 17:57, Kneeoh wrote:
> Victor, you'll need to change all of the opensips tables to InnoDB 
> (not sure why they're not that way by default) in order for it to be 
> compatible with galera. I do this before installing the DB by cd'ing 
> to the /usr/local/share/opensips/mysql dir and running the following 
> command:
> sed -i 's/MyISAM/InnoDB/g' *
>
> Once done proceed with installing the DB to your galera cluster. 
> Galera and MariaDB works great and has saved my tail several times. 
> Make sure you always have an ODD number of nodes in the cluster to 
> avoid split brain conflicts.
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20150804/85cf1b1d/attachment.htm>


More information about the Users mailing list