MySQL for System Administrators
Blemings Labs | Sat 23 Jan 12:10 p.m.–12:25 p.m.
Presented by
-
der.hans
https://www.LuftHans.com/talks
der.hans is a technologist, Free Software advocate, parent and spouse.
Hans is chairman of the Phoenix Linux User Group (PLUG), Promotions and Outreach chair for SeaGL, BoF organizer for the Southern California Linux Expo (SCaLE) and founder of the Free Software Stammtisch. He presents regularly at large community-led conferences (SCaLE, SeaGL, LFNW, Tübix, OLF, TXLF) and many local groups.
Currently a Customer Data Engineer at Object Rocket. Public statements are not representative of $dayjob.
Mastodon - https://floss.social/@FLOX_advocate
der.hans
https://www.LuftHans.com/talks
Abstract
System administrators often need to help maintain MySQL instances. Sometimes they have databases with little or no DBA support. Learn some basic skills for maintaining MySQL databases. The same skills will help balance roles between sysadmin and DBA.
MySQL is ubiquitous and will be for many years. A little knowledge will go a long way to having a good MySQL setup. Sysadmins can leverage their command line skills when interacting with MySQL.
The presentation will cover *NIX and MySQL changes for good practices. Those skills will help sysadmins use and administer MySQL without needing to become a DBA.
Topics:
* leveraging shell skills for MySQL
* shell environment for MySQL
* authentication
* custom MySQL prompts
* MySQL backups and restorals
* choosing a database engine
* MySQL logs
* monitoring
System administrators often need to help maintain MySQL instances. Sometimes they have databases with little or no DBA support. Learn some basic skills for maintaining MySQL databases. The same skills will help balance roles between sysadmin and DBA. MySQL is ubiquitous and will be for many years. A little knowledge will go a long way to having a good MySQL setup. Sysadmins can leverage their command line skills when interacting with MySQL. The presentation will cover *NIX and MySQL changes for good practices. Those skills will help sysadmins use and administer MySQL without needing to become a DBA. Topics: * leveraging shell skills for MySQL * shell environment for MySQL * authentication * custom MySQL prompts * MySQL backups and restorals * choosing a database engine * MySQL logs * monitoring