The Percona Live MySQL Conference and Expo is coming up in 2 weeks, meaning the last of preparations are under way. In the meantime, #DBHangOps is coming your way on Wednesday at 12:00pm PDT (19:00 GMT) with:
Talk about Performance Schema from Mark Leith
Some discussion on how people use and manage MySQL slow query logs in their environments
Filesystems and MySQL — which do you use, why, and how
What you’re excited about at Percona Live!
As always, hit up this twitter search or this blog post to grab the google hangout link to join!
March 13th at 12:00pm PDT (19:00 GMT) is the time to check in and hop online for #DBHangOps this week. Keep an ever watchful eye on the twitter search and hop on the google hangout to contribute some discussion! This week’s topics are:
What do you consider to be “standard” nagios checks for MySQL
Demos of Anemometer and MySQL Enterprise Monitor
Daily pain MySQL Bugs and Gotchas (e.g. show table status being cached)
February 27th at 12:00pm PST it is! Check back here for more info and keep a watchful eye on the twitter search (and feel free to join the conversation!). The topics we’re looking to cover this week are:
Day-to-day pain points (what takes more time than it should?)
Looking forward to seeing all of you DBAs on the google hangout! 🙂
Got a fun #DBHangOps planned for this week, Wednesday 02/13/12 at 12:00pm PST. Be sure to hit up this blog post tomorrow or check this twitter search to grab the link to join the Google Hangout. Looking to bump this to either February 20th or February 27th.
#DBHangOps coming at you this week, Wednesday 1/30/12 at 12:00pm PST. Be sure to check out this blog post tomorrow or check this twitter search to grab the link to join the Google Hangout.
This week’s topics were:
* bug fixes in recent versions
** authorization plugins (e.g. LDAP)
** audit plugin API — http://dev.mysql.com/doc/refman/5.5/en/writing-audit-plugins.html
*** state transitions of records in MySQL with a plugin?
* InnoDB Status variables from twitter — https://github.com/twitter/mysql/wiki/InnoDB-Status-Variables
* Table alters/schema changes
** Twitter patch for non-blocking alter table (throws a different error than “lock_wait_timeout”) — https://github.com/twitter/mysql/wiki/Change-History#wiki-5.5.28.t8
** Schemanator from Etsy — http://codeascraft.etsy.com/2013/01/11/schemanator-love-child-of-deployinator-and-schema-changes/
** Online Table Alter in Oracle MySQL 5.6 — https://blogs.oracle.com/mysqlinnodb/entry/innodb_full_text_search_performance
** Twitter MySQL management tools — https://github.com/jeremycole/mysql_management_tools
* Troubleshooting queries book link — http://www.amazon.com/MySQL-Troubleshooting-What-When-Queries/dp/1449312004/ref=sr_1_1?ie=UTF8&qid=1359579540&sr=8-1&keywords=mysql+sveta+troubleshooting
Finally, the end of year madness is over and we’re in a fresh new year. That must mean it’s time to get back into #DBHangops! Tune in on Wednesday, 1/16/13 at 5:00pm PST to get in on the fun and share your experiences.
Now that the thanksgiving holiday is over, it seems like the perfect time to have another #DBHangOps. If you’re interested, check this twitter search or check back on my blog here for a link to the google hangout.
Items currently on our agenda for today:
* Data corruption!
* Monitoring — what do you monitor, why, etc.
* Query killing — do you kill queries in production regularly, or in emergencies?
* Fun or useful configurations
Looking forward to chatting about MySQL stuff today!
Fun time hitting these topics this week. Check out the recording:
Woooo, just wrapped up another night of #DBHangOps, check out the video:
For those of you who aren’t familiar with this awesome series of videos, it’s a bi-weekly meeting of MySQL DBAs via a Google Hangout to simply talk about databases (specifically MySQL). The discussions range anywhere from silly stories to awesome learnings and even little gotchas to know about when working with MySQL operationally. If you’re interested in catching when the next #DBHangops will happen, check MySQL planet for a blog post about it, or check this twitter search.
Just pushed a copy of the script I’ve been working on for a couple weeks to github. The goal of the script is to push an image file containing an operating system to Amazon’s Web Services Elastic Compute Cloud so you can run the image through Amazon’s service. A lot of the development of this was based around existing documentation and blogs written by many other posters, so I finally synthesized all this information into a “simple” BASH shell script that automates the process. Take a look at it at the following link!
So..this was an impromptu project I slapped together in about 20 minutes to extract comments out of a DOCX file. I ended up doing this because I stored answers to lab questions as comments in a DOCX and one of the graders I work with needed the comments in plain text….so I recalled the XSL for converting DOCX to LaTeX from my last post and wrote up a new stylesheet to extract comments. Hereeee it is!