Page 1 of 1
Shared mysql db used by multiple EFAs?
Posted: 19 Oct 2016 12:53
by jahanjoon
Is there any benefit to having the mysql db(s) on a separate host and shared between 2 or more EFA "front-ends"?
Is this even possible?
Re: Shared mysql db used by multiple EFAs?
Posted: 19 Oct 2016 16:43
by shawniverson
Short answer: yes
Long answer: It will a bit of work to implement. MailWatch supports XMLRPC and remote db connections, and mailscanner can configured to connect to a remote mysqldb. Spamassassin plugins may need to be configured properly as well.
Re: Shared mysql db used by multiple EFAs?
Posted: 19 Oct 2016 16:55
by jahanjoon
Thanks Shawn for the short and long answers.
Re: Shared mysql db used by multiple EFAs?
Posted: 19 Oct 2016 17:04
by pdwalker
Just what are you trying to accomplish exactly? I assume redundancy, or more machines for a system that process lots of mail?
Re: Shared mysql db used by multiple EFAs?
Posted: 19 Oct 2016 17:23
by jahanjoon
A few reasons, one is indeed redundancy, the other is management, to have a single db for SQLGrey (not sure if this would bring any benefit to processing mail if there are 2 or more EFAs), i.e. to have a single place to manage all items like, E-mail addresses, Domains, Optout domain etc in SQLGrey. I also expect to be handling a lot more mail in the next 6 months.
Then look at doing the same for the others, but from my limited understanding of the internal organs of EFA the other services as stated by Shawn may be more complex to achieve.
Am also looking for a little project to learn something new...