Extraction Cassandra from SSTables Files ?

2010-07-16 Thread xavier manach
Hi. What is the best method for make large extract of datas from cassandra ? Extract directly from the SSTables files sound good ? If yes, There is an API for exploit directly the SSTables files ? There is a specification of the SSTables files ? Thx.

Granularity SSTables.

2010-06-10 Thread xavier manach
t; 2. copy everything ***files sstables*** in data/ directories (but not system > keyspace!) to new node > 3. restart and autobootstrap=false [the default] Thx. On Tue, Jun 8, 2010 at 7:12 AM, xavier manach wrote: > Hi. > >   I have a cluster with only 1 node with a lot of da

Re: Duplicate a node (replication).

2010-06-09 Thread xavier manach
Perfect.   It's exactly the information I needed. Thx Jonathan.

Duplicate a node (replication).

2010-06-08 Thread xavier manach
Hi. I have a cluster with only 1 node with a lot of datas (500 Go) . I want add a new node with the same datas (with a ReplicationFactor 2) The method normal is : stop node. add a node. change replication factor to 2. start nodes use nodetool repair But , I didn't know if this other method

Re: Administration Memory for Noobs. (GC for ConcurrentMarkSweep ?)

2010-06-01 Thread xavier manach
mance/reference/whitepapers/tuning.html Thanks Oleg. 2010/6/1 Oleg Anastasjev > xavier manach tekio.org> writes: > > > > > Hi. I search informations for basic tunning of memory in Cassandra.My > situation : I started to test larges imports of data in Cassandra 6.1

Administration Memory for Noobs. (GC for ConcurrentMarkSweep ?)

2010-05-31 Thread xavier manach
Hi. I search informations for basic tunning of memory in Cassandra. My situation : I started to test larges imports of data in Cassandra 6.1. My first import worked fine : 100 Millions row in 2 hours ~ around 1 insert row by seconds My second is slower with the same script in another colu

Re: How to drop a column family (Cassandra 6.1)

2010-05-31 Thread xavier manach
m_drop_column_family will drop the CF definition > > truncate (available from 0.7) will delete the data, which is equivalent to > the steps 1-4 above > > > On Mon, May 31, 2010 at 12:33 PM, xavier manach wrote: > >> Hi >> >> In the API I see : system_drop_colu

How to drop a column family (Cassandra 6.1)

2010-05-31 Thread xavier manach
Hi In the API I see : system_drop_column_family *Requires Cassandra 0.7 * How to drop a column family with Cassandra 6.1 ? * Delete *the files MYCOLUMNFAMILY-XXX-Data.db, MYCOLUMNFAMILY-XXX-Filter.db , MYCOLUMNFAMILY-XXX-Index.db is a good ways ? Can I recreate this columnfamily after this de

Re: Cause possible for a "cound not connect" TTransportException.NOT_OPEN , during load datas ?

2010-05-21 Thread xavier manach
ing connection pooling rather than opening a > ton of sockets. > > You didn't say what CL you are using, but you should not use CL.ZERO > for load tests. > > On Thu, May 20, 2010 at 11:14 AM, xavier manach wrote: > > Hi. > > > > I am neebie in Cassandra. I

Cause possible for a "cound not connect" TTransportException.NOT_OPEN , during load datas ?

2010-05-20 Thread xavier manach
Hi. I am neebie in Cassandra. I study and compare performance of databases for choose my future architecture. I try to load a lot of datas in cassandra. I use python with protocol thrift (very simple, whithout threading) I do sequentials requests : client.batch_mutate and client.get_slice. (a