What is the max number of mail accounts in VestaCP?

[ethermcman]

Hi everybody,
I'm setting up a VestaCP server and migrating from a MDaemon server.
That said, we have more than 20000 mail accounts to integrate.
After creating a shell script that parses a csv file and use v-add-mail-account, all mail accounts were migrated.
Flawless...
But, when I use the web panel and query the listing of my 20000 mail accounts, interface is really buggy and slow : more than 45 sec to load. When loaded, scrolling is really laggy.

Any idea to speed up loading?
Thanks.

[skurudo]

The current version of the control panel works with as many accounts slowly, true. But will run faster. Especially after was done code refactoring and core work much faster now.

[ethermcman]

Thanks for your quick reply.
I've increase worker_process and worker_connections in /etc/nginx.conf and it seems to be a little faster : from ~45sec to 20 sec but scrolling up or down in the web interface list is still laggy.
From what you've said, can we expect an vesta update soon?
Last question, why don't you have chosen to store mail accounts in the mariadb database? This would help loading large (did I say huge?) mail account list, wouldn't it?

[skurudo]

I've increase worker_process and worker_connections in /etc/nginx.conf and it seems to be a little faster : from ~45sec to 20 sec but scrolling up or down in the web interface list is still laggy.

This can help a little, but not completely.
skid - author and main developer say refactoring and core update will be solve problem with big data on pages (mail accounts or domain lists).

From what you've said, can we expect an vesta update soon?

Yep, sooner than month age :)
Refactoring completed, bugs and github now. Testing and after this release.

Last question, why don't you have chosen to store mail accounts in the mariadb database? This would help loading large (did I say hug?) mail account list, wouldn't it?

Tricky question. I've seen the requests, it will be good if mail will stored in database. In this case, flexibility is lost, we will always need a database. This is the first that comes to mind.

[ethermcman]

Again thanks for your quick reply.
It's not a production server just testing possibilities so I can wait less than a month for the future update.
Can you explain your "flexibility" pov : file vs sql?
IMHO, it would be great if we could have the option to store (or not) mail accounts/users/domain list in a sql database in this future update.

[mehargags]

@ethermcman
What are the specs of your server ?

1. CPU -- cores
2. RAM
3. Hard Drive - SSD or SAS or HDD ?
4. total size of mailboxes

For 20,000 Mailboxes, that's some serious ISP level service that you are in... so you should consider High Availability clusters. Plus MySQL would be Slower for mails... for these many Mailboxes.
Also Postfix is much superior if you want to control thousands of mailboxes, sadly Vesta doesn't yet support postfix.

[ethermcman]

Hi mehargags,
1. 8 cores
2. 8 Go RAM
3. SAS
4. high user traffic but not more than 5 MB per mailbox that will be (re)send almost immediately

I know that I'm in kind of serious project. If I could have chosen to go without CP, I would choose Postfix, Galera, HA cluster, and so on. But like many other IT society, we have chiefs who don't even understand some Microsoft interfaces, so imagine a linux server... It's why I'm trying VestaCP but also some others CP because I have to give them a GUI...

[skurudo]

Can you explain your "flexibility" pov : file vs sql?

If we'll use some db by default, we bindind yourself and make monolith system - we will need a database always.
And second - low memory servers/vps do "the thing".

I now do not even talk about the encoding in the database and other potential problems.
In short, I believe that as the option that one could try to do it, but by default unlikely.

IMHO, it would be great if we could have the option to store (or not) mail accounts/users/domain list in a sql database in this future update.

Add your idea, please:
https://bugs.vestacp.com/

[mehargags]

Hi mehargags,
It's why I'm trying VestaCP but also some others CP because I have to give them a GUI...

The first rule of thumb setting up IT services is "not putting all your eggs in one basket" so I think you should setup separate servers for Webhosting and mailing services... DO NOT mix them up.

As for dedicated mailing servers are concerned, apart from VestaCP, you can also think of Zentyal, Zimbra, Zarafa, iRedmail, MailCow, Kolab & SOGo groupware are good free yet commercial solutions that aim at dedicated mailing service.
I am not saying you can't run mailing on VestaCP, but considering an ISP lelve game of 20,000 mailboxes, I think you will be better off with a dedicated mailing solution.

[ethermcman]

Thanks skurudo, for your clarifications. Really appreciated.
@ mehargags, separation was my first draft, one server for one role. I'm totally aggreeing your pov.
And you're also right about the CP choice : the main goal is to handle mailboxes and not to be an ISP. I'll look for the solutions you've shown. Thanks for the advice and to redirect me to the right solution.