10 comments

[ 3.1 ms ] story [ 34.8 ms ] thread
Looks like a lot of large social media companies are open sourcing their MySQL sharding & management tools lately. This is awesome! My favorite so far is Youtube's Vitess though, since it enables writing dumb clients. The vtgate proxy forwards queries to the right shard similar to Twemproxy. http://vitess.io
Can Vitess perform connection pooling? Such as aggregating connections from multiple threads locally into one connection to your master or replica?
I'm surprised they didn't put a login/signup popup that blocks the entire screen.
oh good another open sourced MySQL management tool. This usually happens right when the company decides it's not good enough and is about to move on to something else. See Netflix OSS
(I am the author)

I wrote most of these tools last year and a lack of good example code definitely slowed me down. Even if we drop support for these tools, at least the code now is open sourced as a reference. This was one of the primary motivations for open sourcing this code.

They say they don't use joins, so what's the advantage of using it?
"Zen: MySQL has joined HBase as a supported backend for our graph storage engine."

Is Zen MySQL graph storage open source? Sounds really interesting...

It has not open sourced and I think (and am in no way authoritative) it is unlikely to be open sourced.
I would be interested in a blog post how they store graph data in MySQL (star schema?), so that it scales. (an overview article, no technical details)