Re: cassandra disks cache on SSD

2016-04-01 Thread vincent gromakowski
Can you provide me a approximate estimation of performance gain ? 2016-04-01 19:27 GMT+02:00 Mateusz Korniak : > On Friday 01 April 2016 13:16:53 vincent gromakowski wrote: > > (...) looking > > for a way to use some kind of tiering with few SSD caching hot data

Re: Adding Options to Create Statements...

2016-04-01 Thread James Carman
But, if there were a Java driver provided by the Apache Cassandra project itself, then it'd be an easy choice. On Fri, Apr 1, 2016 at 2:16 PM Robert Coli wrote: > On Fri, Apr 1, 2016 at 10:43 AM, James Carman > wrote: > >> A, my bad. One

Re: Adding Options to Create Statements...

2016-04-01 Thread Robert Coli
On Fri, Apr 1, 2016 at 10:43 AM, James Carman wrote: > A, my bad. One might wonder why the heck the Java driver is "owned" > by an outside entity, eh? > FWIW, the status quo prior to the Datastax drivers was a wide assortment of non-compatible drivers in

Re: Adding Options to Create Statements...

2016-04-01 Thread Jonathan Haddad
Because it's a community driver not provided by the Apache project. There have historically been community provided drivers in the past. See Hector, Astyanax, pycassa, etc. On Fri, Apr 1, 2016 at 10:43 AM James Carman wrote: > A, my bad. One might wonder why

Re: Adding Options to Create Statements...

2016-04-01 Thread James Carman
A, my bad. One might wonder why the heck the Java driver is "owned" by an outside entity, eh? On Fri, Apr 1, 2016 at 11:58 AM Tyler Hobbs wrote: > I'm not sure which driver you're referring to, but if it's the java > driver, it has its own mailing list that may be more

Re: Multi DC setup for analytics

2016-04-01 Thread Laszlo Jobs
Anishek, AFAIK you can not have clusters "overlap" each oder. Just an idea: Try to address it as an sstable restore. http://docs.datastax.com/en/cassandra/2.0/cassandra/operations/ops_snapshot_restore_new_cluster.html What I would try to do (not tested!): - create a logical DC in each cluster

Re: cassandra disks cache on SSD

2016-04-01 Thread Mateusz Korniak
On Friday 01 April 2016 13:16:53 vincent gromakowski wrote: > (...) looking > for a way to use some kind of tiering with few SSD caching hot data from > HDD. > I have identified two solutions (...) We are using lvmcache for that. Regards, -- Mateusz Korniak "(...) mam brata - poważny, domator,

Re: Adding Options to Create Statements...

2016-04-01 Thread Tyler Hobbs
I'm not sure which driver you're referring to, but if it's the java driver, it has its own mailing list that may be more helpful: https://groups.google.com/a/lists.datastax.com/forum/#!forum/java-driver-user On Thu, Mar 31, 2016 at 4:40 PM, James Carman wrote: > No

cassandra disks cache on SSD

2016-04-01 Thread vincent gromakowski
I am looking for way to optimize large reads. I have seen using SSD is a good option but out of budget, so I am looking for a way to use some kind of tiering with few SSD caching hot data from HDD. I have identified two solutions and would like to get opinions from you and if you have any

Cassandra sstable to Mysql

2016-04-01 Thread Abhishek Aggarwal
Hi , We have the data dump into directory taken from Mysql using the CQLSSTableWriter. Our requirement is to read this data and load it into MySql. We don't want to use Cassandra as it will lead to read traffic and this operation is just for some validation . Can anyone help us with the

Re: Cassandra Resource Planning

2016-04-01 Thread Alain RODRIGUEZ
Hi Joe, > I am doing resource planning and could use some help. I have been working alone 4 years operating a growing cluster (from 3 to 60+ nodes, from t1.micro instances to I2.2xlarge AWS instances), on the biggest cluster, +2 other clusters and handling MySQL too :'(. I now joined a team of

Re: Speeding up "nodetool rebuild"

2016-04-01 Thread Alain RODRIGUEZ
Hi, is there any way to determine that rebuild is complete If you ran it from a screen ( https://www.gnu.org/software/screen/manual/screen.html) or similar stuff, you should see the command return. Also, 'nodetool netstats | grep -v 100%' will show you remaining stream. No stream = rebuild

Re: NTP Synchronization Setup Changes

2016-04-01 Thread Brice Dutheil
Hi another tip, make sure the OS doesn't come with pre-configured NTP synchronisation services. We had a proper NTP setup, but we missed a service that came with CentOS that synced to a low stratum NTP server. -- Brice On Thu, Mar 31, 2016 at 10:00 AM -0700, "Eric Evans"