I am a Sr. Software Developer at Oracle Cloud. The opinions expressed here are my own and not necessarily those of my employer.
We use SendGrid for sending emails from our Rails application. SendGrid Webhooks sends us notifications when the emails are opened / clicked. We then use the
email_id to find appropriate record in our DB and increment
clicks counters. This enables us to quickly aggregate stats on how each mailing is performing.
Our basic models are:
To keep our controllers simple we created a separate class with the logic to find and update the
But with success come inevitable scalability challenges. Our customers started sending large mailings (tens or hundreds of thousands of recipients). Then our servers would receive thousands of notifications in brief amount of time as people were opening and clicking their emails. This caused sharp spikes in system load.
Alternatively we could have moved the code from the
WebhookRecorder class to methods in
WebhookRecorderJob. It’s simply a matter of preference whether to keep the job as a small wrapper around the class or whether to put more logic in it.
Now whenever we have a large mailing we can see how these jobs queue up but after a few minutes they all process. And the system load remains much more even.
The same pattern can be applied to other situations where the system can receive a large influx of inbound messages in a short amount of time and where it is OK to have slight delay between the time the message is received and when it’s processed.