Presented by:

26d7f047c161637f6f5459bfad4d5e32

der.hans (vortraege+5bleu-seagl@lufthans.com)

from Object Rocket

der.hans is a Free Software, technology and entrepreneurial veteran.

He's chairman of the Phoenix Linux User Group (PLUG), BoF organizer for the Southern California Linux Expo (SCaLE), and founder of the Free Software Stammtisch and Stammtisch Job Nights.

Currently, he's a Customer Data Engineer at Object Rocket. Most likely anything he says publicly was not approved by $dayjob.

https://floss.social/@FLOX_advocate
https://mastodon.social/@lufthans

No video of the event yet, sorry!

There's always a small database somewhere that gets pushed to system administrators without DBA support. Learn some basic skills for maintaining that database. The same skills will help in the middle-ground between sysadmin and DBA.

MySQL is ubiquitous. It will be for many years. A little knowledge will go a long way to having a good MySQL setup. A little knowledge will also leverage your command line knowledge when working with MySQL.

Use shell tools to change the MySQL prompt, run the same query on multiple systems, enable passwordless connection, munge query results and backup/restore databases.

Restorals are paramount, but you can't just backup the database files. Learn about a few useful MySQL backup tools from a system administrator's perspective.

MySQL has grants for controlling access to specific databases, but general system administration tools can be used in addition to the MySQL grants.

It's obvious that the slow query log can be useful for finding long-running queries, but it's not the only place to find useful log information.

The presentation will also cover OS and MySQL changes for good practices that will help the system administrator use and administer MySQL without having to become a DBA.

Date:
2016 November 12 - 16:30
Duration:
1 h
Room:
Room 3184
Conference:
Seattle GNU/Linux Conference 2016
Language:
Track:
Difficulty:
Medium

Happening at the same time:

  1. Technology Overload: How makerspaces and libraries can save classrooms from pervasive tech run amok
  2. Start Time:
    2016 November 12 16:30

    Room:
    Room 3180

  3. i3-wm: Tiling never felt so good
  4. Start Time:
    2016 November 12 16:30

    Room:
    Room 3178

  5. Free Software Foundation: Volunteer Empire
  6. Start Time:
    2016 November 12 16:30

    Room:
    Room 3179

  7. Servo's Infrastructure: Building Tomorrow's Browser Engine
  8. Start Time:
    2016 November 12 16:30

    Room:
    Room 3183