Lightning Talks

The always entertaining Lightning Talks are during the Thursday night, April 3, MySQL Community Networking Reception which begins immediately following the breakout sessions.

  • Beginner
    David Stokes
    'Truncating Sub Optimal DBA Verbal Responses Vectors' or 'things a DBA should not say' is a guide to help DBAs squelch their first 'gut' response to common user inquiries. For instance a coworker may initiate a dialog with a simple simple statement to ascertain or test knowledge such as 'Is the database up?' wherein they are attempting to understand the... [read more]
  • Intermediate
    Art van Scheppingen
    Slave prefetchers can speed up replication but only work within very limited boundaries. As Domas described it two years ago: "Please don’t use mk-slave-prefetch on MySQL unless you are Facebook. Or at least don’t tell your friends, so they won’t use it." We are not Facebook, but we certainly like to stand in their shadow! Besides that we were suffering from slave lag on a slave that... [read more]
  • Beginner
    Stephane Combaudon
    Global Transaction IDs (GTIDs) in MySQL 5.6 are a great addition as they are supposed to ease replication administration a lot. But they are also changing some old habits and they require careful planning when enabling them. Learn the benefits and gotchas of GTIDs in this talk.
  • Beginner
    In the world of replication, The Binlog is every ones favorite. But what about the Relay log, Don't you feel it can do more ? Yes, It can. How about, if it can serve the purpose of the GTID feature without GTID.
  • Advanced
    prasad mani
    A familiar issue for Database Administrators is how to migrate their 24/7 mission critical application databases to new servers without any database downtime. By using the Federated storage engine and MySQL Replication techniques, it is possible to migrate large databases from one server instance to other server instance without any downtime.
  • Intermediate
    Rick James
    You are combining your logs to find out how many _different_ users have connected. This, itself, is somewhat I/O intensive. But then add to that the desire to rollup daily "uniques", into "weekly" uniques. But you find that SUM(), etc, won't work. I will outline a way to store data at less than one bit per unique user, and do rollups.
  • Advanced
    Rick James
    Performance sags in when the data gets large. This lightning talk discusses 3 classic use cases that suffer this way, then discusses how adding a carefully designed table can take you from meltdown to smooth sailing.
  • Beginner
    Bill Karwin
    When backing up a database in the cloud, many people are forced to choose between using command-line tools, or else writing a custom script to export data. We may not have privileges to use command-line tools in a cloud environment. Writing your own data dump script is deceptively complex. This presentation outlines a simple PHP class I've written that creates backups in the same format as... [read more]
  • Beginner
    Ignacio Nin
    Your outsourced devolopers in Añata-Kubapay, Østër SSR sent in Жак Шит and your db didn't get it right? Did the description for this talk even get saved correctly?? Let's take a look at preparing your DB and application for weird input, collation and related issues.
  • Kyle Redinger
    Sitting in a chair managing MySQL all day is destructive to our lives. We have lost one of the most fundamental abilities to move as a human. The Squat. This session will be a fun, [b]interactive[/b] presentation, talking about what happens to our bodies when we sit in a chair all day, the science behind the squat, how the squat heals us, and why we perform better at our jobs when we exercise... [read more]
  • Gillian Gunson
    This talk is going to be a list of anecdotes of bad instructions and requests that MySQL DBAs have received from developers, managers, and users. Some of these come from personal experience, and others are stories I've heard in the industry. This is a lighthearted look at some of the difficult instructions that DBAs get, with an aim of being educational as well. Each listed request will... [read more]
  • Lawrence Schwartz
    Come and see what happens when you pit a seasoned MySQL DBA against a MySQL newbie to perform replication in MySQL. Who will get the job done well, first and without issues? Think you know the answer? Come find out what happens when the “secret ingredient” is revealed.