I agree, you are already using proxying so that should help. If you have heavy load you can look into mysql tuning(on db server). But as is you should be fine.
Aly Sent from my BlackBerry device on the Rogers Wireless Network -----Original Message----- From: Reindl Harald <h.rei...@thelounge.net> Sender: owner-postfix-us...@postfix.org Date: Sat, 09 Apr 2011 00:11:23 To: <postfix-users@postfix.org> Subject: Re: mysql lookup on another host performance q? Am 09.04.2011 00:04, schrieb Voytek Eymont: > I have a small*1 Postfix server with virtual users/domains in MySQL on > same host > > service is now being transferred to a new machine, with postfix on one > host, mysql on another host > > I've set it up like so with 'proxy:mysql'*2 to the mysql machine : > > seems to work OK, but I'm concerned about possible performance or other > issue with the mysql on another host > > any suggestions on such appreciated > > ------------------------------------------- > virtual_transport = virtual > virtual_alias_maps = proxy:mysql:/etc/postfix/mysql_virtual_alias_maps.cf > virtual_mailbox_base = /var/mail/vhosts > virtual_mailbox_domains = > proxy:mysql:/etc/postfix/mysql_virtual_domains_maps.cf > virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf > > *small like so: > Per-Day Traffic Summary > ----------------------- > date received delivered deferred bounced rejected > -------------------------------------------------------------------- > Apr 4 2011 2411 2975 61 13 1290 > Apr 5 2011 2707 3400 111 11 1347 > Apr 6 2011 2681 3440 106 6 1373 this are so few mails for postfix that speed does not matter :-) mysql on a remote-host can be much slower but should not be a problem unless you have real high traffic
