On Tuesday 29 July 2003 15:58, Jens Jahr wrote: > Sérgio Manuel Rosa wrote: > > Jesse Guardiani writes: > >> On Monday 28 July 2003 20:05, Sérgio Manuel Rosa wrote: > >>> Hi List, > >>> I've got to build a new server. This server is going to hold a great > >>> number > >>> of users and a lot of traffic. > >>> My question is: should I use mySQL, ldap or none? > >> > >> MySQL. Without a doubt. > > > > Thanks Jesse, > > I was guessing that... Well it's never late to learn new stuff. > > Regards > > srosa > > Hi Jesse,
First of all, you're talking to the wrong person. I recommended MySQL, but I didn't ask the original question. > > bevor you decide to choose mySQL make your mind clear about the > follwoing things: > > - are you able to replicate your database with mySQL ? Yes. > - are these tables tranactional based in mySQL ? vpopmail doesn't use transactions and rollback. What's your point? But yes, MySQL supports transactional tables in version 4.0. They're called innodb. > - are you able to do __consistent__ online backups with mySQL ? ( dont > bother me with any mysql-dump scripts ... or something like that ... ) Ever heard of a tape drive? Yes. Yes you can. In a variety of ways. > - did you ever do a disaster recovery with mySQL ? Yup. No problem. > - are you able to extend/migrate you database with mySQL ? I'm confused. I thought this was for a vpopmail/qmail mail server. What would he be extending to? What would he be migrating to? And yes, you CAN migrate if needed. It's SQL. > > > so if you really plan to setup a huge server which has to fit these > point... well, things twice ;-)) Sounds like you've had problems with MySQL in the past, but I think your concerns are unfounded. I've personally been running MySQL for over a year now with no trouble, and my employer has been running it for many years before that. What's more, MySQL keeps getting better. In short, I know that MySQL is a good choice for vpopmail/qmail mail servers from experience. > There are more database backend's , e.g. oracle with totally fulfill > these points. And cost more money for the same functionality too. > if you are not familiar with these point , than you should choose mySQL. I just don't understand your reasoning here. > > Cheers > Jens -- Jesse Guardiani, Systems Administrator WingNET Internet Services, P.O. Box 2605 // Cleveland, TN 37320-2605 423-559-LINK (v) 423-559-5145 (f) http://www.wingnet.net