On Thu, 08 Dec 2011 06:22:58 +0200, Timo Sirainen tss@iki.fi wrote:
On Wed, 2011-12-07 at 13:02 -0500, Micah Anderson wrote:
I've got my users in a replicated database setup and dovecot configured with two connect lines in dovecot-sql.conf:
connect = host=127.0.0.1 port=3306 dbname=users user=user password=pass connect = host=127.0.0.2 port=3306 dbname=users user=user password=pass
this works really well to help balance the load.
If you actually have it like that, it should only be using 127.0.0.2, as the second connect setting overrides the first one..
What I actually have is:
connect = host=127.0.0.1 port=3306 dbname=users user=user password=pass connect = host=127.0.0.1 port=3307 dbname=users user=user password=pass
two different port configurations (I'm running stunnel), rather than two different host entries[0].
The right way would have been:
connect = host=127.0.0.1 host=127.0.0.2 port=...
So, if I just have two different ports, would the right way be:
connect = host=127.0.0.1 port=3306 port=3307 dbname...
?
micah
- When I was anonymizing the db connection information in the original post, I accidentally changed the ip and decided it didn't matter for the question I was asking, so just left it. Now I see that might be confusing.