Re: cassandra disks cache on SSD

2016-04-02 Thread Bryan Cheng
Hi Vincent, have you already tried the more common tuning operations like row cache? I haven't done any disk level caching like this (we use SSD's exclusively), but you may see some benefit from putting your commitlog on a separate conventional HDD if you haven't tried this already. This may push

Re: Cassandra sstable to Mysql

2016-04-02 Thread Bryan Cheng
You have SSTables and you want to get importable data? You could use a tool like sstabletojson to get json formatted data directly from the sstables; however, unless they've been perfectly compacted, there will be duplicates and updates interleaved that will be properly ordered. If this is a full

Re: NTP Synchronization Setup Changes

2016-04-02 Thread Mukil Kesavan
Thanks for all the useful comments. On Thu, Mar 31, 2016 at 11:22 PM, Brice Dutheil wrote: > 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 N

Is it possible to achieve "sticky" request routing?

2016-04-02 Thread Mukil Kesavan
Hello, We currently have 3 Cassandra servers running in a single datacenter with a replication factor of 3 for our keyspace. We also use the SimpleSnitch wiith DynamicSnitching enabled by default. Our load balancing policy is TokenAwareLoadBalancingPolicy with RoundRobinPolicy as the child. This o