Open Source Databases Meetup #2

This is a past event

17 people went

Pivotal Software

211 Old St · London

How to find us

The venue is in the same square as Old Street underground station. Also very easy to reach from London Bridge, with bus lines 21 or 141.

Location image of event venue

Details

Join us at our second meetup! The focus is on the open source database world rockstars: MySQL and PostgreSQL.

Pivotal Software will host the event and provide drink & food, so a big thank you goes to them.

Schedule:

18.30 - Arrival and networking

18:50 - Event introduction

19:00 - pgAudit, by Alastair Turner, data engineer at Pivotal Software

Postgres logging can log a lot of detail but, let's be honest, parsing details out of logged query text can be painful and it's easy to get it wrong. Which is particularly a problem for audits in regulated environments. Join Alastair Turner from Pivotal to learn how the pgAudit extension can help you to provide detailed, specific logging of the session and object activity that matters. With improved management of privilege escalation thrown in as a bonus.

19:40 - MySQL Query Optimisation 101 by Federico Razzoli, freelance database consultant

While tuning servers is important, the key of a high performance application is writing good queries, and good indexes to serve them. But what is exactly a good query/index? Not many developers and DBAs understand how a query is performed internall, and therefore, why it can be fast or slow. Join Federico Razzoli to understand how indexes are implemented, how queries use them, and the simple rules of thumb to avoid hassle.