> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: 18. mars 2006 14:40 > To: [email protected] > Subject: [IMGate] Re: Using MySQL for Tables > > > an admin system with webinterface where we add the domains > who shall > > have access and which server it shall send the mail to. on > the imgate > > serveres there is a php script run by a cron job every 15 minuttes > > getting the info from the mysql server writing a new map file and > > postmapping this. > > Thanks for your repsonse. I was originally thinking about doing this. > > But then I saw that MySQL could be used directly in Postfix. > > So, my specific interest was in how using the MySQL table > directly from > Postfix would affect the performance of the IMGate box (vs > .map files).
We were thinking the same way but after second thougts we gave it up for many reasons. Mainly reasons was 1. uptime. ( if mysql dies imgate stops moving mail) 2. corrupted table ( see above) depending on the volume of domains this can drag down the performance on server. Another aspect of this is that in worst case if anything happens we can restore the servers quickly with the client and the other way should the db crash and only bad backups running we can rebuild from the .map file So all in all I think we have the best solution by not using the mysql option directly. Benny
