Shared mysql db used by multiple EFAs?

[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?

[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.

[jahanjoon]

Thanks Shawn for the short and long answers.

[pdwalker]

Just what are you trying to accomplish exactly? I assume redundancy, or more machines for a system that process lots of mail?

[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...