Re: Data modeling a write-intensive comment storage cluster

2014-01-27 Thread Jeremiah Peschka
--- Jeremiah Peschka - Founder, Brent Ozar Unlimited MCITP: SQL Server 2008, MVP Cloudera Certified Developer for Apache Hadoop On Sun, Jan 26, 2014 at 10:27 PM, fxmy wang wrote: > Thanks for the response, Jeremiah. > > > > > > Then here are my questions: > > > 1) To get better writing throughp

Re: Data modeling a write-intensive comment storage cluster

2014-01-26 Thread fxmy wang
Thanks for the response, Jeremiah. > > Then here are my questions: > > 1) To get better writing throughput, is it right to set the w=1? > > This will improve perceived throughput at the client, but it won't improve > throughput at the server. Thank you for clarifying this for me :D > > 2) Wha

Re: Data modeling a write-intensive comment storage cluster

2014-01-25 Thread Jeremiah Peschka
Responses inline --- sent from a tiny portion of the hive mind... in this case, a phone On Jan 25, 2014 5:16 PM, "fxmy wang" wrote: > > Greetings List, > > I'm a new guy who's only got some experience with RMDBs. So please enlighten me if I'm doing something silly. > > So I'm trying to use Riak f

Data modeling a write-intensive comment storage cluster

2014-01-25 Thread fxmy wang
Greetings List, I'm a new guy who's only got some experience with RMDBs. So please enlighten me if I'm doing something silly. So I'm trying to use Riak for storing video comments - small but huge amount of datas. Prerequisites: - One bucket for one video. - Keys will consist of a timestamp and us