<div dir="ltr">IMO yes:-)<br><div>i suppose it all depends... For most, who keep their databases nice and small and ... tidy... It likely doesn't matter that much. I did have some figures from way back, but can't seem to find them (not that surprising, we're talking years:-). But if you have a vast number of messages needing to be logged every day... well, I've been told that it can make all the difference in the world. then again, if you're in that kind of situatuion, centralized database logging is probably not a good idea anyway;-).</div>
<div><br></div><div>Cheers</div><div>-- </div><div>-- Glenn</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On 5 August 2014 16:23, Randal, Phil <span dir="ltr"><<a href="mailto:phil.randal@hoopleltd.co.uk" target="_blank">phil.randal@hoopleltd.co.uk</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-GB" link="blue" vlink="purple">
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Does converting the MailWatch databases to InnoDB make a big difference in MailWatch performance?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Just curious.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Phil<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a href="mailto:mailscanner-bounces@lists.mailscanner.info" target="_blank">mailscanner-bounces@lists.mailscanner.info</a> [mailto:<a href="mailto:mailscanner-bounces@lists.mailscanner.info" target="_blank">mailscanner-bounces@lists.mailscanner.info</a>]
<b>On Behalf Of </b>Glenn Steen<br>
<b>Sent:</b> 05 August 2014 14:51<br>
<b>To:</b> MailScanner discussion<br>
<b>Subject:</b> Re: MailScanner Deficiency: Multi-Ruleset Processing per Email Recipient<u></u><u></u></span></p><div><div class="h5">
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">Can only agree with Martin and Alex, there is no way around either splitting mails per recipient (very feasible), or som major rework of both the MailScanner and mailWatch code (very infeasible).<u></u><u></u></p>
<div>
<p class="MsoNormal">But I also have to agree that the increase in hardware seem quite excessive... i suppose you arrived at that figure by analysing the number of recipients per mail (and frequency of multi-recipient emails)? Well, the number isnät everything:-)<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Provided you use the normal caching-dns-thingy and also use "Cache SpamAssassin Results = yes", the actual processing time and resource use will be minimized (not to mention that the normal batch-processing style of MailScanner will ...
help...:-).<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Introducing a "splitting MX" between the internet and your regular MailScanner hosts should be rather simple, as well as adjusting which Received: lines your MailScanner hosts should ignore (since they otherwise will perceive all messages
as originating from the "splitting MX" host)... So why not try that, with the gear you have ATM, and see where that leads you? Depending on what mailstore hosts you eventually deliver to, the storage impact should be minimal or even non-existant, since even
M-Sexchange has abandioned "single store" since ... way back... so every recipient would eventually have their own copy in their own mailbox anyway;-).<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">As Alex says, we know nothing about your actual mail volume, but my money is on there being much less of a problem than you think, even if you do have ... serious traffic... (more than a few thousand mails/hour). the likeliest problem point/bottleneck
is likely your MailWatch database so... keep an eye on that one, make sure you run it as InnoDB etc.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Cheers!<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">-- <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">-- Glenn<u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><u></u> <u></u></p>
<div>
<p class="MsoNormal">On 11 July 2014 15:49, Martin Hepworth <<a href="mailto:maxsec@gmail.com" target="_blank">maxsec@gmail.com</a>> wrote:<u></u><u></u></p>
<div>
<div>
<p class="MsoNormal">Might want to also consider having a more flexible approach as Alex had mentioned.<u></u><u></u></p>
</div>
<p class="MsoNormal">Will also help with some of the hardware requirements as you can also reject non-valid recipients at MTA as well as splitting the emails up, so the core MailScanner farm has less to do.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#888888"><br clear="all">
<span><u></u><u></u></span></span></p>
<div>
<p class="MsoNormal"><span style="color:#888888">-- <br>
Martin Hepworth, CISSP<br>
Oxford, UK</span><u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><u></u> <u></u></p>
<div>
<p class="MsoNormal">On 11 July 2014 09:51, Sam Gelbart <<a href="mailto:samg@synaq.com" target="_blank">samg@synaq.com</a>> wrote:<u></u><u></u></p>
<p class="MsoNormal">Hi All,<br>
<br>
We at SYNAQ use and have used Mailscanner for many years. As an Email Hygiene provider MailScanner has served us very well.<br>
However, as we have grown (very rapidly in the past 6 months, to many more customer domains) we have noticed some deficiencies in MailScanner.<br>
<br>
Below is a brief description covering our problem areas:<br>
<br>
Overview<br>
The issue has arisen due to SYNAQ's ever growing client base and the fact that we're provisioning more and more customers (and email domains) on our hygiene platform, and that more than one of these customer recipients/domains (and their applicable rulesets)
are being addressed in the same email.<br>
<br>
Problem 1<br>
1) <a href="http://abc.co.za" target="_blank">abc.co.za</a> and <a href="http://xyz.co.za" target="_blank">
xyz.co.za</a> are both provisioned on our platform.<br>
2) <a href="http://abc.co.za" target="_blank">abc.co.za</a> has quarantining of SPAM configured, while
<a href="http://xyz.co.za" target="_blank">xyz.co.za</a> does not.<br>
3) Mailscanner accepts the message for processing but "chooses" <a href="mailto:user@abc.co.za" target="_blank">
user@abc.co.za</a> and <a href="http://abc.co.za" target="_blank">abc.co.za</a> as the Message's "to_address" and "to_domain".<br>
4) MailScanner determines that the message is SPAM and because it has "chosen" @<a href="http://abc.co.za" target="_blank">abc.co.za</a> as the email domain it deletes the message as the configured spam action for @abc.coz.a is to delete.<br>
5) However the rule for <a href="http://xyz.co.za" target="_blank">xyz.co.za</a> is to store/quarantine spam. This does not happen because of the actions above and data is also never logged via MailWatch.<br>
6) The example above is a based on very simple scenario, and as you are aware this applies to many more complex rulesets (size, File Type etc) across the system.<br>
<br>
Problem 2<br>
1) <a href="http://abc.co.za" target="_blank">abc.co.za</a> and <a href="http://xyz.co.za" target="_blank">
xyz.co.za</a> are both provisioned on our platform.<br>
2) A third party emails both <a href="mailto:user@abc.co.za" target="_blank">user@abc.co.za</a> and
<a href="mailto:user@xyz.co.za" target="_blank">user@xyz.co.za</a> in a single email message.<br>
3) Mailscanner accepts the message for processing but "chooses" <a href="mailto:user@abc.co.za" target="_blank">
user@abc.co.za</a> and <a href="http://abc.co.za" target="_blank">abc.co.za</a> as the Message's "to_address" and "to_domain".<br>
4) When the message is processed, the MailWatch.pm script receives a message object for SQL logging with data only for
<a href="mailto:user@abc.co.za" target="_blank">user@abc.co.za</a> and <a href="http://abc.co.za" target="_blank">
abc.co.za</a>; <a href="http://xyz.co.za" target="_blank">xyz.co.za</a> is never logged.<br>
<br>
Finally we have considered splitting incoming messages by recipient at an MTA level to address this problem, but our calculations show that it would require 3.5x more hardware to process this increased mail load. So for us a MailsScanner solution is ideal.<br>
<br>
Based on the above, could you tell me if there is anything that can be done from a MailScanner community point of view to help develop MailScanner functionality to address these issues?<br>
We'd be very happy to give a nice donation for a fix or patch.<br>
<br>
Also if the community has any ideas on other ways we can remedy this problem we welcome your feedback.<br>
<br>
Thanks and regards,<br>
<br>
Sam Gelbart<br>
SYNAQ<br>
<span style="color:#888888"><br>
<br>
--<br>
MailScanner mailing list<br>
<a href="mailto:mailscanner@lists.mailscanner.info" target="_blank">mailscanner@lists.mailscanner.info</a><br>
<a href="http://lists.mailscanner.info/mailman/listinfo/mailscanner" target="_blank">http://lists.mailscanner.info/mailman/listinfo/mailscanner</a><br>
<br>
Before posting, read <a href="http://wiki.mailscanner.info/posting" target="_blank">
http://wiki.mailscanner.info/posting</a><br>
<br>
Support MailScanner development - buy the book off the website!</span><u></u><u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
--<br>
MailScanner mailing list<br>
<a href="mailto:mailscanner@lists.mailscanner.info" target="_blank">mailscanner@lists.mailscanner.info</a><br>
<a href="http://lists.mailscanner.info/mailman/listinfo/mailscanner" target="_blank">http://lists.mailscanner.info/mailman/listinfo/mailscanner</a><br>
<br>
Before posting, read <a href="http://wiki.mailscanner.info/posting" target="_blank">
http://wiki.mailscanner.info/posting</a><br>
<br>
Support MailScanner development - buy the book off the website!<u></u><u></u></p>
</div>
<p class="MsoNormal"><br>
<br clear="all">
<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<p class="MsoNormal">-- <br>
-- Glenn<br>
email: glenn < dot > steen < at > gmail < dot > com<br>
work: glenn < dot > steen < at > ap1 < dot > se <u></u><u></u></p>
</div>
</div></div></div>
<font face="Arial, sans-serif" color="#00829b">Hoople Ltd, Registered in England and Wales No. 7556595<br>
Registered office: Plough Lane, Hereford, HR4 0LE<br>
<br>
<font face="Arial, sans-serif" color="black">"Any opinion expressed in this e-mail or any attached files are those of the individual and not necessarily those of Hoople Ltd. You should be aware that Hoople Ltd. monitors its email service. This e-mail and any
attached files are confidential and intended solely for the use of the addressee. This communication may contain material protected by law from being passed on. If you are not the intended recipient and have received this e-mail in error, you are advised that
any use, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. If you have received this e-mail in error please contact the sender immediately and destroy all copies of it."</font></font>
</div>
<br>--<br>
MailScanner mailing list<br>
<a href="mailto:mailscanner@lists.mailscanner.info">mailscanner@lists.mailscanner.info</a><br>
<a href="http://lists.mailscanner.info/mailman/listinfo/mailscanner" target="_blank">http://lists.mailscanner.info/mailman/listinfo/mailscanner</a><br>
<br>
Before posting, read <a href="http://wiki.mailscanner.info/posting" target="_blank">http://wiki.mailscanner.info/posting</a><br>
<br>
Support MailScanner development - buy the book off the website!<br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br>-- Glenn<br>email: glenn < dot > steen < at > gmail < dot > com<br>work: glenn < dot > steen < at > ap1 < dot > se
</div>