[SR-Users] how you make Kamailio with mariadb

[Rainer Piper]

You should take a look at the mariaDB Galera Cluster for
Master-Master-Master... as many as you like DB-Nodes.

You can run a mariaDB Galera Cluster with 2x Nodes and add Nodes on the 
fly if you need more DB-Performance.

and the kamailio module db_cluster
http://kamailio.org/docs/modules/4.2.x/modules/db_cluster.html

Regards
Rainer


Am 05.11.2014 um 14:33 schrieb ANTHONY HESNAUX:
> Hi Rainer,
> I test this configuration:
>
> All host with CENTOS 7 and MARIADB
>
> - 1 host -> Proxy SIP KAMAILIO with mariadb for load balancing front 
> end 2 host asterisk
>
> - 2 hosts -> provisioning with mariadb with MASTER-MASTER replication
> - 2 hosts -> Asterisk realtime with Mariadb and replicate 
> configuration Slave to provisionning hosts
>
> Regards
>
> Anthony
>
>
>> Le 5 nov. 2014 à 14:21, Rainer Piper <rainer.piper at soho-piper.de 
>> <mailto:rainer.piper at soho-piper.de>> a écrit :
>>
>> Hi Anthony,
>>
>> are you planing to run a mariaDB Multimaster Galera Cluster?
>>
>> Regards
>> Rainer
>>
>>
>> Am 05.11.2014 um 14:04 schrieb ANTHONY HESNAUX:
>>> Ok thank you I find my problem I forgot one dependance mariadb-devel 
>>> and mariadb (complete functions)
>>> thank you for the kamailio 4.2.0 no problem with sql script
>>>
>>> Regards
>>> Anthony HSNAUX
>>>
>>>
>>>> Le 5 nov. 2014 à 13:47, Rainer Piper <rainer.piper at soho-piper.de 
>>>> <mailto:rainer.piper at soho-piper.de>> a écrit :
>>>>
>>>> Hi all,
>>>>
>>>> I can confirm that db_mysql is compatible to mariaDB.
>>>>
>>>> I'm running Debian 7 + Kamailio 4.1.6  + mariaDB 10.0.13 Galera 
>>>> DB-Cluster on 12x Nodes.
>>>>
>>>> Regards
>>>> Rainer
>>>>
>>>>
>>>>
>>>> Am 05.11.2014 um 13:24 schrieb Daniel-Constantin Mierla:
>>>>> Hello,
>>>>>
>>>>> 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.
>>>>>
>>>>> If you get troubles connecting with db_mysql to mariadb server, 
>>>>> send here the logs with debug=3 in kamailio.cfg
>>>>>
>>>>> Cheers,
>>>>> Daniel
>>>>>
>>>>> On 05/11/14 13:10, ANTHONY HESNAUX wrote:
>>>>>> hello Daniel
>>>>>> I want to install Kamailio with mariadb on CENTOS 7
>>>>>> I already install Kamailio on CENTOS 6.5 without error
>>>>>> but on CENTOS 7 with mariadb, What modules do you include for 
>>>>>> make cfg:
>>>>>>
>>>>>>
>>>>>> make include_modules="db_mysql" cfg
>>>>>>
>>>>>> thank you
>>>>>>
>>>>>> best regard
>>>>>>
>>>>>> Anthony HESNAUX
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>>>>>> sr-users at lists.sip-router.org
>>>>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>>>>
>>>>> -- 
>>>>> Daniel-Constantin Mierla
>>>>> http://twitter.com/#!/miconda  -http://www.linkedin.com/in/miconda
>>>>> Kamailio Advanced Training, Nov 24-27, Berlin -http://www.asipto.com
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>>>>> sr-users at lists.sip-router.org
>>>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>>>
>>>>
>>>> -- 
>>>> *Rainer Piper*
>>>> Integration engineer
>>>> Koeslinstr. 56
>>>> 53123 BONN
>>>> GERMANY
>>>> Phone: +49 228 97167161
>>>> P2P: sip:rainer at sip.soho-piper.de:5072 (pjsip-test)
>>>> XMPP: rainer at xmpp.soho-piper.de
>>>> _______________________________________________
>>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>>>> sr-users at lists.sip-router.org <mailto:sr-users at lists.sip-router.org>
>>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>>
>>>
>>>
>>> _______________________________________________
>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>>> sr-users at lists.sip-router.org
>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>
>>
>> -- 
>> *Rainer Piper*
>> Integration engineer
>> Koeslinstr. 56
>> 53123 BONN
>> GERMANY
>> Phone: +49 228 97167161
>> P2P: sip:rainer at sip.soho-piper.de:5072 (pjsip-test)
>> XMPP: rainer at xmpp.soho-piper.de
>> _______________________________________________
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>> sr-users at lists.sip-router.org <mailto:sr-users at lists.sip-router.org>
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


-- 
*Rainer Piper*
Integration engineer
Koeslinstr. 56
53123 BONN
GERMANY
Phone: +49 228 97167161
P2P: sip:rainer at sip.soho-piper.de:5072 (pjsip-test)
XMPP: rainer at xmpp.soho-piper.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20141105/ad043d74/attachment.html>