Here’s the recording!

Heyo!

Now that we’ve gone through the Percona Live MySQL Conference and Expo review and had an amazing turnout to talk about it, it’s time to open up the discussion around things that DBAs want to talk about and need to be conscientious of. Join us on Wednesday at 12:00pm PDT (19:00 GMT) to take part in the discussion and share your knowledge and experience with the following topics:

• Filesystems and MySQL — Which do you use and why?
  • Do you handle I/O alignment? How do you do it?
  • Scheduler changes?
• Nagios checks! — Any new checks you’ve added recently?
• The worst settings in MySQL that you always change
• What are the most important variables to you,

Hey everybody!

The Percona Live MySQL Conference and Expo just wrapped up last week and we’re looking to get some conference in review talk from everyone! Talk about your favorite sessions, new things you learned, and your overall opinion of the conference!

Hop online Wednesday at 12:00pm PDT (19:00 GMT) to join the discussion and share your experience from the 2013 Percona Live: MySQL Conference and Expo.

Be sure to watch this twitter search or this blog post get a link for the google hangout tomorrow!

Some talks that were specifically called out:

• Monitoring MySQL with OpenTSDB by Geoffrey Anderson

Annnnnd here’s the recording:

Hey all!

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!

See y’all on Wednesday!

Hi everyone!

Here’s a video of this week’s #DBHangOps:

March 27th at 12:00pm PDT (19:00 GMT) is when the next #DBHangOps is gonna go down. Check out the twitter search and hop on the google hangout to contribute some discussion! This week’s topics are:

• MySQL and puppet
  • Sheeri Cabral shared a pastebin of a puppet manifest used at Mozilla: http://scabral.pastebin.mozilla.org/2251358
• MySQL “Gotchas” (round 2)
  • MySQL Bug on predicate deadlocks due to locking non-existent rows
• A shoutout for NWCNA 2013 from Sheeri. Submit papers and check it out!

Here’s the recording!

Heyo!

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:

• Monitoring
  • 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)
• MySQL 5.6

See all of ya on the google hangout!

EDIT: Video from today’s #DBHangOps!

Hey there peeps!

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?)
  • rolling restarts and upgrades
  • Performing checksums on your data
    $ /usr/bin/pt-table-checksum \
--quiet \
--ignore-databases=mysql,percona,information_schema,per
formance_schema \
--lock-wait-time=50 \
--chunk-size-limit=0 \
--no-check-plan \
--no-check-binlog-format \
--max-lag=1 \
--replicate percona.checksums \
h=database.example.com










    

UPDATE: Here’s the recording, enjoy!

Hello everybody!

#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
* Plugins
** 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

Update: Recording!

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.

Check back on this blog post tomorrow or check this twitter search to grab the link to join the Google Hangout.

Topics for this weeks hangout include:
* triggers: maintenance, problems, etc.
* Oracle MySQL utilities (similar to Percona toolkit)
** Slideshow of MySQL utilities
* Database caching and cache

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.

We look forward to talking with you!