Jan 29 – 31, 2018
AGH Computer Science Building D-17
Europe/Zurich timezone

Troubleshooting Relational Database Backed Applications

Jan 30, 2018, 6:40 PM
20m
AGH Computer Science Building D-17

AGH Computer Science Building D-17

AGH WIET, Department of Computer Science, Building D-17, Street Kawiory 21, Krakow

Speaker

Gregory Vernon (SWITCH edu-ID)

Description

Managing the database where you store your application data is always an
interesting challenge. As the scale of your service grows, so does the
challenge of keeping a healthy database service. However with just a few tools
and techniques it is possible to implement some serious performance
improvements with just a little bit of effort. Using the performance tools
included with MariaDB, at SWITCH we were able to significantly reduce our load
on our a few of our MariaDB databases and even retire some of our database
servers. In this presentation as an example we will show you how we improved
the performance of our Owncloud database. However, these methods are applicable
to any database-backed application, and with databases other than MariaDB. This
session will equip you with the ability to identify issues with your database and
give you ideas as to what to do to fix these issues.

Primary author

Gregory Vernon (SWITCH edu-ID)

Presentation materials