Presentations
MySQL has been the most rapidly implemented version of the most popular database on the web. Our new CI/CD release schedule means we are introducing improvements on a quarterly basis and you may have missed one or two new features. You may have missed hash joins, random password generation, multi-value indexes, check constraints, the Clone plugin, how to validate JSON documents for required fields or range checks, and dual passwords. This presentation will cover the new features and how to implement them so you too can take advantage of the latest and greatest from MySQL.
There are many relatively simple configuration changes that an admin can quickly deploy to increase the security and deployability of a new PostgreSQL cluster.
This presentation and live demo will rapidly explain and demonstrate several such configuration changes including: logging user authentication and activity, enabling SSL, requiring secure client connections, and more. Attendees will agree there are "no excuses" to skip deploying these easy modifications.
Open source works in the open, that means git log, email archives, etc. are open data, right? WRONG!
This talk walks through the legal and technical challenges for analyzing open source projects. Solutions and best practices will be shared. The audience is expected to have experience with open source projects and to have an interest in learning more about analyzing those projects. This can include maintainers, community managers, organizational open source program officers, academics, or data scientists with an interest in data from open source.
With the latest Debian release, Secure Boot is officially supported and it follows a list of other Linux Distributions. But how does one get binaries signed off to deploy a Secure Boot compatible custom Kernel or bootloader? This presentation details how the opsi project implemented Secure Boot to provide operating system provisioning with as little administrative interaction as possible
Optimizing MySQL performance and troubleshooting MySQL problems are two of the most critical and challenging tasks for MySQL DBA’s. The databases powering your applications need to be able to handle changing traffic workloads while remaining responsive and stable so that you can deliver an excellent user experience. Further, DBA’s are expected to find cost-efficient means of solving these issues. In this presentation, we will demonstrate how PMM 2 enables you to solve these challenges, which is built on free and open-source software. We will look at common MySQL problems and how to fix them.
Security Onion is a free and open source Linux distro that contains best of breed open source components for enterprise visibility. It was created by defenders for defenders who may not otherwise have the resources for comprehensive visibility. If we can give defenders better visibility, then they can detect their adversaries more quickly and interrupt them before they achieve their objectives!
Whether you’re a newbie to databases and PostgreSQL, or a seasoned database administrator getting your toes wet using PostgreSQL for the first time, understanding what the “gotchas” are and how to solve them will not only save you time, but a lot of headaches as well.
This talk is prepared as a bunch of slides, where each slide describes a really bad way people can screw up their PostgreSQL database and provides a weight - how frequently I saw that kind of problem. Right before the talk I will reshuffle the deck to draw ten random slides and explain you why such practices are bad and how to avoid running into them.
As a Production Engineer on the Operating Systems team at Facebook, I'm a member of one of the more active oncalls for one of the largest fleets of servers in the world. In this talk I'm going to cover the mindset of our oncall, how the values of Production Engineering manifest in the practices of our oncalls, and how I ensure that the workload stays manageable. Ignoring internal tooling, this will focus more on best practices and mindset.