Chris Shumake

Staff MySQL DBA @ LNR
LinkedIn:

[Chris Shumake @cvshumake]

@milosgajdos For me, it's:
* id bigint unsigned not null primary key
* created int unsigned not null
* updated int unsigned
* deleted int unsigned

Can you explain more about an updated_by? As in, user account, or something like app/version/path/method/line?

[Chris Shumake @cvshumake]

A #mysql8 gotcha: #mysql 8 does not support wildcard database names in grants if you have partial_revokes enabled; instead, wildcards are interpreted literally. Partial Revokes is enabled in #gcp #cloudsql even if you don't personally use them.
See: https://t.co/84tZyiQ1Il

[Chris Shumake @cvshumake]

My #mysql SPOF suffered an incident this fall w/out downtime: we rose from 6k daily QPS peak to a 62k QPS peak.
Two boss' (Joe, Ranjit) architectural calls kept us able to handle the load, along w/ good confs.
Also thanks to #Percona for importing the Thread Pool implementation.

[Chris Shumake @cvshumake]

I bet the DBA / SRE responsible for the #GCP #Spanner build in Europe is proud of their one-liner in the zonal downtime report.
"no evidence of any customer impact" https://t.co/Qdm5qZwLz6
Congrats.

[Chris Shumake @cvshumake]

https://t.co/Y1SEu2NvZr
Faster alters, yay! #MySQL

[Chris Shumake @cvshumake]

@bweisel @natfriedman Yeah, that makes sense. Customer-defined data structure with customer-defined queries, best approach is BigQuery or Hbase or things of the sort.

[Chris Shumake @cvshumake]

#GCP #Spanner is getting an optimizer upgrade in Sept. Time to get testing!

[Chris Shumake @cvshumake]

GCP's public facing #Spanner has really come along in the last two years. Automatic index selection, in particular. Native online schema changes are shifting my loyalties. Also named parameters and (mvp) perf-schema like visibilities, too. Good stuff.

[Chris Shumake @cvshumake]

Learning about CRDT today. Feels like Blekko(Riak) had a great idea so many years ago.

[Chris Shumake @cvshumake]

@jbeardsley We've been trying to reach you about your car's extended warranty

[Chris Shumake @cvshumake]

@PeterZaitsev "assumptions are dangerous, profiling is enlightening."

[Peter Zaitsev @PeterZaitsev]

An unlikely database migration https://t.co/umwqM7FfbB

[Chris Shumake @cvshumake]

@ERIC96B @MarkRJohnsonNC @DrArianeMachin How much talk is there about makeup in-person time instead of summer vacation, assuming vaccination coverage is high enough?

[Sam Lambert @samlambert]

You know you love your job when it feels like the week is going too fast.

[Chris Shumake @cvshumake]

#mysql 8.0 now GA in #cloudsql w/ #GCP
https://t.co/edQYb4g4ww

[Charity Majors @mipsytipsy]

and just look at that GORGEOUS fucking SLO screenshot that shows how we were a) alerted to the fact that our error budget was rapidly evaporating, and b) instantly identified the source of the problem.

* the vertical grey line is the heatmap time range
* top left is error budget

[Chris Shumake @cvshumake]

@gabidavila Hi Gabi, I found it in the docs:
https://t.co/khlp2LlWKz

I now need to dig into my instances and see the implications of actively using an unsupported character set.

[Chris Shumake @cvshumake]

FYI "The character set utf8mb4 is not supported even though the documentation has previously indicated it is." - #gcp #cloudsql

[Chris Shumake @cvshumake]

Amazing data https://t.co/siCqyv6E3L