Tobias Petry

Database Consultant

Talk - Scaling Databases

Running your database server on one server is easy. But scaling it is complex as there are many different ways to do it and each one has their own their shortcomings. Most literature does never explain the precise advantages and disadvantages of each approach. We take a look at all of them and highlight their characteristics.

Covered in the talk will be:

• Tasks to do before scaling
• Scaling-Up as a simple first approach
• Multi-Master-Replication
• Replication (Read Secondaries)
• Sharding (* Bonus: OLAP - because sometimes you just have to use a different type of database)

About

Hey! I'm Tobias, a full-stack software developer, database specialist and educator from Germany. I primarily work with Laravel, MySQL or PostgreSQL and various technologies on the frontend.

In my first year of programming, I slowed down an application to multi-second response times with a single slow SQL query. This experience sparked my desire to learn all about databases and their performance. In the past 15+ years, I became a database expert with a lot of expertise in the architectures and quirks of many database systems. My favorite part of databases is that feeling, when you find and optimize all the slow queries that the application feels much more speedy afterward.

At present, I use most of my time working with databases: I help development teams fix their performance problems, teach advanced SQL features and build tools to better work with databases. As a full-stack developer and database engineer, I am the missing link between a developer's approach and the knowledge of a database expert to know more efficient ways to solve a problem.

See all speakers ›