hi there!
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
regards
Benjamin