libreoffice online adoption into 1&1 mail&media ecosystem€¦ · deployment – kubernetes...
TRANSCRIPT
![Page 1: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/1.jpg)
Eduard Ardeleanu Senior Software Engineer
LIBREOFFICE ONLINE ADOPTION INTO
1&1 MAIL & MEDIA ECOSYSTEM
1&1 Mail & Media
![Page 2: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/2.jpg)
Where and Why LibreOffice Online? Architecture Overview
System Solution
Deployment – Kubernetes
Monitoring – Prometheus / Grafana Contributions added by 1&1
Agenda
1&1 Mail & Media2 01/02/2020
![Page 3: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/3.jpg)
1&1 Mail & Media3 01/02/2020
1&1 Mail & Media
email, cloud and identity
services
30 million active users in
Europe and North America
4 brands
![Page 4: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/4.jpg)
Where to find LibreOffice Online ?
1&1 Mail & Media4 01/02/2020
![Page 5: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/5.jpg)
Why LibreOffice Online ?
1&1 Mail & Media5 01/02/2020
![Page 6: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/6.jpg)
Online Office Editor
1&1 Mail & Media6 01/02/2020
![Page 7: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/7.jpg)
Online Office Editor Upload
1&1 Mail & Media7 01/02/2020
![Page 8: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/8.jpg)
Online Office Editor WEB.DE
1&1 Mail & Media8 01/02/2020
![Page 9: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/9.jpg)
Online Office Editor GMX
1&1 Mail & Media9 01/02/2020
![Page 10: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/10.jpg)
Online Office Editor mail.com
1&1 Mail & Media10 01/02/2020
![Page 11: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/11.jpg)
Online Office Editor Templates
1&1 Mail & Media11 01/02/2020
![Page 12: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/12.jpg)
Summary
1&1 Mail & Media12 01/02/2020
LibreOffice Online version – 6.2
TemplatesUpload
![Page 13: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/13.jpg)
Where and Why LibreOffice Online ? Architecture Overview
System Solution Deployment – Kubernetes Monitoring – Prometheus / Grafana
Contributions added by 1&1
Agenda
1&1 Mail & Media13 01/02/2020
![Page 14: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/14.jpg)
System Solution
1&1 Mail & Media14 01/02/2020
OOE LANDING PAGE
Create new documents from predefined templates
Browse through your Cloud documents to edit them
Upload new documents in your Cloud and open them in edit mode
Browse through your recently edited documents from
Cloud
HA BALANCER
Middleware between Clients and LibreOffice Online
Responsible for: authentication, session management and load-balancing
OOE STORAGE ADAPTER
Facilitates communication between LibreOffice Online and Mail & Media Cloud
Implements WOPI REST Specifications
All Online Office Editor modules are scaled with Kubernetes
![Page 15: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/15.jpg)
System Solution
1&1 Mail & Media15 01/02/2020
![Page 16: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/16.jpg)
Deployment - Kubernetes
1&1 Mail & Media16 01/02/2020
Package manager for Kubernetes
Helm uses a packaging format called charts
A chart is a collection of files that describe a related set of Kubernetes resources – Helm Hub -
![Page 17: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/17.jpg)
1&1 Mail & Media17 01/02/2020
![Page 18: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/18.jpg)
1&1 Mail & Media18 01/02/2020
Deployment - Kubernetes
![Page 19: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/19.jpg)
Kubernetes – Horizontal Pod Autoscaler
1&1 Mail & Media19 01/02/2020
Automatically scales the number of pods based on CPU / Memory usage
![Page 20: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/20.jpg)
Kubernetes – Horizontal Pod Autoscaler
1&1 Mail & Media20 01/02/2020
Memory threshold (70%) met ( ✓ ) Scale number of pods from 3 to 4
![Page 21: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/21.jpg)
Monitoring – Prometheus / Grafana
1&1 Mail & Media21 01/02/2020
LibreOffice Online exposes monitoring metrics, compliant with Prometheus format, on REST endpoint ‘/lool/getMetrics’
![Page 22: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/22.jpg)
Monitoring – LibreOffice Online REST Endpoint
1&1 Mail & Media22 01/02/2020
![Page 23: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/23.jpg)
Monitoring – Grafana Charts
1&1 Mail & Media23 01/02/2020
Grafana charts monitoring current number of WSD, FORKIT and KIT processes
![Page 24: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/24.jpg)
Summary
1&1 Mail & Media24 01/02/2020
Kubernetes
Horizontal Pod Autoscaler
Monitoring Prometheus / Grafana
![Page 25: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/25.jpg)
Where and Why LibreOffice Online ? Architecture overview Contributions added by 1&1
Agenda
1&1 Mail & Media25 12/09/2019
![Page 26: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/26.jpg)
Websocket defragmentation
Change 68901:
Added support for defragmentation of incoming websocket fragmented messages
XSS fixes
Change 68548:Displaying sheet name
Change 70113:Check document hyperlink before open
Loleaflet library updates
Change 71726:Updating vex.js
Change 69878:Updating shrinkpack
Small Fixes
Change 67782: Fix ControlMenubar’s delete slide for presentation files
Change 69424: SaveAs breaks when ‘%’ character is used within filename
CVE discovered and reported
CVE-2019-9851 LibreLogo global-event script execution
TLS support for communication
with Storage
Change 80373:
Allow the possibility to customize TLS communication between LibreOffice Online and WOPI Storage
Support for Kubernetes
deployment via helm-chart
Adding support for deploying LibreOffice Online in Kubernetes via helm-chart
Password protected files
Change 72891:
Detecting password protected files while converting (convertTo REST API)
REST endpoint for admin metrics in Prometheus format
Change 82492:
Exposing monitoring metrics, compliant with Prometheus format, via REST endpoint (‘getMetrics’)
26 1&1 Mail & Media01/02/2020
Contributions added by 1&1
Coming soon ...
CDN integration
Allow the plug-in of a CDN (content delivery network) for serving Loleaflet static files
Monitoring segmentation fault
crashes
Replace communication between loolwsd and forkit through UNIX sockets; Implement new metric: segmentation fault crash count
![Page 27: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/27.jpg)
27 1&1 Mail & Media01/02/2020
Special Thanks to LibreOffice Community
![Page 28: LibreOffice Online Adoption Into 1&1 Mail&Media Ecosystem€¦ · Deployment – Kubernetes Monitoring – Prometheus / Grafana Contributions added by 1&1 Agenda 13 01/02/2020 1&1](https://reader033.vdocuments.us/reader033/viewer/2022042316/5f0466847e708231d40dc94b/html5/thumbnails/28.jpg)
Online Office
Thank you for listening