An alternate strategy for database sharding which avoids queries across different shards and merging results. A central repository of data is maintained for some tables along with other shards. Can be used in calculating top users, recent users, most read etc.

So a while ago I wrote about fun post about MySQL Scalability to 256 way….

Besides discussion on the thread itself I had a lot of private comments in my mail from Sun/MySQL employees which tended to agree with me on this being the a large stretch.

I would hope Sun/MySQL would tone it down and actually spend time on making things to scale inside MySQL rather than asking you to run tens of MySQL instances to get reasonable performance, but sure enough writing code is harder than writing marketing materials so this work now made it to the Sun blueprint making it recommended reference architecture.

It is also interesting to go back to my old post about T2000 performance with Sun comments about Sun not pushing this as scalable MySQL platform. Well this is T5440 now not T2000 but the outstanding gap in single thread CPU performance remains, which makes a lot of operations tasks very complicated.

Oh wait. I forgot there is solution - instead of 1TB database we should run 1000 instances with 1GB each which will allow us not to care about single thread performance for replication needs, ALTER TABLE or any long running queries.

Do not take it as me saying T5440 is never good for MySQL. It may work quite well for some cases, for example when a lot of small MySQL instances need to be run. It is just this blueprint offers very one side view speaking about benefits but no drawbacks.

---

Entry posted by peter | No comment

Add to: | | | |

时间过的真快，豆瓣的“音乐人”上线已经5个月了。5个月的时间里，来自香港、台北、北京、上海、海登海姆、纽约、墨尔本等世界各地的近2000位艺术家聚集在这里，持续地奉献着足够多的热情和魅力。08年最后一刊的《城市画报》介绍了众多中国独立音乐人，细心的话，你一定能发现每个人的豆瓣“身份证”，是的，我说的豆瓣“身份证”就是他们的豆瓣音乐人地址。

最受欢迎的音乐人排行榜无疑风格昭然的表明了那条长尾里最聚众的喜好。最受欢迎的前二十名里，跨越了流行，摇滚和民谣。

虽然My Little Airport唱着很多人听不懂的广东话，在他们的歌声中，却让你我都能感受到那繁华璀璨东方之珠的另一面。梁文道说过，香港是一直生活在清代的城市，就算外表再现代，也有一颗守旧的心。阿p在浪漫九龙塘的live里说：这首歌送给李青。上次她来香港我们一起吃了餐饭……没错,李青就是京城最劲噪声三人组与最劲室内管弦乐三人组中的那个含蓄女孩。

把眼光从最受欢迎的主题上移开，长尾里还有更奇妙的：

邵小毛的歌词里有名大龄女青年名叫王小姐。大龄女青年的问题就是怎么在最短时间内找到个又靠谱又志趣相投的长期饭票。父母催完朋友催，朋友催完亲戚催，纠结到最后连自己都没办法面对自己。你觉得她唱的还有意思吗，那么请看她的风格中，明晃晃的大字写到：写实/民谣──音乐有时候是反应现实的一把弯刀，这就是表现！

永远怀念塔可夫斯基，在08年圣诞，因意图举办”半裸party“，而被警察叫去谈话。从此有了《湾仔差馆奇遇记》。

也许你已经发现，有那么几个周末你会奔波在京城不同的livehouse里看主题不同的演出，是的，国内的现场演出越来越国际化，不论对于独立音乐人还是音乐爱好者们来说都很好！

据说，阴三儿打破MAO livehouse的票房记录，一晚上塞进演出场地近千人，还不包括中途离席的。

2004年瑞典格莱美奖得主José González在北京演出的时候，好像全北京城的外国人都从各个角落里冒出来，把本来不小的愚公移山挤的水泄不通。台下人山人海，台上的José González稳坐在用灯光营造的好似北欧瑞典的郊外一样的舞台，吟唱着一首首动听的歌曲。

趣事说了不少，下面来个预告：来自纽约的Battles将在北京和上海演出。如果你不清楚他们的来历，看看《The Guardian》杂志编辑Tim Jonze 对他们的评价：Battles听上去就像一队植入华丽摇滚程序的机器人共同发出的声音。还不很清楚？直接去音乐人页面试听吧……别犹豫，北京3月27号，上海3月28号，欢迎你来看高科技的Math Rock!

你问我怎么知道那么多八卦？在豆瓣这略带80年代巴豪斯风格的高大建筑里，一层清新，阳光的午后流连于此那么安逸；一层摆着代表”爱与和平”的鲜花，20世纪60年代的嬉皮精神丛生于此；一层Punk，青春的气息扑面而来，电子、爵士、说唱、乃至实验音乐依次排开，你我都能有一小片属于自己的领地。

趣闻其实就在身边,要做的不过是去”关注”。