[OpenSIPS-Users] OpenSIPS Data Base tables in a MySQL Cluster

[Jeff Pyle]

Short answer, yes.

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.


- Jeff


On Thu, Jul 30, 2015 at 9:15 AM, Victor Medina <victor.medina at cibersys.com>
wrote:

> Thanks Rik!
>
> 2015-07-30 8:10 GMT-04:30 Rik Broers <RBroers at motto.nl>:
>
>> Mysql cluster is very different from the galera solution.
>>
>>
>>
>> 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 J
>>
>>
>>
>> Met vriendelijke groet,
>>
>> *Rik Broers*
>> Voice Engineer
>>
>> *Van:* users-bounces at lists.opensips.org [mailto:
>> users-bounces at lists.opensips.org] *Namens *Victor Medina
>> *Verzonden:* donderdag 30 juli 2015 14:13
>> *Aan:* OpenSIPS users mailling list <users at lists.opensips.org>
>> *Onderwerp:* Re: [OpenSIPS-Users] OpenSIPS Data Base tables in a MySQL
>> Cluster
>>
>>
>>
>> I saw the sql files and noted that they are all MyISAM. Ill guess I will
>> try MySQL Cluster and Galera.
>>
>> Any reason for going with maria db? Just your choice?
>>
>> Thanks!
>>
>>
>>
>> 2015-07-30 3:37 GMT-04:30 Rik Broers <RBroers at motto.nl>:
>>
>> I have it in a Mariadb Galera Cluster, so yeah it works.
>>
>> 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)
>>
>>
>>
>> I had to change everything over to InnoDB to get it working well.
>>
>>
>>
>> Met vriendelijke groet,
>>
>> *Rik Broers*
>> Voice Engineer
>>
>> *Van:* users-bounces at lists.opensips.org [mailto:
>> users-bounces at lists.opensips.org] *Namens *Victor Medina
>> *Verzonden:* donderdag 30 juli 2015 1:05
>> *Aan:* OpenSIPS users mailling list <users at lists.opensips.org>
>> *Onderwerp:* [OpenSIPS-Users] OpenSIPS Data Base tables in a MySQL
>> Cluster
>>
>>
>>
>> hi guys!
>>
>> is it possible to load opensips tables in a mysql cluster? Has anybody
>> tried? Any ideas?
>>
>>
>> --
>>
>>
>>
>>
>> Víctor E. Medina M.
>>
>> Platform Architect / Chief Infrastructure
>>
>> +58424 291 4561
>> BB #79A8AFA2
>> @VMCibersys
>>
>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>>
>>
>> --
>>
>>
>>
>>
>> Víctor E. Medina M.
>>
>> Platform Architect / Chief Infrastructure
>>
>> +58424 291 4561
>> BB #79A8AFA2
>> @VMCibersys
>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>
>
> --
>
>
>
> Víctor E. Medina M.
> Platform Architect / Chief Infrastructure
> +58424 291 4561
> BB #79A8AFA2
> @VMCibersys
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20150731/8f1a5d18/attachment-0001.htm>