Re: Mailbox, Mysql or Folder.
[Disclaimer: I only run a mail server for mainly personal use. I have less than ten users on that system but the configuration is comparable to that of the ISPMail howto]. Muhammad Yousuf Khan: i am working in a small company 30 to 50 users, so which one is more suitable for me a mailbox storage in a folder or database by keeping in mind stability? I don't think there are many people (or organisations) that keep their e-mails in relational databases. Sure, mail servers like Exchange (or Dovecot) may have their own on-disk-format for mailboxes instead of plain maildirs or mboxes. But they don't use MySQL (or Postgres, for that matter). Do not confuse e-mail storage with user authentication and management. but for learning purpose i also like to know. how big companies (may be with 1000 to 3000 users) deal with such huge mailboxes. Performance-wise, your best bet with Dovecot is probably its own dbox format. You may want to ask for experience with this on the Dovecot mailing list. For 50 users, I recommend to use Maildirs and make sure Dovecot's LDS is used for delivery into mailboxes. That way the index files are always up-to-date. J. -- I am no longer prepared to give you the benefit of the doubt. [Agree] [Disagree] http://www.slowlydownward.com/NODATA/data_enter2.html signature.asc Description: Digital signature
Re: Mailbox, Mysql or Folder.
Jochen Spieker: For 50 users, I recommend to use Maildirs and make sure Dovecot's LDS is ^^^ Whoops. What I meant to write was LDA. Not LSD and most definitely not LDS. :) J. -- I feel yawning hollowness whilst talking to people at parties. [Agree] [Disagree] http://www.slowlydownward.com/NODATA/data_enter2.html signature.asc Description: Digital signature
Re: Mailbox, Mysql or Folder.
On Thu, Nov 1, 2012 at 7:09 AM, Jochen Spieker m...@well-adjusted.de wrote: [Disclaimer: I only run a mail server for mainly personal use. I have less than ten users on that system but the configuration is comparable to that of the ISPMail howto]. Muhammad Yousuf Khan: i am working in a small company 30 to 50 users, so which one is more suitable for me a mailbox storage in a folder or database by keeping in mind stability? I don't think there are many people (or organisations) that keep their e-mails in relational databases. Sure, mail servers like Exchange (or Dovecot) may have their own on-disk-format for mailboxes instead of plain maildirs or mboxes. But they don't use MySQL (or Postgres, for that matter). Exchange may not use MS SQL Server, but it does use a database, namely Extensible Storage Engine (ESE) aka JET Blue (not the same code as JET Red, which was the old Access engine). MS looked at moving Exchange to SQL Server, but decided not to. AFAIK, Exchange is the only major mail server to do this. Cheers, Kelly Clowers
Re: Mailbox, Mysql or Folder.
On Thu, Nov 1, 2012 at 10:42 AM, Kelly Clowers kelly.clow...@gmail.comwrote: On Thu, Nov 1, 2012 at 7:09 AM, Jochen Spieker m...@well-adjusted.dewrote: [Disclaimer: I only run a mail server for mainly personal use. I have less than ten users on that system but the configuration is comparable to that of the ISPMail howto]. Muhammad Yousuf Khan: i am working in a small company 30 to 50 users, so which one is more suitable for me a mailbox storage in a folder or database by keeping in mind stability? I don't think there are many people (or organisations) that keep their e-mails in relational databases. Sure, mail servers like Exchange (or Dovecot) may have their own on-disk-format for mailboxes instead of plain maildirs or mboxes. But they don't use MySQL (or Postgres, for that matter). Exchange may not use MS SQL Server, but it does use a database, namely Extensible Storage Engine (ESE) aka JET Blue (not the same code as JET Red, which was the old Access engine). MS looked at moving Exchange to SQL Server, but decided not to. AFAIK, Exchange is the only major mail server to do this. And, hey! The new Gmail composer automatically uses reply-to-list! Party! Party! (Still defaults to top-posting, though.) Cheers, Kelly Clowers
Re: Mailbox, Mysql or Folder.
Kelly Clowers: On Thu, Nov 1, 2012 at 7:09 AM, Jochen Spieker m...@well-adjusted.de wrote: I don't think there are many people (or organisations) that keep their e-mails in relational databases. Sure, mail servers like Exchange (or Dovecot) may have their own on-disk-format for mailboxes instead of plain maildirs or mboxes. But they don't use MySQL (or Postgres, for that matter). Exchange may not use MS SQL Server, but it does use a database, namely Extensible Storage Engine (ESE) aka JET Blue (not the same code as JET Red, which was the old Access engine). MS looked at moving Exchange to SQL Server, but decided not to. I already supposed something like this when writing my e-mail but couldn't be bothered to google it. Nevertheless, I deliberately chose the term relational database which does not appear to apply to ESE. And that means I am still right. ;-) J. -- After the millenium I will shoot to kill. [Agree] [Disagree] http://www.slowlydownward.com/NODATA/data_enter2.html signature.asc Description: Digital signature
Re: Mailbox, Mysql or Folder.
On Thu, Nov 1, 2012 at 11:44 AM, Jochen Spieker m...@well-adjusted.de wrote: Kelly Clowers: On Thu, Nov 1, 2012 at 7:09 AM, Jochen Spieker m...@well-adjusted.de wrote: I don't think there are many people (or organisations) that keep their e-mails in relational databases. Sure, mail servers like Exchange (or Dovecot) may have their own on-disk-format for mailboxes instead of plain maildirs or mboxes. But they don't use MySQL (or Postgres, for that matter). Exchange may not use MS SQL Server, but it does use a database, namely Extensible Storage Engine (ESE) aka JET Blue (not the same code as JET Red, which was the old Access engine). MS looked at moving Exchange to SQL Server, but decided not to. I already supposed something like this when writing my e-mail but couldn't be bothered to google it. Nevertheless, I deliberately chose the term relational database which does not appear to apply to ESE. And that means I am still right. ;-) You are right indeed. I didn't see a clear answer to whether it was relational or not at first. Cheers, Kelly Clowers -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/CAFoWM=_gljpx1_hmfwtpfpth8tzcccp5kv45edwcdaz3kjm...@mail.gmail.com
Re: Mailbox, Mysql or Folder.
On Thu, 1 Nov 2012 18:55:34 +0500 Muhammad Yousuf Khan sir...@gmail.com wrote: now i want to decide the email storage strategy where i am confuse a bit to choose the correct path. i remember someone once suggested me that i should store emails directly into my harddisk in to file formate instead of MYsql database. the point behind was that if database corrupted then whole data will be lost but on the other hand if i store email in folder it can be recovered easily . (apart from mysql database backup and restore strategy) since i am very new to mail server i would like to learn from your experience and expert opinion that what route should i choose? Exactly right. Do you want maximum security or maximum usability? As others have mentioned here, Exchange uses a database, in part for ease of searching but also for security. There is no reliable way to restore a single mailbox, and if your server dies badly, there's pretty much no way to use even a backup of the database on any other hardware. The encryption of the database is tied into security numbers created with the OS installation. Excellent security for confidential email (as required in certain industries in the US), but the whole lot is gone if you can't recover the server OS installation. The workaround is to run the server virtual, so it can be restored to different physical hardware without a change of installation environment. You virtualise the server in order to have a reasonable chance of disaster recovery of your email... If the server is still there but the database is damaged, it is often possible to restore a backup to a specially-created mount point, from which repairs may be effected. It doesn't always work, and hasn't either of the times I tried it. Then it's a restore of the entire OS from a backup tens of gigabytes in size. And you don't know what resource-hungry means until you've seen Exchange or SQL Server running. Exchange does transaction-rollback, and doesn't commit its journal until the next backup. Obviously, MySQL isn't going to be so difficult to deal with, and it can be easily backed up and restored to another instance. It can be dumped as plain text, and indeed in the form of SQL statements to rebuild the database elsewhere. I assume you could store it in an encrypted filesystem if you needed to, though that would make recovery a little harder if you didn't keep good backups. I store mail as plain text files. Next to no security, but I don't have valuable and confidential emails, and I value the ability to read them with just about any program, or recover most/all of them from most kinds of failure, from a rescue boot medium. Backing up is a trivial file copy. Microsoft has no other mail server but Exchange. With Linux, you have a wide choice. -- Joe -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/20121101220602.5be87...@jretrading.com
Re: Mailbox, Mysql or Folder.
Once I used a mailbox and got cured of that in a hurry when clamav cut off access to the entire content of that mailbox because at least one of the messages in that mailbox had a virus clamav had detected. That was a windows virus too. I went with nmh after that since it uses folders with each message in its own file. I might loose individual files on account of viruses or access to those files but still have access to the rest of my mail. Your mileage very probably will vary. --- jude jdash...@shellworld.net Adobe fiend for failing to Flash -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/alpine.bsf.2.01.1211012056100.1...@freire1.furyyjbeyq.arg