<div dir="ltr">Short answer, yes.<div><br></div><div>I've used Opensips in a MySQL Cluster environment for years with much success. I did have to modify the table creation scripts to change the type from MyISAM to NDB where appropriate.</div><div><br></div><div><br></div><div>- Jeff</div><div><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Jul 30, 2015 at 9:15 AM, Victor Medina <span dir="ltr"><<a href="mailto:victor.medina@cibersys.com" target="_blank">victor.medina@cibersys.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div style="font-family:courier new,monospace">Thanks Rik!<br></div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">2015-07-30 8:10 GMT-04:30 Rik Broers <span dir="ltr"><<a href="mailto:RBroers@motto.nl" target="_blank">RBroers@motto.nl</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="NL">
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" lang="EN-US">Mysql cluster is very different from the galera solution.
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" lang="EN-US">Mariadb offers a complete galera cluster package from their repo’s, and as mariadb is going to be the default in Ubuntu
we went for that </span><span style="font-size:11.0pt;font-family:Wingdings;color:#1f497d" lang="EN-US">J</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" lang="EN-US"><u></u><u></u></span></p><span>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt;line-height:12.75pt"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Met vriendelijke groet,<br>
<br>
</span><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#84c41b">Rik Broers</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><br>
</span><span style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#212735">Voice Engineer</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><br>
<br>
</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u><u></u></span></p>
</span><p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Van:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <a href="mailto:users-bounces@lists.opensips.org" target="_blank">users-bounces@lists.opensips.org</a> [mailto:<a href="mailto:users-bounces@lists.opensips.org" target="_blank">users-bounces@lists.opensips.org</a>]
<b>Namens </b>Victor Medina<br>
<b>Verzonden:</b> donderdag 30 juli 2015 14:13<span><br>
<b>Aan:</b> OpenSIPS users mailling list <<a href="mailto:users@lists.opensips.org" target="_blank">users@lists.opensips.org</a>><br>
</span><b>Onderwerp:</b> Re: [OpenSIPS-Users] OpenSIPS Data Base tables in a MySQL Cluster<u></u><u></u></span></p><div><div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-family:"Courier New"">I saw the sql files and noted that they are all MyISAM. Ill guess I will try MySQL Cluster and Galera.<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-family:"Courier New"">Any reason for going with maria db? Just your choice?<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Thanks!<u></u><u></u></span></p>
</div>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">2015-07-30 3:37 GMT-04:30 Rik Broers <<a href="mailto:RBroers@motto.nl" target="_blank">RBroers@motto.nl</a>>:<u></u><u></u></p>
<blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" lang="EN-US">I have it in a Mariadb Galera Cluster, so yeah it works.</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" lang="EN-US">Make sure your DB-cluster solution is compatible with MyISAM as all sql files default
to that. (galera isn’t by default compatible with MyISAM)</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" lang="EN-US">I had to change everything over to InnoDB to get it working well.</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-bottom:12.0pt;line-height:12.75pt">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Met vriendelijke groet,<br>
<br>
</span><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#84c41b">Rik Broers</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><br>
</span><span style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#212735">Voice Engineer</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><br>
<br>
</span><u></u><u></u></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" lang="EN-US">Van:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" lang="EN-US">
<a href="mailto:users-bounces@lists.opensips.org" target="_blank">users-bounces@lists.opensips.org</a> [mailto:<a href="mailto:users-bounces@lists.opensips.org" target="_blank">users-bounces@lists.opensips.org</a>]
<b>Namens </b>Victor Medina<br>
<b>Verzonden:</b> donderdag 30 juli 2015 1:05<br>
<b>Aan:</b> OpenSIPS users mailling list <<a href="mailto:users@lists.opensips.org" target="_blank">users@lists.opensips.org</a>><br>
<b>Onderwerp:</b> [OpenSIPS-Users] OpenSIPS Data Base tables in a MySQL Cluster</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-family:"Courier New"">hi guys!</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">is it possible to load opensips tables in a mysql cluster? Has anybody tried? Any ideas?<br clear="all">
</span><u></u><u></u></p>
</div>
<p class="MsoNormal"><br>
-- <u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""><br>
<img src="https://www.cibersys.com/img/logo-cibersys.png" border="0"><br>
<br>
Víctor E. Medina M.</span><u></u><u></u></p>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">Platform Architect / Chief Infrastructure</span><u></u><u></u></p>
</div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""><a href="tel:%2B58424%20291%204561" target="_blank">+58424 291 4561</a><br>
BB #79A8AFA2<br>
@VMCibersys</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><u></u><u></u></p>
</blockquote>
</div>
<p class="MsoNormal"><br>
<br clear="all">
<br>
-- <u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""><br>
<img src="https://www.cibersys.com/img/logo-cibersys.png" border="0"><br>
<br>
Víctor E. Medina M.</span><u></u><u></u></p>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">Platform Architect / Chief Infrastructure</span><u></u><u></u></p>
</div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""><a href="tel:%2B58424%20291%204561" value="+584242914561" target="_blank">+58424 291 4561</a><br>
BB #79A8AFA2<br>
@VMCibersys</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div></div></div>
</div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><font size="2"><span style="font-family:courier new,monospace"><br><img src="https://www.cibersys.com/img/logo-cibersys.png"><br><br>Víctor E. Medina M.<br></span></font><div><font size="2"><span style="font-family:courier new,monospace">Platform Architect / Chief Infrastructure<br></span></font></div><font size="2"><span style="font-family:courier new,monospace"><span style="display:inline"><span style="display:inline"><a>+58424 291 4561</a></span></span><br>BB #79A8AFA2<br>@VMCibersys<br></span></font></div><div dir="ltr"><font size="2"><span style="font-family:courier new,monospace"><br></span></font></div></div></div></div></div></div></div></div></div></div>
</div>
</div></div><br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div></div>