Re: [Sqlgrey-users] sqlgrey fails when configured with multiple machines

[Jernej P. <jer...@ar...>]

Dear Alex,

You could use hapolicy instead (http://postfwd.org/hapolicy/index.html) 
and run multiple instances of sqlgrey on multiple machines.

I am not sure, whether I completely understand your setup: you have 
three node cluster with MySQL master-master replication?

We have successfully deployed sqlgrey with mysql master-slave 
configuration, where reads were performed into slave nodes, while SQL 
writes were done on the master node. After a while, we ditched sqlgrey 
in favour of posftwd2 and hapolicy...

cheers, Jernej

On 30/06/14 16:08, Alex wrote:
> Hi,
>
> I'm using sqlgrey with postfix on three servers, configured using the
> DBCLUSTER layout as defined in the README. However, when one machine
> goes down, all three fail, with the following postfix message:
>
> Jun 30 06:14:00 mail03 postfix/smtpd[32601]: NOQUEUE: reject: RCPT from
> bmail.bridgemailsystem.com
> <http://bmail.bridgemailsystem.com>[66.206.172.149]: 451 4.3.5 Server
> configuration problem; from=<mar...@lo...
> <mailto:mar...@lo...>> to=<Rya...@ex...
> <mailto:Rya...@ex...>> proto=ESMTP
> helo=<bmail.bridgemailsystem.com <http://bmail.bridgemailsystem.com>>
>
> Isn't it supposed to continue running on the remaining systems when one
> of them becomes disconnected?
>
> This is my sqlgrey.conf config on one of the slave machines:
>
> loglevel = 3
> log_override = whitelist:1,grey:3,spam:2
> reconnect_delay = 5
> db_type = mysql
> db_name = sqlgrey
> db_host = ns1.example.com <http://ns1.example.com>
> db_port = default
> db_user = sqlgrey
> db_pass = mypass
> db_cleanup_hostname=ns1.example.com <http://ns1.example.com>
> db_cleandelay = 1800
> clean_method = sync
> db_cluster = on
> read_hosts=localhost,mail02.example.com
> <http://mail02.example.com>,mail03.example.com
> <http://mail03.example.com>,mail01.example.com <http://mail01.example.com>
> prepend = 1
> admin_mail = my...@me...
> <mailto:my...@me...>
>
> Any ideas greatly appreciated.
> Thanks,
> Alex
>
>
>
> ------------------------------------------------------------------------------
> Open source business process management suite built on Java and Eclipse
> Turn processes into business applications with Bonita BPM Community Edition
> Quickly connect people, data, and systems into organized workflows
> Winner of BOSSIE, CODIE, OW2 and Gartner awards
> http://p.sf.net/sfu/Bonitasoft
>
>
>
> _______________________________________________
> Sqlgrey-users mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlgrey-users
>