Le dimanche 15 juin 2014 à 16:06 +0200, Paul J Stevens a écrit : > dbmail-lmtpd being single threaded, 1 or 2 per second per process is > quite normal.
If DBmail relied on schemas, it would make sense to open a transaction for each delivery. Each transaction is handled by a different process, which would scale both at connection level and database level. > short of making lmtpd multi-threaded: > > If you need more throughput, you could spin up more lmtpd process on > different ports and have postfix load-balance over them using > something > like haproxy. A modern database like PostgreSQL can handle 10.000 queries per second. Especially when using SSDs. So why should we need multiple hosts and a complex scenario? Proxies are never a solution for bad database design and poor security. The first thing to do is to make each account separate in database using schemas in PostgreSQL and table prefix in MySQL. THEN on only THEN DBMail should scale easily, because each database connection will be handled by a separate process. Kind regards, Kellogs _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
