<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi, <br>
<br>
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.<br>
<br>
Most probably we will switch to InnoDB as default engine type.<br>
<br>
Regards,<br>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<div class="moz-cite-prefix">On 30.07.2015 17:57, Kneeoh wrote:<br>
</div>
<blockquote
cite="mid:1079722522.6458049.1438268275879.JavaMail.yahoo@mail.yahoo.com"
type="cite">
<div style="color:#000; background-color:#fff;
font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial,
Lucida Grande, sans-serif;font-size:16px">
<div dir="ltr" id="yui_3_16_0_1_1438268013085_8479">
<span class="" id="yui_3_16_0_1_1438268013085_8526"
style="font-family:'Helvetica Neue';font-size:14px;">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:<br>
</span></div>
<div id="yui_3_16_0_1_1438268013085_8667" dir="ltr"><span
class="" id="yui_3_16_0_1_1438268013085_8526"
style="font-family:'Helvetica Neue';font-size:14px;">sed -i
's/MyISAM/InnoDB/g' *</span></div>
<div id="yui_3_16_0_1_1438268013085_8668" dir="ltr"><br>
<span class="" id="yui_3_16_0_1_1438268013085_8526"
style="font-family:'Helvetica Neue';font-size:14px;"></span></div>
<div id="yui_3_16_0_1_1438268013085_8691" dir="ltr"><span
class="" id="yui_3_16_0_1_1438268013085_8526"
style="font-family:'Helvetica Neue';font-size:14px;">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.<br>
</span></div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>