For some time we have been looking at the developments at ownCloud and Nextcloud. In the past year we have seen little feature updates from the ownCloud project.
Last month Nextcloud 11 was released and a lot of new feature and enhancements where made. We at PowerCraft Technology have determined that at this time Nextcloud seems to be the winning project. And therefore all our clients are automatically migrated to Nextcloud 11.
You can take a look at this video to see some of the new features:
Dinsdag was ik als special guest op de RedHat Open Source day in Rome. Ik heb er veel
interessante mensen ontmoet. Ook was het leuk om te zien dat veel mensen mij al kennen
en speciaal naar mij vragen. PGP Zimlet en ownCloud/WebDAV Client zijn populair bij Zimbra
gebruikers.
Ook heb ik gesproken met diverse mensen van Zimbra en ZeXtras en er lijkt consensus te zijn
dat we meer moeten gaan doen met SAML (Single Sign On). Zodat het makkelijker wordt om
dingen als ownCloud, Mattermost (noem andere open source producten) samen te integreren
in Zimbra als 1 product.
Het was een leuke en leerzame ervaring. Mijn special guest interview verschijnt later deze week
op Zimbra.com.
Barry de Graaff en Jorge de la Cruz (Marketing manager van Zimbra)
Barry, Zimbra specialist at PowerCraft Technology got invited as special guest on the Zimbra Community Spotlight at Red Hat Open Source Day in Rome!!
Community Spotlight Interview
During the day there will be a discussion and audio interview, talking about Zimbra Open Source, Community Zimlets and Contributions, The Zeta Alliance, etc.
This week we upgraded some of our larger installations of ownCloud 8.2.7.1 to 9.0.5.2. In the past running the ownCloud update from the command line worked well for us:
Unfortunately some of our installations now have 30GB of MariaDB data files. And running the installer will increase the size of MariaDB to >60GB and this is a little much for comfort. Looking into the database we found a number of tables with oc_oc_ prefix, they seem to be a left over from previous upgrades. So we removed those. Dumping and re-importing using mysqldump the database was still too large. Digging into the tables we found that over 90% of the storage was used in the oc_filecache table.
First we opted to just TRUNCATE TABLE oc_filecache. Then the upgrade went well and MariaDB datafiles went to around 7GB (yes we removed the old data files). Unfortunately all shares (public links and between users) where no longer in the upgraded ownCloud. So we looked a bit more in the source code and found that the oc_share table is inner joined with the oc_filecache table, this explained why the shares no longer showed up. So we decided to:
DELETE FROM oc_filecache WHERE oc_filecache.fileid NOT IN (SELECT oc_share.file_source FROM oc_share);
That query took a little while:
But after the upgrade went smoothly and MariaDB datafiles are still very small compared to what they used to be. Unfortunately a re-download is triggered for users of the ownCloud sync app, but for this instance there where not many users affected, so we could accept that.
We hope the cache table does not need much changing in the future, as it seems quite difficult to upgrade large installations this way. Update: When migrating to Nextcloud 10/11 we found you can also speed up the upgrade process by running: