Re: HAProxy proxying JDBC requests two a percona cluster

2014-10-23 Thread Dennis Plöger|getit GmbH
Hi! If it's not too much trouble maybe you could send a short message to haproxy list describing how you fixed the problem. This might help someone else who reads the list archives. Yes, Jarno. You're absolutely right. The main problem of this was the enormous default idle timeout of Hybris

Re: HAProxy proxying JDBC requests two a percona cluster

2014-10-17 Thread Jarno Huuskonen
Hi, On Wed, Oct 15, Dennis Plöger | getit GmbH wrote: Hi! Hmm... I just understood, that we're probably talking about different things here. As you can see in my configuration, I haven't specify a maxconn value. From the configuration documentation I didn't understand, what the default

Re: HAProxy proxying JDBC requests two a percona cluster

2014-10-17 Thread Dennis Plöger | getit GmbH
Hi! Maybe try with no option dontlognull ? Are all connections in logs logged with normal -- session state ? http://cbonte.github.io/haproxy-dconv/configuration-1.5.html#8.5 Oh. Thanks for mentioning that page (I somehow never got there). I now saw, that the connections are dropped with cD

Re: HAProxy proxying JDBC requests two a percona cluster

2014-10-17 Thread Dennis Plöger | getit GmbH
Hello! Oh. Thanks for mentioning that page (I somehow never got there). I now saw, that the connections are dropped with cD - meaning, that HAproxy thought, the server would be down. Getting back on that. I understand, that D means that HAProxy thinks, the server is down. Shouldn't hatop

Re: HAProxy proxying JDBC requests two a percona cluster

2014-10-15 Thread Dennis Plöger | getit GmbH
Hi! Thanks for answering. (You might consider running garbd arbitrator on a third server (or a third node), because if the two pxc nodes loose connection between each other - split brain and both nodes won't work

Re: HAProxy proxying JDBC requests two a percona cluster

2014-10-15 Thread Dennis Plöger | getit GmbH
Hi! Me again. Kinda (see my haproxy.cfg below). You're right. I will check out the logging options and optimize logging. I just checked the configuration options again and saw, that I'm already logging enough (I think). However, no errors are logged. What kind of server / client timeouts

Re: HAProxy proxying JDBC requests two a percona cluster

2014-10-15 Thread Dennis Plöger | getit GmbH
Hi! Hmm... I just understood, that we're probably talking about different things here. As you can see in my configuration, I haven't specify a maxconn value. From the configuration documentation I didn't understand, what the default value is. I just updated my configuration based on this

HAProxy proxying JDBC requests two a percona cluster

2014-10-14 Thread Dennis Plöger | getit GmbH
Hi there! I'm currently trying to create a completely high available setup for the Hybris platform (http://hybris.com/). Hybris is a Spring-based framework for e-commerce sites, that is running on Tomcat and connecting via a JDBC pool to different databases, MySQL being one. So I've set up

Re: HAProxy proxying JDBC requests two a percona cluster

2014-10-14 Thread Jarno Huuskonen
Hi, On Tue, Oct 14, Dennis Plöger | getit GmbH wrote: Hi there! I'm currently trying to create a completely high available setup for the Hybris platform (http://hybris.com/). Hybris is a Spring-based framework for e-commerce sites, that is running on Tomcat and connecting via a JDBC pool