Re: advice, is cassandra suitable for a multi-tanency vBulletin type application?

2010-07-13 Thread Michael Dürgner
Are your PVs mostly read or write? As if they are read, I'd think you wouldn't need a Cassandra like storage which is tuned towards writes. Am 12.07.2010 um 23:40 schrieb Sandeep Kalidindi at PaGaLGuY.com: well we were going down constantly with VB running on 3-4 dedicated servers due to

Re: advice, is cassandra suitable for a multi-tanency vBulletin type application?

2010-07-13 Thread Michael Dürgner
The thing about slow on joins is true (we experience that ourselves) but still I wonder myself, why you use cassandra for the indices. Can't you just store them in MySQL although? Am 13.07.2010 um 08:26 schrieb Sandeep Kalidindi at PaGaLGuY.com: @paul - cassandra is really good for storing

Re: advice, is cassandra suitable for a multi-tanency vBulletin type application?

2010-07-13 Thread Benjamin Black
We use Cassandra (multidimensional metrics) *and* redis (counters and alerts) *and* MySQL (supporting Rails). Right tool for each job. The idea that it is a good thing to cram everything into a single database (and data model), beaten into everyone by years of relational database marketing, is

Re: advice, is cassandra suitable for a multi-tanency vBulletin type application?

2010-07-13 Thread Benjamin Black
On Mon, Jul 12, 2010 at 11:35 PM, Michael Dürgner mich...@duergner.de wrote: The thing about slow on joins is true (we experience that ourselves) but still I wonder myself, why you use cassandra for the indices. Can't you just store them in MySQL although? ...and then shard and shard and

Re: advice, is cassandra suitable for a multi-tanency vBulletin type application?

2010-07-13 Thread Sandeep Kalidindi at PaGaLGuY.com
@michael - benjamin answered your question. Thing is if you use mysql just for indices you are not at all using the benefits of the whole relational database engine(which is fine) but then are inheriting all its disadvantages. You can use mysql for storing indices and then write your own

Re: advice, is cassandra suitable for a multi-tanency vBulletin type application?

2010-07-13 Thread Paul Prescod
On Mon, Jul 12, 2010 at 11:44 PM, Benjamin Black b...@b3k.us wrote: We use Cassandra (multidimensional metrics) *and* redis (counters and alerts) *and* MySQL (supporting Rails).  Right tool for each job.  The idea that it is a good thing to cram everything into a single database (and data

Re: advice, is cassandra suitable for a multi-tanency vBulletin type application?

2010-07-13 Thread S Ahmed
The only issue I see (please correct me if I am wrong) is that you loose, is that you have single points of failure in the system now i.e. redis etc. On Tue, Jul 13, 2010 at 3:33 AM, Sandeep Kalidindi at PaGaLGuY.com sandeep.kalidi...@pagalguy.com wrote: @michael - benjamin answered your

Re: advice, is cassandra suitable for a multi-tanency vBulletin type application?

2010-07-13 Thread Sandeep Kalidindi at PaGaLGuY.com
@Ahmed - we are trying to use Redis + gizzard - with gizzard responsible for sharding and maintaining replicas . Need to test it well before plunging into production though. Cheers, Deepu. On Tue, Jul 13, 2010 at 7:46 PM, S Ahmed sahmed1...@gmail.com wrote: The only issue I see (please

Re: advice, is cassandra suitable for a multi-tanency vBulletin type application?

2010-07-13 Thread Benjamin Black
On Tue, Jul 13, 2010 at 2:43 AM, Paul Prescod p...@prescod.net wrote: On Mon, Jul 12, 2010 at 11:44 PM, Benjamin Black b...@b3k.us wrote: We use Cassandra (multidimensional metrics) *and* redis (counters and alerts) *and* MySQL (supporting Rails).  Right tool for each job.  The idea that it is

Re: advice, is cassandra suitable for a multi-tanency vBulletin type application?

2010-07-12 Thread Sandeep Kalidindi at PaGaLGuY.com
we were one of the vbulletin customers and our forums has been facing some bad scaling issues. we coded our forum software to work with cassandra. we are still testing for bugs and might go live in couple of weeks. You can ask any specific questions about vbulletin and cassandra and i will answer

Re: advice, is cassandra suitable for a multi-tanency vBulletin type application?

2010-07-12 Thread S Ahmed
Very interesting! What kind of integration do you have between vB and Cassandra? its not a port then? On Mon, Jul 12, 2010 at 3:34 AM, Sandeep Kalidindi at PaGaLGuY.com sandeep.kalidi...@pagalguy.com wrote: we were one of the vbulletin customers and our forums has been facing some bad

Re: advice, is cassandra suitable for a multi-tanency vBulletin type application?

2010-07-12 Thread S Ahmed
What sort of traffic levels made you port the application to Cassandra? Very interested in seeing this go live. What sort of server setup are you looking at using? On Mon, Jul 12, 2010 at 4:39 PM, Sandeep Kalidindi at PaGaLGuY.com sandeep.kalidi...@pagalguy.com wrote: No we re-coded from

Re: advice, is cassandra suitable for a multi-tanency vBulletin type application?

2010-07-12 Thread Sandeep Kalidindi at PaGaLGuY.com
well we were going down constantly with VB running on 3-4 dedicated servers due to huge traffic(couple of tens of millions of page views). We are also planning on some new major features, hence the shift to cassandra with future in mind. Well roughly the architecture is like this(in order of how

Re: advice, is cassandra suitable for a multi-tanency vBulletin type application?

2010-07-12 Thread Paul Prescod
Why Cassandra *and* Redis? What do you perceive as the strengths or weaknesses of the two? On Mon, Jul 12, 2010 at 2:40 PM, Sandeep Kalidindi at PaGaLGuY.com sandeep.kalidi...@pagalguy.com wrote: well we were going down constantly with VB running on 3-4 dedicated servers due to huge

advice, is cassandra suitable for a multi-tanency vBulletin type application?

2010-07-11 Thread S Ahmed
I want to build a vBulletin type application (forums, threads, posts, user management, etc). Support multi-tenancy for a Saas type environment. Would Cassandra be suitable for this type of application? Thanks in advance.

Re: advice, is cassandra suitable for a multi-tanency vBulletin type application?

2010-07-11 Thread Paul Prescod
On Sun, Jul 11, 2010 at 8:39 AM, S Ahmed sahmed1...@gmail.com wrote: I want to build a vBulletin type application (forums, threads, posts, user management, etc). Support multi-tenancy for a Saas type environment. Would Cassandra be suitable for this type of application? Thanks in advance.