Difficulty tracking email statuses with Postfix
I've been trying to solve this problem for a few days now and I can't seem to get anywhere with it, does anyone have any thoughts...
I'm trying to setup a newsletter service (running on centos with postfix and php) and I need to determine email statuses once they've been sent (delivered, bounced etc).
So far I've tried using perl to parse the maillog file but this is taking up a lot of resources and seems like a slow way of doing things (especially once the maillog gets bigger). I've just started looking into using rsyslog to insert the maillog straight into mysql but I'm thinking this might knacker out the mysql database.
Has anyone else had any success with efficiently tracking email statuses? Any help would be much appreciated :)