On Tue, Jun 20, 2006 at 08:56:36PM +0200, Anders J wrote: > Hello List. > A customer have a mailserver solution wich must be moved to a new > hardware, today its is running on a old suse 9.2 but i really want to > use OpenBSD if possible. > It uses postfix, cyrus-imap and mysql as the backend for users domain > info, contacts etc. (only 58 named users and 3 domains and several aliases) > My self have experienced mixed issues with MysSQL on OpenBSD and also > read and heard about performance and stability problems with MySQL on > OpenBSD. > So i'm a bit nervous implementing this on OpenBSD (Should i use FreeBSD > instead)?. > Has anyone a positive experience with 3.9+ MySQl > mysql-server-5.0.21.tgz > <ftp://ftp.sunet.se/pub/OpenBSD/3.9/packages/i386/mysql-server-5.0.21.tgz>(or > later)?
I've run postfix on OpenBSD using MySQL as the database for several years with +400 domains and +4k users; handling about 300K messages per day. Never gives me any problems. I had to bump the kern.maxproc and kern.maxfiles sysctl (man 8 sysctl) and add the following to /etc/my.cnf [mysqld_safe] open-files=2000 You may also want to alter the appropriate parts of /etc/login.conf (maxproc + openfiles) (man 5 login.conf) Hope it serves you as well as it has me. > And by the way it is not an option to use postgresql since they also > have several other apps which use the database in question .So migrate > to an other db platform is NOT an option. > > Regards > Anders
