New York, New York
Scalability & Web Operations Expert. Specializing in MySQL & EC2 Migrations, Disaster Recovery, Agile Deployments, and Database Performance.
Areas of Expertise:
- Web Scalability
- EC2 Migrations
- MySQL Migrations
- Cloud Scalability
- MySQL Performance
- High Availability
- Disaster Recovery
- Database Management
- SQL Tuning
- NoSQL
- Drupal
- PHP
- LAMP Stack Optimization
- consulting
- speaking
- programming
- training
- writing
|
|
Sean blogs at:
http://www.iheavy.com/blog/
My DIY Disqus hack for blog discovery
May 16 2013
Read the original article at My DIY Disqus hack for blog discoveryI discovered disqus about a year ago while enjoying one of my favorite blogs, Fred Wilson’s AVC. Believe it or not for a while I had it installed on my wordpress blog and thought it was pronouced DISK-OUS. Join… read moreNYC Tech Firms Are Hiring – Map
May 09 2013
Read the original article at NYC Tech Firms Are Hiring – MapIf you haven’t noticed how much the NYC tech scene has grown recently, I’m afraid you’ve been hiding under a rock. It’s simply incredible. Take a look at Mapped In NY a google maps mashup of the growing list… read moreA Pagerank of 5 Is Possible – Here’s How
May 07 2013
Read the original article at A Pagerank of 5 Is Possible – Here’s HowJoin 4500 others and follow Sean Hull on twitter @hullsean. A highly trafficked website is a valuable asset indeed. For a services business it helps you build reputation and reach prospects. Here’s how to get there. 1.… read moreMake MySQL clustering work for you
April 30 2013
Read the original article at Make MySQL clustering work for youWe’ve told you all about MySQL mult-master replication’s limitations. If you write to two masters it is bound to fail for myriad reasons. Now what? Do what the pros do that’s what. A. Don’t write to both masters Using multi-master… read moreMake MySQL clustering work for you
April 30 2013
Read the original article at Make MySQL clustering work for youWe’ve told you all about MySQL mult-master replication’s limitations. If you write to two masters it is bound to fail for myriad reasons. Now what? Do what the pros do that’s what. A. Don’t write to both masters Using multi-master… read moreSales sucks, but then I learned
April 29 2013
Read the original article at Sales sucks, but then I learnedAre you a developer or startup entrepreneur? Have you ever been frustrated with some of the claims made by the sales team or lacked the patience or ability to communicate across departments? Join 4000 others and follow Sean Hull on… read moreDinner, dollars & devlishly creative thinking
April 29 2013
Read the original article at Dinner, dollars & devlishly creative thinkingEfficiency at Dinner? I just finished reading Tyler Cowen’s opus, An Economist Gets Lunch. I have to admit I’m already a fan of his writing, getting a daily dose on from his blog Marginal Revolution. Join 4000 others and follow… read moreSales sucks, but then I learned
April 29 2013
Read the original article at Sales sucks, but then I learnedAre you a developer or startup entrepreneur? Have you ever been frustrated with some of the claims made by the sales team or lacked the patience or ability to communicate across departments? Join 4000 others and follow Sean Hull on… read moreDinner, dollars & devlishly creative thinking
April 29 2013
Read the original article at Dinner, dollars & devlishly creative thinkingEfficiency at Dinner? I just finished reading Tyler Cowen’s opus, An Economist Gets Lunch. I have to admit I’m already a fan of his writing, getting a daily dose on from his blog Marginal Revolution. Join 4000 others and follow… read moreNo tools to reconcile MySQL with two masters
April 18 2013
Read the original article at No tools to reconcile MySQL with two mastersHere’s the last nail in the coffin. We hope this convinces you not to write to multiple masters with MySQL replication. Reason 10 – No tools to reconcile inconsistent masters For all the endless reasons we’ve already outlined… read moreTemp tables can break replication
April 18 2013
Read the original article at Temp tables can break replicationIf you’re not convinced yet that writing to dual masters is a bad idea, we have a couple more reasons. 9. Temp tables break replication after restart MySQL’s replication is sensitive to temporary tables. You shouldn’t use them. If your queries… read moreCrashed nodes corrupt your MySQL cluster
April 18 2013
Read the original article at Crashed nodes corrupt your MySQL clusterWriting to two masters is like walking around with a loaded shotgun. Eventually one of your instances will fail and when it does, replications position & synchronization information could easily become corrupt! Reason 8 – Crashed nodes cause big problems… read moreTransaction isolation breaks when writing two masters
April 18 2013
Read the original article at Transaction isolation breaks when writing two mastersContinuing our discussion of multi-master replication, we hit on five more reasons why writing to two masters aka active-active replication is very dangerous. Click through to the end for multi-master solutions that work with MySQL. Reason 6 – You… read moreActive-active replication reduces operational flexibility
April 18 2013
Read the original article at Active-active replication reduces operational flexibilityAmong the myriad data integrity and corruption risks associated with active-active replication, you also lose out on configurability and operational flexibility. Reason 7 – Can’t add nodes easily The often touted solution to use auto_increment_increment and auto_increment_offset fixes you to a… read moreHow to make MySQL multi-master work for you
April 16 2013
Read the original article at How to make MySQL multi-master work for youComing soon! Want more? Grab our Scalable Startups monthly for more tips and special content. Here’s a sample Related posts:Transaction isolation breaks when writing two masters MySQL requires an authoritative master to build slaves MySQL needs single master… read moreMySQL needs single master to check data integrity
April 16 2013
Read the original article at MySQL needs single master to check data integrityMySQL slaves can drift out of sync. Many of our clients are surprised to find some data differences in their replication topology, once we do some checking and sniffing around. Such checks require a single reliable or authoritative… read moreMySQL requires an authoritative master to build slaves
April 16 2013
Read the original article at MySQL requires an authoritative master to build slavesIn MySQL database operations, you often need to rebuild slaves. They fail for a lot of different reasons, fall out of sync or crash. When this happens you may find you need to reclone and start fresh. This… read moreLimitations of MySQL row-based replication
April 16 2013
Read the original article at Limitations of MySQL row-based replicationMySQL offers a few different options for how you perform replication. Statement-based has been around a lot longer, and though it has some troublesome characteristics they’re known well and can be managed. What’s more it supports online schema changes with multi-master… read more10 reaons active-active is hard and how to solve it
April 16 2013
Read the original article at 10 reaons active-active is hard and how to solve itMulti-master replication provides redundant copies of your most important business assets. What’s more it allows applications to scale out, which is perfect for cloud hosting solutions like Amazon Web Services. But when you decide you need… read moreWhy does MySQL replication fail?
April 16 2013
Read the original article at Why does MySQL replication fail?When considering active-active multi-master, you must consider it’s foundation technology. Although MySQL replication is straightforward to setup, it can fail in a myriad of ways. Most of those are known and well understood. We can solve them only if we use… read moreApril 08 2013
Read the original article at Don’t Miss Percona Live 2013The biggest event on the MySQL calendar is the yearly Percona Live and it’s just around the corner. This year you’ll be able to pick from a whopping 110 technical sessions by 90 different speakers from companies like Facebook, Amazon, Google… read moreWhen You Have to Take the Fall
April 01 2013
Read the original article at When You Have to Take the FallAlso find Sean Hull’s ramblings on twitter @hullsean. One of the biggest jobs in operations is monitoring. There are so many servers, databases, webservers, search servers, backup servers. Each has lots of moving parts, lots that can go wrong.… read moreApril 01 2013
Read the original article at Ken Auletta Gets Us GoogledAlso find Sean Hull’s ramblings on twitter @hullsean. The title sounds vaguely fatalistic, the end of the world is nigh, that kind of thing. It turns out though that Auletta is a journalist having reported over the years a lot on… read moreWhen You’re Hired to Solve a People Problem
March 05 2013
Read the original article at When You’re Hired to Solve a People ProblemAlso find Sean Hull’s ramblings on twitter @hullsean. A good five years ago I worked for a firm in online education. Among various products they provided through their website, they were struggling with a process to get content… read moreSwitch to the cloud – shift of a century
March 03 2013
Read the original article at Switch to the cloud – shift of a centuryThe switch to cloud is way bigger than you think A Review of Nicholas Carr’s book “The Big Switch”, available on Amazon here. Also find Sean Hull’s ramblings on twitter @hullsean. Do you work in devops or… read moreWhen Clients Don’t Pay – Consulting War Stories
February 07 2013
Read the original article at When Clients Don’t Pay – Consulting War StoriesAlso find Sean Hull’s ramblings on twitter @hullsean. It’s a cold cold winter out there, so as they say you need money to keep the lights on? Yep, that’s true whether you’re a small business or a consultant.… read moreFear a zombie invasion? Try algorithms & bots
February 01 2013
Read the original article at Fear a zombie invasion? Try algorithms & botsAlso find Sean Hull’s ramblings on twitter @hullsean. Have you read any of those tongue in cheek books on how to survive the coming zombie apocalypse? They’re funny in their own way, and reading Chris Steiner’s book it… read moreWebcast: MySQL Upgrades With No Downtime
July 27, 2010
Duration: Approximately 60 minutes. Cost: Free In this webcast we'll discuss a two-node MySQL multi-master replication setup. We'll take the audience step-by-step through the process, and then uses MMM (MySQL Multi-master Manager) to manage &...
Webcast - DRBD and MySQL - An HA Match Made In Heaven
January 19, 2010
Duration: Approximately 60 minutes. Cost: Free DRBD has grown in popularity as an excellent low-cost high availability solution for MySQL. It provides synchronous replication of your data without MySQL having to worry too much about the details. ...
Webcast - Hands-on: Step-by-step MySQL Clustering Setup
August 04, 2009
Duration: Approximately 60 minutes. Preview Video: Free Full Video: Available on Safari Books Online MySQL's Clustering solution provides some pretty sophisticated functionality. In this webcast we'll take you through getting it up and running on...
Webcast - MySQL Replication: Audit, Test, & Verify
January 22, 2009
Duration: Approximately 60 minutes. Cost: Free Audience: MySQL DBAs and developers MySQL replication is fairly easy to set up, but in the real world many obstacles can get in the way of keeping it up and running smoothly. One problem that seems ...
Also find Sean on:
Recent Twitter posts:
Buy Now and Save
Use discount code: OPC10
All orders over $29.95 qualify for free shipping within the US. See details.
