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.
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.