{"id":2732,"date":"2017-07-19T09:33:02","date_gmt":"2017-07-19T09:33:02","guid":{"rendered":"https:\/\/nextcloud.com\/?p=2732"},"modified":"2022-09-13T09:27:31","modified_gmt":"2022-09-13T07:27:31","slug":"tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud","status":"publish","type":"post","link":"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/","title":{"rendered":"TU Berlin halves database load by migrating 22K users to Nextcloud"},"content":{"rendered":"

\"\"
\nLast week, we announced<\/a> that 9 German education and research organizations moved from ownCloud to Nextcloud together with the TU Berlin. Today we’ve published a case study on our website<\/a> which details the migration of the TU Berlin and the results achieved, including 50% lower base and 38% lower peak database loads. The end result was faster service to users at lower cost.<\/p>\n

\"\"<\/p>\n

TU Berlin’s ownCloud-Nextcloud infrastructure<\/h2>\n

The Tu Berlin was one of the first universities to provide its own file sync and share solution, already evaluating ownCloud back in 2011. They provided cloud storage within the DFN cloud research program, servicing 16 member research and higher education institutions today. Their service has over 22.000 active users at the TU Berlin, with more at the other organizations and storage for the TU Berlin itself is well over 70 TB, with students allowed a maximum of 20 GB data and staff members up to 100 GB.<\/p>\n

The TU Berlin uses load balancers spreading user requests between 4 application servers which run a NGINX\/MySQL\/PHP 5.6 stack on CentOS 7.3. Data can be found on a GPFS-based storage and a Galera MySQL cluster while LDAP and Kerberos handle authentication and all of it runs in LXD containers managed with OpenStack.<\/p>\n

Migration<\/h2>\n

After Nextcloud won a tender for providing a new file sync and share solution, TU Berlin decided to migrate to Nextcloud 11 which promised significant scalability, security and feature improvements.<\/a> The team is also interested in exploring Nextcloud Global Scale<\/a> in the future, for scaling up their DFN cloud service and decreasing the total cost of ownership.<\/p>\n

The migration was planned during the course of three weeks and executed in one week, fitting the update window set between the result of the tender and end of the old contract. A test environment built from a copy of production was used to prepare. As part of the migration to Nextcloud 11, the TU Berlin decided to move to NGINX from Apache, which was made possible thanks to the native SAML support in Nextcloud.<\/p>\n

The migration process itself was ready in time and worked exactly as planned. The TU Berlin did not need any stand-by support from Nextcloud.<\/p>\n

Overall, the migration was like a typical upgrade.<\/p><\/blockquote>\n

Results<\/h2>\n

Before Nextcloud 11 was deployed, the TU Berlin faced scaling issues with heavy peak load on the database cluster during working hours. The migration resulted in peak load decreasing by over 38% while off-peak times even show a 49% lower stress on the servers. Thanks to this improvement users experience a snappier experience and faster syncing while the TU Berlin can now grow further without significant investment.<\/p>\n

\"\"

Server load before and after migration from ownCloud to Nextcloud<\/p><\/div>\n

You can find more details in the case study on our website<\/a> and Dr.-Ing. Thomas Hildmann from the TU Berlin will talk about the migration and its results at the Focus Friday<\/a> on the Nextcloud Conference later in August.<\/p>\n","protected":false},"excerpt":{"rendered":"

Last week, we announced that 9 German education and research organizations moved from ownCloud to Nextcloud together with the TU Berlin. Today we’ve published a case study on our website which details the migration of the TU Berlin and the results achieved, including 50% lower base and 38% lower peak database loads. The end result […]<\/p>\n","protected":false},"author":2,"featured_media":2750,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"publish_to_discourse":"1","publish_post_category":"22","wpdc_auto_publish_overridden":"","wpdc_topic_tags":"","wpdc_pin_topic":"","wpdc_pin_until":"","discourse_post_id":"52124","discourse_permalink":"https:\/\/help.nextcloud.com\/t\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/18293","wpdc_publishing_response":"success","wpdc_publishing_error":"","footnotes":""},"categories":[7],"tags":[],"class_list":["post-2732","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news"],"acf":[],"yoast_head":"\nTU Berlin halves database load by migrating 22K users to Nextcloud - Nextcloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"TU Berlin halves database load by migrating 22K users to Nextcloud - Nextcloud\" \/>\n<meta property=\"og:description\" content=\"Last week, we announced that 9 German education and research organizations moved from ownCloud to Nextcloud together with the TU Berlin. Today we’ve published a case study on our website which details the migration of the TU Berlin and the results achieved, including 50% lower base and 38% lower peak database loads. The end result […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/\" \/>\n<meta property=\"og:site_name\" content=\"Nextcloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Nextclouders\/\" \/>\n<meta property=\"article:published_time\" content=\"2017-07-19T09:33:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-13T07:27:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/nextcloud.com\/wp-content\/uploads\/2017\/07\/graph.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1100\" \/>\n\t<meta property=\"og:image:height\" content=\"422\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Jos Poortvliet\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@nextclouders\" \/>\n<meta name=\"twitter:site\" content=\"@nextclouders\" \/>\n<meta name=\"twitter:label1\" content=\"Scritto da\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jos Poortvliet\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo di lettura stimato\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuti\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/\"},\"author\":{\"name\":\"Jos Poortvliet\",\"@id\":\"https:\/\/nextcloud.com\/it\/#\/schema\/person\/c3c1a52fbc1c6a2be2f1df8818daa8c2\"},\"headline\":\"TU Berlin halves database load by migrating 22K users to Nextcloud\",\"datePublished\":\"2017-07-19T09:33:02+00:00\",\"dateModified\":\"2022-09-13T07:27:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/\"},\"wordCount\":495,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/nextcloud.com\/it\/#organization\"},\"image\":{\"@id\":\"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/nextcloud.com\/c\/uploads\/2017\/07\/graph.png\",\"articleSection\":[\"News\"],\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/\",\"url\":\"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/\",\"name\":\"TU Berlin halves database load by migrating 22K users to Nextcloud - Nextcloud\",\"isPartOf\":{\"@id\":\"https:\/\/nextcloud.com\/it\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/nextcloud.com\/c\/uploads\/2017\/07\/graph.png\",\"datePublished\":\"2017-07-19T09:33:02+00:00\",\"dateModified\":\"2022-09-13T07:27:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/#primaryimage\",\"url\":\"https:\/\/nextcloud.com\/c\/uploads\/2017\/07\/graph.png\",\"contentUrl\":\"https:\/\/nextcloud.com\/c\/uploads\/2017\/07\/graph.png\",\"width\":1100,\"height\":422,\"caption\":\"Server load before and after migration from ownCloud to Nextcloud\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/nextcloud.com\/it\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"TU Berlin halves database load by migrating 22K users to Nextcloud\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/nextcloud.com\/it\/#website\",\"url\":\"https:\/\/nextcloud.com\/it\/\",\"name\":\"Nextcloud\",\"description\":\"Regain control over your data\",\"publisher\":{\"@id\":\"https:\/\/nextcloud.com\/it\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/nextcloud.com\/it\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"it-IT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/nextcloud.com\/it\/#organization\",\"name\":\"Nextcloud\",\"url\":\"https:\/\/nextcloud.com\/it\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/nextcloud.com\/it\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/nextcloud.com\/c\/uploads\/2022\/10\/nextcloud-logo-blue-transparent.svg\",\"contentUrl\":\"https:\/\/nextcloud.com\/c\/uploads\/2022\/10\/nextcloud-logo-blue-transparent.svg\",\"width\":\"1024\",\"height\":\"1024\",\"caption\":\"Nextcloud\"},\"image\":{\"@id\":\"https:\/\/nextcloud.com\/it\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/Nextclouders\/\",\"https:\/\/x.com\/nextclouders\",\"https:\/\/www.linkedin.com\/company\/10827569\/\",\"https:\/\/youtube.com\/nextcloud\",\"https:\/\/www.instagram.com\/nextclouders\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/nextcloud.com\/it\/#\/schema\/person\/c3c1a52fbc1c6a2be2f1df8818daa8c2\",\"name\":\"Jos Poortvliet\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/nextcloud.com\/it\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1c6de64891ee8c4902e1ac198f26ea5fb202d8bbaa7bce35b6a184610bbe4a3d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1c6de64891ee8c4902e1ac198f26ea5fb202d8bbaa7bce35b6a184610bbe4a3d?s=96&d=mm&r=g\",\"caption\":\"Jos Poortvliet\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"TU Berlin halves database load by migrating 22K users to Nextcloud - Nextcloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/","og_locale":"it_IT","og_type":"article","og_title":"TU Berlin halves database load by migrating 22K users to Nextcloud - Nextcloud","og_description":"Last week, we announced that 9 German education and research organizations moved from ownCloud to Nextcloud together with the TU Berlin. Today we’ve published a case study on our website which details the migration of the TU Berlin and the results achieved, including 50% lower base and 38% lower peak database loads. The end result […]","og_url":"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/","og_site_name":"Nextcloud","article_publisher":"https:\/\/www.facebook.com\/Nextclouders\/","article_published_time":"2017-07-19T09:33:02+00:00","article_modified_time":"2022-09-13T07:27:31+00:00","og_image":[{"width":1100,"height":422,"url":"https:\/\/nextcloud.com\/wp-content\/uploads\/2017\/07\/graph.png","type":"image\/png"}],"author":"Jos Poortvliet","twitter_card":"summary_large_image","twitter_creator":"@nextclouders","twitter_site":"@nextclouders","twitter_misc":{"Scritto da":"Jos Poortvliet","Tempo di lettura stimato":"2 minuti"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/#article","isPartOf":{"@id":"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/"},"author":{"name":"Jos Poortvliet","@id":"https:\/\/nextcloud.com\/it\/#\/schema\/person\/c3c1a52fbc1c6a2be2f1df8818daa8c2"},"headline":"TU Berlin halves database load by migrating 22K users to Nextcloud","datePublished":"2017-07-19T09:33:02+00:00","dateModified":"2022-09-13T07:27:31+00:00","mainEntityOfPage":{"@id":"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/"},"wordCount":495,"commentCount":0,"publisher":{"@id":"https:\/\/nextcloud.com\/it\/#organization"},"image":{"@id":"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/#primaryimage"},"thumbnailUrl":"https:\/\/nextcloud.com\/c\/uploads\/2017\/07\/graph.png","articleSection":["News"],"inLanguage":"it-IT","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/","url":"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/","name":"TU Berlin halves database load by migrating 22K users to Nextcloud - Nextcloud","isPartOf":{"@id":"https:\/\/nextcloud.com\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/#primaryimage"},"image":{"@id":"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/#primaryimage"},"thumbnailUrl":"https:\/\/nextcloud.com\/c\/uploads\/2017\/07\/graph.png","datePublished":"2017-07-19T09:33:02+00:00","dateModified":"2022-09-13T07:27:31+00:00","breadcrumb":{"@id":"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/"]}]},{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/#primaryimage","url":"https:\/\/nextcloud.com\/c\/uploads\/2017\/07\/graph.png","contentUrl":"https:\/\/nextcloud.com\/c\/uploads\/2017\/07\/graph.png","width":1100,"height":422,"caption":"Server load before and after migration from ownCloud to Nextcloud"},{"@type":"BreadcrumbList","@id":"https:\/\/nextcloud.com\/it\/blog\/tu-berlin-halves-database-load-by-migrating-22k-users-to-nextcloud\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/nextcloud.com\/it\/"},{"@type":"ListItem","position":2,"name":"TU Berlin halves database load by migrating 22K users to Nextcloud"}]},{"@type":"WebSite","@id":"https:\/\/nextcloud.com\/it\/#website","url":"https:\/\/nextcloud.com\/it\/","name":"Nextcloud","description":"Regain control over your data","publisher":{"@id":"https:\/\/nextcloud.com\/it\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/nextcloud.com\/it\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"it-IT"},{"@type":"Organization","@id":"https:\/\/nextcloud.com\/it\/#organization","name":"Nextcloud","url":"https:\/\/nextcloud.com\/it\/","logo":{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/nextcloud.com\/it\/#\/schema\/logo\/image\/","url":"https:\/\/nextcloud.com\/c\/uploads\/2022\/10\/nextcloud-logo-blue-transparent.svg","contentUrl":"https:\/\/nextcloud.com\/c\/uploads\/2022\/10\/nextcloud-logo-blue-transparent.svg","width":"1024","height":"1024","caption":"Nextcloud"},"image":{"@id":"https:\/\/nextcloud.com\/it\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Nextclouders\/","https:\/\/x.com\/nextclouders","https:\/\/www.linkedin.com\/company\/10827569\/","https:\/\/youtube.com\/nextcloud","https:\/\/www.instagram.com\/nextclouders\/"]},{"@type":"Person","@id":"https:\/\/nextcloud.com\/it\/#\/schema\/person\/c3c1a52fbc1c6a2be2f1df8818daa8c2","name":"Jos Poortvliet","image":{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/nextcloud.com\/it\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1c6de64891ee8c4902e1ac198f26ea5fb202d8bbaa7bce35b6a184610bbe4a3d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1c6de64891ee8c4902e1ac198f26ea5fb202d8bbaa7bce35b6a184610bbe4a3d?s=96&d=mm&r=g","caption":"Jos Poortvliet"}}]}},"featured_media_url":"https:\/\/nextcloud.com\/c\/uploads\/2017\/07\/graph.png","_links":{"self":[{"href":"https:\/\/nextcloud.com\/it\/wp-json\/wp\/v2\/posts\/2732","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nextcloud.com\/it\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nextcloud.com\/it\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nextcloud.com\/it\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nextcloud.com\/it\/wp-json\/wp\/v2\/comments?post=2732"}],"version-history":[{"count":0,"href":"https:\/\/nextcloud.com\/it\/wp-json\/wp\/v2\/posts\/2732\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nextcloud.com\/it\/wp-json\/wp\/v2\/media\/2750"}],"wp:attachment":[{"href":"https:\/\/nextcloud.com\/it\/wp-json\/wp\/v2\/media?parent=2732"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nextcloud.com\/it\/wp-json\/wp\/v2\/categories?post=2732"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nextcloud.com\/it\/wp-json\/wp\/v2\/tags?post=2732"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}