i’m just evaluating a migration from MS-Exchange to an open source solution. After comparing some solutions I think kopano is the tool to serve our needs, and since it’s availeble as fully integrated app inside the UCS server, I even consider replacing our Domain Controllers by UCS.
Since the eMail system is critical for our buisiness I also have to make some thoughts about high availebilty. Regarding the database it’s no problem - we already have several big mysql and mariaDB machines running as galera cluster or with master/slave replication. For testing purpose I just copied the database from the local (USC Test) machine to one of these mysql databases and configured UCS/Kopano to use this database… works pretty well. But I have to maintain also the attachments, which are stored locally on disk. As far as i Know, these attachements were saved as lob object inside the database some time ago and there is still a migration script to move the attachements out of the database. But I thinks it’s more handy to have them inside the database, so it’s automatically replicated and backed up with the current solution in place… but I havent found a solution to migrate the data back to the database or to make a fresh installation of Kopana storing the attachements inside the database (only when i Install kopano manually from source this seems to be possible).
any advise would be welcome, even if you just give me reasons not to store the attachements in the database