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
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Reply via email to