How to organize the storage of email messages in an email module of a CRM system?

Question

MySQL

The task is to store all email-messages of the mailbox on your server with the possibility of full-text search in message texts.
Initially implemented in mysql, but since there are a lot of letters, the database starts to weigh tens of gigabytes. There is a feeling that there must be a better solution for this task.
Can you recommend something? Maybe there is information on how this functionality is usually implemented in CRM systems...

Answer 1

Are you satisfied with the speed and relevance of the search? that's what matters, and the volume of the database in gigabytes is trifles. rejoice quietly that not in petabytes.

Answer 2

In normal systems, mailers have their own interfaces, you only pull them from your crm.
Alternatively, implement an internal interface for serving email, and feed this url to elasticsearch.