We are using keepalived with virtual IP Address for Kamailio, dispatcher module for Asterisk, 2 MySQL Databases master-master replicated and 2 Servers with ProxySQL. So far so good.
Hello,
thanks for sharing!
Is ProxySQL making any difference using it instead of direct connection to MySQL? Curious mainly if you use it for caching capabilities, or just routing sql...
Cheers, Daniel
On 29.10.19 22:34, Ilie Soltanici wrote:
We are using keepalived with virtual IP Address for Kamailio, dispatcher module for Asterisk, 2 MySQL Databases master-master replicated and 2 Servers with ProxySQL. So far so good.
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Well... For Kamailio, at the moment ProxySQL is mainly used for routing and statistic. For Asterisk, we also use a little caching. For other services, ProxySQL is also used as a "Gateway", because our DB Servers are working in a separate Network. Before we were using db_cluster module from Kamailio, it works fine, but because anyway was implemented ProxySQL for other Services, was decided to move Kamailio through it too.
În mie., 30 oct. 2019 la 07:44, Daniel-Constantin Mierla miconda@gmail.com a scris:
Hello,
thanks for sharing!
Is ProxySQL making any difference using it instead of direct connection to MySQL? Curious mainly if you use it for caching capabilities, or just routing sql...
Cheers, Daniel On 29.10.19 22:34, Ilie Soltanici wrote:
We are using keepalived with virtual IP Address for Kamailio, dispatcher module for Asterisk, 2 MySQL Databases master-master replicated and 2 Servers with ProxySQL. So far so good.
Kamailio (SER) - Users Mailing Listsr-users@lists.kamailio.orghttps://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
-- Daniel-Constantin Mierla -- www.asipto.comwww.twitter.com/miconda -- www.linkedin.com/in/miconda Kamailio Advanced Training, Oct 21-23, 2019, Berlin, Germany -- https://asipto.com/u/kat
OK, thanks for all these details!
Cheers, Daniel
On 30.10.19 22:03, Ilie Soltanici wrote:
Well... For Kamailio, at the moment ProxySQL is mainly used for routing and statistic. For Asterisk, we also use a little caching. For other services, ProxySQL is also used as a "Gateway", because our DB Servers are working in a separate Network. Before we were using db_cluster module from Kamailio, it works fine, but because anyway was implemented ProxySQL for other Services, was decided to move Kamailio through it too.
În mie., 30 oct. 2019 la 07:44, Daniel-Constantin Mierla <miconda@gmail.com mailto:miconda@gmail.com> a scris:
Hello, thanks for sharing! Is ProxySQL making any difference using it instead of direct connection to MySQL? Curious mainly if you use it for caching capabilities, or just routing sql... Cheers, Daniel On 29.10.19 22:34, Ilie Soltanici wrote:We are using keepalived with virtual IP Address for Kamailio, dispatcher module for Asterisk, 2 MySQL Databases master-master replicated and 2 Servers with ProxySQL. So far so good. _______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org <mailto:sr-users@lists.kamailio.org> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users-- Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com> www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda> Kamailio Advanced Training, Oct 21-23, 2019, Berlin, Germany -- https://asipto.com/u/kat
-
Daniel-Constantin Mierla -
Ilie Soltanici