Automatization of Postgres Administration
Cloud services like Amazon RDS or Google Cloud SQL help to automate half of DBA tasks: launch database instances, provision replicas, create backups. But the other, very important part is almost not automated now: database tuning and query optimization.
High Performance, Scalable, and Available MySQL Clustering System for the Cloud
Vitess is now used in production at multiple companies. Vitess shines in this area by providing query logs, transaction logs, information URLs, and status variables that can feed into a monitoring system like Prometheus.
Ghostferry: the Swiss Army Knife of Live Data Migrations with Minimum Downtime
Inspired by gh-ost, our tool is named Ghostferry and allows application developers at Shopify to migrate data without assistance from DBAs. We plan to open source Ghostferry at the conference so that anyone can migrate their own data with minimal hassle and downtime.
What is a Self-Driving Database Management System?
People are touting the rise of ""self-driving"" database management systems (DBMSs). But nobody has clearly defined what it means for a DBMS to be self-driving. Thus, in this keynote, Andy provides the history of autonomous databases and what is needed to make a true self-driving DBMS.
Shuhao is a software developer working Shopify for the last 3 years. His current work include improving and automating many aspects the database infrastructure for the Datastores team. When not writing software, Shuhao's pursuing a Masters of Applied Science in mechanical engineering.
Sugu co-created the Vitess project in 2010 and has been working on it since then. He is currently focused on building and supporting the Vitess community. He loves to talk about distributed systems, consensus algorithms, as well as SQL parsers and optimizers.
More than 15 years of experience with various DBMSes, more than 10 years with PostgreSQL. M.S., MIPT and ISP RAS, speciality "Database systems". Co-founder Postila.ru, #RuPostgres (PostgreSQL user group for Russian-speaking users, the second in size on Meetup.com, 1400+ members), Postgres.tv. Russian press contact, PostgreSQL Global Development Group. Twitter: @postgresmen
Andy Pavlo is an Assistant Professor of Databaseology in the Computer Science Department at Carnegie Mellon University.