Check out the video!
Hey there everybody!

Coming up this Wednesday, September 4th, 2013 at 12:00pm pacific (19:00 GMT) take part in #DBHangOps to discuss:

• Data Dictionary Corruption
  • What is it?
  • How does it happen?
  • How did you fix it?
  • What about FRM file corruption?
• MySQL Utilities (requested by Sheeri Cabral!)
  • mysqlfrm — http://dev.mysql.com/doc/workbench/en/mysqlfrm.html
    • Read about it at Chuck Bell’s blog http://drcharlesbell.blogspot.com/2013/04/mysql-utilities-new-frm-reader-utility.html
    …

Hey all!

Coming up this Wednesday, August 21st, 2013 at 12:00pm pacific (19:00 GMT) join in to talk about:

• Gerry from Tokutek to talk about B-Tree indexes in InnoDB and fractal indexes TokuDB!
• Schema Versioning
  • How do you manage schema versions in your development pipeline?
  • How are your schema changes deployed? Is it automated?
  • Some automated schema management tools:
    • South — http://south.aeracode.org/ — a DJango (python) friendly migration tool
    • Flyway — http://flywaydb.org/ — A database migration framework for java
    • Liquibase — …

Issue – the OpenStack instances hostnames are not resolved at the moment by their floating IPs.

Fast solution – use PowerDNS
Short story:
1. Boot an instance , assign it a floating IP, open tcp ports 22 8001 and udp port 53.
2. Install PowerDNS, the particular yum package is named pdns.
3. install the mysql backend for PowerDNS, its available as yum package as well.
4. Install MariaDB , set the proper configuration, the initialize it at the default location.
5. Set the pdns user, create the pdns database and create the tables needed.
6. Configure the pdns service to use the gmysql backend.
7. Create and user at the OpenStack MySQL able to connect from the floating IP subnet.
8. Grant that user select permissions on all nova.* tables.
9. At the PowerDNS instance, set simple python / php / bash script to query the nova database and to inject the hostnames and the …

And all set. Check out the recording:

Hello everybody!

Coming up this Wednesday, July 23rd, 2013 at 12:00pm pacific (19:00 GMT) join in to hear:

• Brandon Johnson from Mozilla talk about an issue he recently worked through with XtraBackup and the process he took to identify and resolve the issues.

And also take part in discussion around:

• How do you apply production schema changes?
  • Do you use pt-online-schema-change?
    • Issues to watch out for
  • Just run the alter!
  • Pull from a pool and apply

Make sure to follow the #DBHangops twitter search, the DBHangops Twitter Feed, or this blog …

All set, here’s the recording!

Hey there everyone!

Another informative and fun-filled #DBHangOps coming up this Wednesday, July 10th, 2013 at 12:00pm pacific (19:00 GMT). Join the discussion and contribute your experience on the following topics!

• Plugins for MySQL
  • Which do you use?
  • Are there plugins that you want?
• Kernel Parameters in Linux for MySQL, specifically:
  • Linux VM settings
  • Transparent Huge Pages
• InnoDB buffer pool size and settings
  • What works in your environment and why?
• And If there’s time, information about the TokuDB storage engine in …

Join 7500 others and follow Sean Hull on twitter @hullsean.

There’s a lot of talk on the web about scalability. Making web applications scale is not easy. The modern web architecture has so many moving parts. How can we grapple with the underlying problem?

Also: Why Are MySQL DBAs So Hard to Find?

The LAMP stack scales well

The truth that is half right. True there are a lot of moving parts, and a lot to setup. The internet stack made up of Linux, Apache, MySQL & PHP. LAMP as it’s called, was built to be resilient, dynamic, and scalable. It’s essentially why Amazon works. Why what they’re doing is possible. Windows & .NET …

#DBHangOps for 6/26/13 is all done! Check out the recording below:

Hey everybody!

#DBHangOps is back this week at a slightly earlier time this Wednesday, June 26th, 2013 at 11:00am paciifc (18:00 GMT) . We’ll have special guest Shlomi Noach talking about the open source tools he’s developed to improve a DBA’s day-to-day work.

Be sure to check out the #DBHangops twitter search, the DBHangops Twitter Feed, or this blog post to get a link for the google hangout on Wednesday!

Thanks and see all of you there!

It's my great pleasure to announce the release of mylvmbackup version 0.14.

This release includes a large number of improvements, code cleanups, and new functionality.

I would like to thank Ask Bjørn Hansen, Ben Bonnel, Norbert Tretkowski, Neil Wilson, Klaus Ethgen and Alexandre Anriot for their feedback and contributions to this release.

The release is available as a source tarball and generic RPM package. Packages for other distributions are available from the openSUSE Build Service.

Some notable highlights from the …

Annnd all set! Check out the recording for the topics below:

Hello everyone!

We missed out on the last meeting time for #DBHangOps due to some conflicts, but we’re looking to come back strong this Wednesday, June 12th 2013 at 12:00pm pacific (19:00 GMT). Come join the discussion and contribute your experience on:

• Upgrading to MySQL 5.6
  • Any issues or gotchas?
• MySQL Python Utilities
  • How do you use them?
• MySQL patches
  • Patches you use
  • Patches you want
• Interesting or valuable Linux kernel settings

Be sure to check out the #DBHangops twitter search, the DBHangops Twitter …

A fascinating post-mortem on high profile network failures:

This post is meant as a reference point–to illustrate that, according to a wide range of accounts, partitions occur in many real-world environments. Processes, servers, NICs, switches, local and wide area networks can all fail, and the resulting economic consequences are real. Network outages can suddenly arise in systems that are stable for months at a time, during routine upgrades, or as a result of emergency maintenance. The consequences of these outages range from increased latency and temporary unavailability to inconsistency, corruption, and data loss. Split-brain is not an academic concern: it happens to all kinds of systems–sometimes for days on end. Partitions deserve serious consideration.