TechOpsGuys.com Diggin' technology every day

November 6, 2012

Off to Seattle again Nov 15th – 26th

Filed under: General — Tags: — Nate @ 8:39 am

Woohoo – going to head back up to the Seattle area to visit friends and my favorite hangouts. I am driving again of course – hoping to leave the Bay Area around 5AM on November 15th, go up to the Crescent City, CA area, and refresh my pictures of the California and Oregon coastline with the new camera I bought earlier in the year (42X optical zoom!!). Stay the night in Vancouver, WA(expecting about ~16 hours of driving total for the day), before heading up to Seattle (well Bellevue) on Friday, November 16th which is my b-day.

Party as hard as I can while I am there before heading back on November 26th, just in time for my Jury Duty on November 27th(just found out about that a couple of weeks ago).

If that wasn’t enough driving – I’m driving down to Orange County on Friday night (returning on Sunday) for my sister’s baby shower. This was more last minute, as I told her I’d go down there for the baby shower or Thanksgiving but not both. Since Thanksgiving moved to a week earlier than I expected this year it turns out I wasn’t going to be able to make it down there this time around so I’m going for her little party instead.

I walk to work most of the time(0.9 miles away from home) so I hardly put any miles on my car, but I make up for it with these road trips!  Though one of my co-workers says his car is only 11 months old and he already has 27,000 miles on it!! (mostly from commuting which is 70-90 minutes each way). I have almost 22,000 miles on my car and I bought it about 21 months ago.

Hazards of Multi Master MySQL Webinar

Filed under: Events — Tags: — Nate @ 8:27 am

Stupid me, here I was thinking if you run MySQL in multi master mode it should not have issues with writes coming in to multiple locations. I’ve never heard of any issues(at the same time it’s been a while since I’ve heard anyone talk about running multi master MySQL themselves), but apparently there are some as this guy is indicating, he has a webinar about it on November 15th. It sounds interesting to me, though I’ll be on the road that day so won’t be able to listen in, hopefully he posts the data afterwards.

At my current organization we do have multi master MySQL though we have yet to run them active-active (with writes going to both) for more than a short period at a time (usually just during fail-over events – “oh my god MySQL is about to crash fail over!”). The load balancing is handled by our Netscalers and their MySQL-aware load balancing.  Overall the load is low enough(avg under 10% CPU and avg 75 write IOPS/DB – all reads being served from RAM)  that I don’t think it’d provide any performance benefit to us anyway.

From the MySQL performance blog post

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 architectures to hot-warm or even hot-hot, and even for developers to get a sense of the difficultly of this problem.

 

 

Powered by WordPress