[Spce-user] Mysql and Redis db location in CE

[Barry Flanagan]

On 24 October 2017 at 13:04, Jon Bonilla (Manwe) <manwe at sipdoc.net> wrote:

> El Tue, 24 Oct 2017 12:21:06 +0100
> Barry Flanagan <barry at flanagan.ie> escribió:
> > >
> > >
> > haproxy running on the SPCE node might work well here. Leave SPCE
> pointing
> > to localhost, and haproxy proxying to the actual mysql and redis hosts.
> > Added benefit of load balancing and/or failover as well.
> >
> >
>
> It's a good idea. That would also work with some tools not ready for
> foreign db host inside de spce server.
>
>
Yes. I can attest that it is very reliable. I run a local haproxy
(supervised by monit) on all servers which need database access - no
application connects directly. No issues encountered in over 4 years.

-Barry
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20171024/c5e3fbf8/attachment-0001.html>