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!

Wednesday, 11/28 @ 10 am PT/ 1 pm ET Register at http://www.percona.com/webinars/industrial-strength-mysql-applications-using-percona-and-continuent

MySQL is the first choice for a large majority of web applications thanks to its ease of use and low cost of operation. However, running big apps on MySQL is still a challenge even for experts. In this webinar we will show you how to combine

First I wanted to thanks all the attendees and for the nice comments I got.
As promised during the webinar, these are the answers of the questions you asked.

Q: Does Percona provide plugin for cacti?

A: Yes we do. They are part of Percona Monitoring Plugins. You can see some examples here.

Q: What if replication is running legging on production?

A: The point when I say that you don’t want to receive alerts if replication is lagging on a slave used for backup for example is to explain that with alerting solutions, you need to filter the alerts. You need to reduce them to the minimum possible alerts that are critical for your production. …

Why are sets 4X to 9X faster? If it is because the SQL writes are auto-commit and the memcache sets are doing a background commit every 5 seconds then this is a very misleading comparison.

Read the original article at Crisis Management in the Crosshairs – Sandy

Crisis Management During Sandy

The news this past week has brought endless images of devastation. All metropolitan region, the damage is apparent.

More than once in conversation I’ve commented “That’s similar to what I do.” The response is often one of confusion. So I go on to clarify. Web operations is every bit about disaster recovery and crisis management in the datacenter. If you saw Con Edison down in the trenches you might not know how that power gets to your building, or what all those pipes down there do, but you know when it’s out! You know when something is out of order.

That’s why …

As the end of the year 2012 is less than two months away, enterprise decision makers are evaluating year-end moves that can help step up in 2013 with a strong start. It’s no secret that year-end strategies have a significant impact on what enterprises want to achieve in the next year. A new IT investment is central to scale-up your sustainable solutions; focusing on Open Source solutions can be a competitive differentiator for IT departments. Given the current trend, Open Source software’s customization ability, scalability and stability are a major attraction amongst enterprises.However, one factor that enterprises strive for is Innovation, while improving operational efficiency and decreasing costs.  In fact, enterprises consider innovation a major engine to boost productivity and gain a competitive edge.  In terms of innovation, cost and quality, Open Source Software checks all these boxes, emphatically. In almost every …

For those who missed the live event, the recording of the "How to Add Policy-Based Auditing to your MySQL Applications" webinar is now available.  You can view it here.

This presentation builds on my earlier blog post on MySQL Enterprise Audit that was announced at MySQL Connect in late September.  The web presentation expands on the introductory blog and covers:

• The regulatory problem to be solved (internal audit, PCI, Sarbanes-Oxley, HIPAA, others)
  
• MySQL Audit solutions for both Community and Enterprise users:
  • General Log - use the basic features of the MySQL server
    
  • MySQL 5.5 open audit API - or use your time and talent to build your own …

December 6th @ 10 am PT/1pm ET Learn more at http://bit.ly/U51cM5   Tungsten Replicator is a popular replacement for MySQL replication. With new 2.0.6 release, it has now become a mature and robust product, with an easy-to-use installer. While installing a simple master/slave topology was made as easy as it could possibly be, installing complex topologies was still a matter for advanced users

We devoted the Palomino Newsletter this month to the important topic of disaster recovery, in light of the challenges posed by Hurricane Sandy. If you're not already receiving our newsletter, you can subscribe here.

Hurricane Sandy has been on many people's minds of late; mine not least.  Having lived the last 4 years of my life in Manhattan and on the Jersey Shore, the loss of lives, the destruction of homes, business and memories, and the disruption of so much has me in shock.  I grew up in Louisiana, and hurricanes were a way of life.  You didn't do something hoping that a hurricane would not come by.  You assumed a hurricane would come.  At least, that's how I was taught.  That's the mentality I try to bring into my architectures, my process and my planning as well.  So, when hurricane Sandy …

We devoted the Palomino Newsletter this month to the important topic of disaster recovery, in light of the challenges posed by Hurricane Sandy. If you're not already receiving our newsletter, you can subscribe here.

Hurricane Sandy has been on many people's minds of late; mine not least.  Having lived the last 4 years of my life in Manhattan and on the Jersey Shore, the loss of lives, the destruction of homes, business and memories, and the disruption of so much has me in shock.  I grew up in Louisiana, and hurricanes were a way of life.  You didn't do something hoping that a hurricane would not come by.  You assumed a hurricane would come.  At least, that's how I was taught.  That's the mentality I try to bring into my architectures, my process and my planning as well.  So, when hurricane Sandy …