Skip to content

Instantly share code, notes, and snippets.

zmagg zmagg

Block or report user

Report or block zmagg

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@zmagg
zmagg / gist:b87db1437324c3c78757
Created Feb 23, 2016
download the tarheeltimes
View gist:b87db1437324c3c78757
for i in {1990..2016}
> do
> wget "http://www.tarheeltimes.com/schedulebasketball-$i.aspx"
> done
@zmagg
zmagg / 0201.md
Last active Feb 11, 2016
food diary, february. eating vegan, started february 2nd.
View 0201.md
  • 1 egg, scrambled
  • 2 tomatoes fried lightly in a cast iron, with vinegar, and some chard & broccolini pieces
  • 1 white bass fish fillet (1/4 fish), panfried with panko bread coating
  • 9 oysters: fanny bay, kushu, kunamato (bc when possible, wa otherwise)
  • 1/4 lb of shrimp in butter and garlic, serious eats style
  • 1 espresso, 1 coffee
  • handful of dried cherries
  • half a backlava
  • half a pastel de nata
  • quarter bottle unoaked chardonnay
@zmagg
zmagg / gist:f82ed07c119ce5b09e86
Created Dec 19, 2015
kindle books i read this year
View gist:f82ed07c119ce5b09e86
"Broken Angels (Takeshi Kovacs, #2)",Richard K. Morgan
"Woken Furies (Takeshi Kovacs, #3)",Richard K. Morgan
Thus Was Adonis Murdered,Sarah Caudwell,"Caudwell
"The Steel Remains (A Land Fit for Heroes, #1)",Richard K. Morgan
Collected Poems,Philip Larkin,"Larkin
"Shards of Honour (Vorkosigan Saga, #1)",Lois McMaster Bujold
"The Warrior's Apprentice (Vorkosigan Saga, #2)",Lois McMaster Bujold
"Barrayar (Vorkosigan Saga, #7)",Lois McMaster Bujold
"The Vor Game (Vorkosigan Saga, #6)",Lois McMaster Bujold
Cetaganda (Vorkosigan Saga),Lois McMaster Bujold,"Bujold
View gist:e6abf2029a921978a3af
@asiahoe + @amelielamont + @tcburning + @izzyoji + @cattsmall
@argoncobalt + @jaclynejimenez + @JFriedhoff + @carolinesinders!
@Adellelin and @sodevious
@courteneyervin, @saronyitbarek, @cattsmall, & members of @wscnewyorkcity
@snarkbat
@dtwps
@brindelle
@Murielleu
@marycutrali!
@mellowbeing
@zmagg
zmagg / gist:c514481e0515d1cb70bc
Last active Dec 10, 2015
packing list for sf & nc
View gist:c514481e0515d1cb70bc
in sf for 5 days
in nc for 11 days
outliers, jeans
X pairs of socks
party dress
tights
sports bra
running shoes
socks for running shoes
View gist:68b1e551a8134967fa35
a few days in ashland watching plays then hiking! maybe around an oregon singing!
@zmagg
zmagg / gist:ea26038d2b1227141bdc
Created Nov 27, 2015
zmagg's carnitas recipe
View gist:ea26038d2b1227141bdc
I sort of cobble together http://smittenkitchen.com/blog/2011/11/homesick-texan-carnitas/ with http://www.seriouseats.com/2010/07/the-food-lab-how-to-make-crisp-and-juicy-carnitas-without-a-bucket-of-lard.html.
Spices:
Half an orange, juiced.
Orange zest from half an orange.
Lime, cut in halves.
one stick cinnamon, in halves.
teaspoon Arizona Dreaming by Penzeys.
two dried chipotles
teaspoon coriander
@zmagg
zmagg / gist:10e2bcd383ae286dbe7e
Last active Jan 3, 2016
political theory reading, zmagg's list
View gist:10e2bcd383ae286dbe7e
nationalism & identity:
american foreign policy and its thinkers - perry anderson
Listening to Grasshoppers: Field Notes on Democracy. - arundathi roy
imagined communities -benedict anderson
Reproducing the State, Jacqueline Stevens
imperalism, arendt
general political theory:
18th brumaire, marx
@zmagg
zmagg / gist:133c4febd84dbab394af
Last active Oct 24, 2015
packing list for amsterdam, portugal
View gist:133c4febd84dbab394af
backpack
waterproof interior bag (i don't really need it, but maybe someone i'm traveling with will like it? also laundry)
raincoat
3 t-shirts
3 pairs of underwear (lol)
2 pairs of wool socks
2 pairs of cotton socks
one heavyish wool sweater (purple)
one light merino sweater (black)
one merino liner layer thin long sleeved (black)
View gist:e7307ea2adf6cd510e95

Etsy started with a monolithic Postgres database and moved to a horizontally sharded MySQL store with a lookup table and master-master replication. Scaling your data store is never easy as just adding more hardware though, even with sharding.

In this talk, we'll go over the pains and perils of sharding databases and how we solved some of the problems in Etsy's second take on sharding, what we call logical sharding. Logical sharding is where we put several databases on one mysqld, as opposed to one database per server. Upon hitting a resource limit on a box (CPU, Memory, Connections, etc) that would normally require individual row migration, we can instead do file level migrations of a database, replicate, then drop previous databases, which is super fast and a cleaner way to delete old unnecessary shard data. We'll also go over how logical sharding benefits other daily operational challenges like schema changes and backups, as well as simplies life for developers and makes life easier for downstream data wa

You can’t perform that action at this time.