<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">You should take a look at the mariaDB
Galera Cluster for<br>
Master-Master-Master... as many as you like DB-Nodes.<br>
<span id="result_box" class="short_text" lang="en"><span
class="hps"><br>
You can run a mariaDB Galera Cluster with 2x Nodes and add
Nodes on the fly if you need more DB-Performance.<br>
<br>
</span></span>and the kamailio module db_cluster<br>
<a class="moz-txt-link-freetext" href="http://kamailio.org/docs/modules/4.2.x/modules/db_cluster.html">http://kamailio.org/docs/modules/4.2.x/modules/db_cluster.html</a><br>
<br>
Regards<br>
Rainer<br>
<br>
<br>
Am 05.11.2014 um 14:33 schrieb ANTHONY HESNAUX:<br>
</div>
<blockquote
cite="mid:26BECDEF-FA9B-4F25-8D43-77B95BAA02DF@gmail.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
Hi Rainer,
<div class="">I test this configuration:</div>
<div class=""><br class="">
</div>
<div class="">All host with CENTOS 7 and MARIADB</div>
<div class=""><br class="">
</div>
<div class="">- 1 host -> Proxy SIP KAMAILIO with mariadb for
load balancing front end 2 host asterisk</div>
<div class=""><br class="">
</div>
<div class="">- 2 hosts -> provisioning with mariadb with
MASTER-MASTER replication </div>
<div class=""> </div>
<div class="">- 2 hosts -> Asterisk realtime with Mariadb and
replicate configuration Slave to provisionning hosts</div>
<div class=""><br class="">
</div>
<div class="">Regards</div>
<div class=""><br class="">
</div>
<div class="">Anthony </div>
<div class=""><br class="">
</div>
<div class=""><br class="">
<div>
<blockquote type="cite" class="">
<div class="">Le 5 nov. 2014 à 14:21, Rainer Piper <<a
moz-do-not-send="true"
href="mailto:rainer.piper@soho-piper.de" class="">rainer.piper@soho-piper.de</a>>
a écrit :</div>
<br class="Apple-interchange-newline">
<div class="">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type" class="">
<div bgcolor="#FFFFFF" text="#000000" class="">
<div class="moz-cite-prefix">Hi Anthony,<br class="">
<br class="">
are you planing to run a mariaDB Multimaster Galera
Cluster?<br class="">
<br class="">
Regards <br class="">
Rainer<br class="">
<br class="">
<br class="">
Am 05.11.2014 um 14:04 schrieb ANTHONY HESNAUX:<br
class="">
</div>
<blockquote
cite="mid:808DDEFE-B5AA-4BF3-9F61-F626907E6746@gmail.com"
type="cite" class="">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252" class="">
Ok thank you I find my problem I forgot one dependance
mariadb-devel and mariadb (complete functions)
<div class="">thank you for the kamailio 4.2.0 no
problem with sql script </div>
<div class=""><br class="">
</div>
<div class="">Regards</div>
<div class="">Anthony HSNAUX</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
<div class="">
<blockquote type="cite" class="">
<div class="">Le 5 nov. 2014 à 13:47, Rainer
Piper <<a moz-do-not-send="true"
href="mailto:rainer.piper@soho-piper.de"
class="">rainer.piper@soho-piper.de</a>>
a écrit :</div>
<br class="Apple-interchange-newline">
<div class="">
<meta content="text/html;
charset=windows-1252"
http-equiv="Content-Type" class="">
<div bgcolor="#FFFFFF" text="#000000" class="">
<div class="moz-cite-prefix"><span
id="result_box" class="short_text"
lang="en"><span class="hps">Hi all,<br
class="">
<br class="">
I</span> <span class="hps">can</span>
<span class="hps">confirm </span></span>that
db_mysql is compatible to mariaDB.<br
class="">
<br class="">
I'm running Debian 7 + Kamailio 4.1.6 +
mariaDB 10.0.13 Galera DB-Cluster on 12x
Nodes.<br class="">
<br class="">
Regards<br class="">
Rainer<br class="">
<br class="">
<br class="">
<br class="">
Am 05.11.2014 um 13:24 schrieb
Daniel-Constantin Mierla:<br class="">
</div>
<blockquote
cite="mid:545A170A.808@gmail.com"
type="cite" class="">
<meta content="text/html;
charset=windows-1252"
http-equiv="Content-Type" class="">
Hello,<br class="">
<br class="">
I expect that db_mysql module can connect
and work with MariaDB out of the box --
afaik, the api is compatible between mysql
and mariadb.<br class="">
<br class="">
If you get troubles connecting with
db_mysql to mariadb server, send here the
logs with debug=3 in kamailio.cfg<br
class="">
<br class="">
Cheers,<br class="">
Daniel<br class="">
<br class="">
<div class="moz-cite-prefix">On 05/11/14
13:10, ANTHONY HESNAUX wrote:<br
class="">
</div>
<blockquote
cite="mid:E2C9D856-9C7D-42E4-BF1E-4389D6519E07@gmail.com"
type="cite" class="">
<meta http-equiv="Content-Type"
content="text/html;
charset=windows-1252" class="">
hello Daniel
<div class="">I want to install Kamailio
with mariadb on CENTOS 7 </div>
<div class="">I already install Kamailio
on CENTOS 6.5 without error </div>
<div class="">but on CENTOS 7 with
mariadb, What modules do you include
for make cfg:</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">
<pre class="code" style="margin-top: 0px; margin-bottom: 1.4em; padding: 0.7em 1em; font-family: Consolas, 'Andale Mono WT', 'Andale Mono', 'Bitstream Vera Sans Mono', 'Nimbus Mono L', Monaco, 'Courier New', monospace; font-size: 14px; direction: ltr; background-color: rgb(251, 250, 249); color: rgb(51, 51, 51); box-shadow: rgb(204, 204, 204) 0px 0px 0.5em inset; border-top-left-radius: 2px; border-top-right-radius: 2px; border-bottom-right-radius: 2px; border-bottom-left-radius: 2px; overflow: auto; word-wrap: normal; border: 1px solid rgb(204, 204, 204); line-height: 19px;">make include_modules="db_mysql" cfg</pre>
<div class=""><br class="">
</div>
</div>
<div class="">thank you </div>
<div class=""><br class="">
</div>
<div class="">best regard</div>
<div class=""><br class="">
</div>
<div class="">Anthony HESNAUX</div>
<br class="">
<fieldset class="mimeAttachmentHeader"></fieldset>
<br class="">
<pre class="" wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br class="">
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://twitter.com/#%21/miconda">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, Nov 24-27, Berlin - <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.asipto.com/">http://www.asipto.com</a></pre>
<br class="">
<fieldset class="mimeAttachmentHeader"></fieldset>
<br class="">
<pre class="" wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br class="">
<br class="">
<div class="moz-signature">-- <br class="">
<b class="">Rainer Piper</b> <br class="">
Integration engineer <br class="">
Koeslinstr. 56 <br class="">
53123 BONN <br class="">
GERMANY <br class="">
Phone: +49 228 97167161 <br class="">
P2P: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="sip:rainer@sip.soho-piper.de:5072">sip:rainer@sip.soho-piper.de:5072</a>
(pjsip-test) <br class="">
XMPP: <a moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:rainer@xmpp.soho-piper.de">rainer@xmpp.soho-piper.de</a></div>
</div>
_______________________________________________<br class="">
SIP Express Router (SER) and Kamailio
(OpenSER) - sr-users mailing list<br class="">
<a moz-do-not-send="true"
href="mailto:sr-users@lists.sip-router.org"
class="">sr-users@lists.sip-router.org</a><br
class="">
<a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br
class="">
</div>
</blockquote>
</div>
<br class="">
</div>
<br class="">
<fieldset class="mimeAttachmentHeader"></fieldset>
<br class="">
<pre class="" wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br class="">
<br class="">
<div class="moz-signature">-- <br class="">
<b class="">Rainer Piper</b> <br class="">
Integration engineer <br class="">
Koeslinstr. 56 <br class="">
53123 BONN <br class="">
GERMANY <br class="">
Phone: +49 228 97167161 <br class="">
P2P: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="sip:rainer@sip.soho-piper.de:5072">sip:rainer@sip.soho-piper.de:5072</a>
(pjsip-test) <br class="">
XMPP: <a moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:rainer@xmpp.soho-piper.de">rainer@xmpp.soho-piper.de</a></div>
</div>
_______________________________________________<br
class="">
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users
mailing list<br class="">
<a moz-do-not-send="true"
href="mailto:sr-users@lists.sip-router.org" class="">sr-users@lists.sip-router.org</a><br
class="">
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br
class="">
</div>
</blockquote>
</div>
<br class="">
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
<b>Rainer Piper</b>
<br>
Integration engineer
<br>
Koeslinstr. 56
<br>
53123 BONN <br>
GERMANY
<br>
Phone: +49 228 97167161
<br>
P2P: <a class="moz-txt-link-freetext" href="sip:rainer@sip.soho-piper.de:5072">sip:rainer@sip.soho-piper.de:5072</a> (pjsip-test)
<br>
XMPP: <a class="moz-txt-link-abbreviated" href="mailto:rainer@xmpp.soho-piper.de">rainer@xmpp.soho-piper.de</a></div>
</body>
</html>