Shell Scripting for MySQL Administration: An Introduction
This presentation, aimed at a beginning MySQL DBA with little shell scripting experience, is given in three sections: Bash shell introduction, MySQL interface methods, and practical examples.
The Bash Shell is covered in enough detail to let the viewer understand the rest of the presentation and compose scripts of their own. Topics include:- Variables
- Parameters
- Special Bash Built-In Variables
- Tests
- Flow Control
- File Redirection
- Common Utilities such as hostname, tr, cut, ls, read, nail, sed, etc.
- Mysql command-line parameters as applied to scripts
- Techniques for retrieving a single data value
- Techniques for iterating through a whole result set
- Techniques for moving data around, under script control
- Best practices for security (when calling MySQL)
- Monitoring database status variables
- Monitoring/controlling replication
- Monitoring performance
- Alarming and alarm emails/pages
- Controlling backup
- Monitoring environment metrics such as disk space
People planning to attend this session also want to see:
Bob Burgess
Radian6 Technologies
Bob has been squeezing every drop out of MySQL for a little over a year, having previously spent several years roaming in the Garden of Oracle. Last year, he found himself suddenly (and without warning) responsible for storing and retrieving all the information amassed at Radian6, the social media monitoring company.
Comments on this page are now closed.
Co-presented By:
Sponsorship Opportunities
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com
Download the MySQL Sponsor/Exhibitor Prospectus
Media Partner Opportunities
Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com
Press and Media
For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com
MySQL Conference Newsletter
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.
Contact Us
View a complete list of MySQL contacts.
O'Reilly Home | Privacy Policy | Contact Us | Sitemap | conf-webmaster@oreilly.com
Event Software Powered by Expectnation
© 2009, O'Reilly Media, Inc. | (707) 827-7000 / (800) 998-9938
Comments
Hi. The slides are now available for download via the Presentation link.
Hi Bob, i found your presentation very interesting and helpful in administering mysql. Could you please post your slides and the scripts for us to look at them one more time? thanks,
Hi Bob,
Appreciated your presentation. I write related scripts; always thought I did this in a pre-historic fashion. (Linux/Cygwin Scripting) A lot of what you referred to related to somthings I do. You had a few I can tweak with though! Was looking for your slides. Please let me know if you posted somewhere, as I cannot find them from your links herein. Thanks
Yes, but apparently nail is called mailx now as well. Folks who already have Heirloom mailx don’t need to get nail. Of course, folks who have another mailx may get confused. Perhaps it would be worth mentioning on your slides.
Yes, mailx works well for sending email without attachments from the currently-logged-in user (often “root”). Nail is useful when you want to attach files (such as reports or large logs) and send “from” another user (ie. “monitor” instead of “root”).
Folks looking for the nail command might wish to alias mailx instead.
Thanks to everyone who attended. The slides will be available here (today or tomorrow) and also at www.radian6.com/mysql in a few days. A few days after that, I’ll have full example bash scripts available there also.