Presentations
Automation of building & testing code with CI/CD enables us to ship code frequently with a high level of trust that bugs won’t impact end-users. Why though, is CI/CD still so painfully slow, unreliable, and our ability to deliver frequently blocked?
Look at CI/CD with an SRE lens, understand how to set meaningful SLIs, SLOs, & error budgets to tune test suites & pipelines to reclaim control over large, slow and unreliable build and deploy processes.
One of the most important administrative tasks for a PostgreSQL DBA is watching for Transaction ID Exhaustion, more commonly known as "Wraparound". Like the Lovecraftian elder gods, most users will rarely encounter it. But if you do, it's going to be a bad time. This talk will briefly go over the concept of transaction IDs, but will mostly be concentrating on monitoring for the exhaustion event and how to prevent it. Since this activity is tightly tied to the tuning of autovacuum, it also has a direct relation to methods that can help prevent awakening another sleeping giant, bloat.
The MySQL world is full of trade-offs, and choosing a High Availability (HA) solution is no exception. This session aims to look at all of the alternatives in an unbiased nature.
Coverage will include: ProxySQL, MySQL InnoDB Cluster, Galera Cluster and its variants, and how the different servers handle HA. External tools like Orchestrator, and cloud offerings will also be covered.
My presentation "Explaining the Postgres Query Optimizer" covers the details of query optimization, optimizer statistics, joins, and indexes. This talk covers 40 other operations the optimizer can choose to handle complex queries, large data sets, and to enhance performance. These include merge append, gather, memoize, and hash aggregate. It explains their purpose and shows queries that can generate these operations.
This talk will show how bloat can accumulate, what that looks like at the page level and at the level of entire tables and indexes, and how that may impact production queries. It goes into depth about the theory of operation behind VACUUM in Postgres.
Containers are made with namespacing and cgroups, but what does that really mean? In this talk, we'll start with chroot system call and build up our own 'container' runtime using go. We'll explore how Linux features enable containerization and give the audience a stronger intuition about what's really happening when you start one up.
The Internet of Things (IoT) is increasingly driven by sensor data, with devices taking measured actions based on everything from wind speed and direction, vital body functions, illumination intensity, and temperature.
In this session we will showcase how to build a fully functional sample IoT monitoring application built on the Flask framework and utilizing InfluxDB as its backend. With integrations to visualization libraries such as Plotly, creating automated alerts with InfluxDB as well as data downsampling.
I used to be the Certification Manager for MySQL AB and I would hear from hiring managers that it was hard to find qualified MySQL DBAs but it was impossible to find qualified PostgreSQL DBAs. So if we need more PG DBAs can we build them from MySQL DBAs? I have been delivering a series on PostgreSQL for MySQLs that has a very good response and it turns out that MySQL DBAs can learn another database easily. This talk will compare and contrast what MySQL DBAs are used to and how to 'transpose' their knowledge to PG.
Whether you took a class or taught yourself, it’s likely that you learned some variant of “homework C++”, with the assumption that you would write differently in production code. But how do you learn to do that if it isn’t actually taught? Topics to be covered include using modern tooling, understanding and using smart pointers even with different arenas and custom free() functions, aggressively wrapping ugly or dangerous external interfaces, elementary cache behavior, and designing around high-level synchronization structures such as queues rather than low-level threading primitives.
Alex set out to kill the banality in educational hardware platforms when he created the Nugget: a cat-shaped console for cybersecurity and hardware beginners. He wanted to create an interactive product that would make it fun to learn daunting topics like network security and USB hacking through a cute interface, while also offering utility for seasoned hackers & makers. In this talk, Alex discusses the challenges he faced in bringing a niche educational hardware platform to market, and talks about how he scaled this project into a successful business through open-source design.