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 …

On November 15th at 1PM Eastern / 10 AM Pacific, I will be giving a webinar entitled “The Hazards of Multi-writing in a Dual-Master Setup“.  In my experience many people do not understand the difficulty of managing writes to RDBMS datastores in a high availability environment, especially where asynchronous replication is used (which is almost everywhere).

This talk gives an overview and concrete examples of how writing across dual-masters can and will break your assumptions about ACID compliance, how you can work around it, and some alternative solutions that are on the market today that attempt to address this problem.  This will be a great session for DBAs just getting into this problem space, are moving from hot-cold …

It certainly has been a tough week on the East Coast. In the Boston area, where I am located, we got grazed by Sandy – power outages, trees down, schools closed, and Halloween delayed. This though, pales in comparison to what our NY office had to endure. One of our co-founders for example is one of the first few to get his power back at his home on Long Island just yesterday. He considers himself lucky – one of the several pine trees that came down on his property was just a few degrees off from destroying his house (it ended up taking down the gutter instead). Needless to say, it’s going to be a long recovery for NY and NJ. If you are looking to help, see here.

Of course, NYC is known for its resiliency. The first post-Sandy event at Manhattan’s Javitis Conference Center,  …

This week we continue part 3 of the Operations Report Card and how it relates to database administration. This week we talk about the section on "Operational Practices", and it covers how operations are run. In Ear Candy we present different tools for finding a machine's external IP address, and in At the Movies we present a video about MySQL Security from when Sheeri was touring Latin America in July.

Feedback
Webyog's blog noted that the OurSQL blog/podcast was among the Top MySQL Blogs You Should Be …