RE: [EXTERNAL] Lot of hints piling up

2017-10-24 Thread Mohapatra, Kishore
d good too. Issue here is, this causing replication lag across the datacenters. On Mon, Oct 23, 2017 at 10:23 AM, Mohapatra, Kishore <kishore.mohapa...@nuance.com<mailto:kishore.mohapa...@nuance.com>> wrote: Do you see any error in the cassandra log ? Check compactionstats ? Also chec

RE: [EXTERNAL]

2017-10-24 Thread Mohapatra, Kishore
consistency of ONE or by bumping up read_repair_chance? We have tried from command line with ONE but that times out. On 2017-10-23 10:18, "Mohapatra, Kishore" <kishore.mohapa...@nuance.com> wrote: > What is your RF for the keyspace and how many nodes are there in each DC ?

RE: [EXTERNAL] Lot of hints piling up

2017-10-23 Thread Mohapatra, Kishore
Do you see any error in the cassandra log ? Check compactionstats ? Also check the OS level log messages to see if you are getting hardware level error messages. Thanks Kishore Mohapatra Principal Operations DBA Seattle, WA Ph : 425-691-6417 (cell) Email :

RE: [EXTERNAL]

2017-10-23 Thread Mohapatra, Kishore
What is your RF for the keyspace and how many nodes are there in each DC ? Did you force a Read Repair to see, if you are getting the data or getting an error ? Thanks Kishore Mohapatra Principal Operations DBA Seattle, WA Email : kishore.mohapa...@nuance.com -Original Message- From:

RE: [EXTERNAL] Re: Increasing VNodes

2017-10-04 Thread Mohapatra, Kishore
fully contained by at least one vnode). On Wed, Oct 4, 2017 at 9:46 AM, Mohapatra, Kishore <kishore.mohapa...@nuance.com<mailto:kishore.mohapa...@nuance.com>> wrote: Hi, We are having a lot of problems in repair process. We use sub range repair. But most of the time, so

Increasing VNodes

2017-10-04 Thread Mohapatra, Kishore
Hi, We are having a lot of problems in repair process. We use sub range repair. But most of the time, some ranges fails with streaming error or some other kind of error. So wondering if it will help if we increase the no. of VNodes from 256 (default) to 512. But increasing the VNodes

RE: [EXTERNAL] Cassandra copy command is giving OverflowError

2017-09-22 Thread Mohapatra, Kishore
Try this. COPY keyspace1.table1 TO '/tmp/table1.csv' WITH PAGETIMEOUT=40 AND PAGESIZE=20; Thanks Kishore Mohapatra Principal Operations DBA Seattle, WA Email : kishore.mohapa...@nuance.com From: AI Rumman [mailto:rumman...@gmail.com] Sent: Thursday,

RE: [EXTERNAL] Re: Cassandra repair process in Low Bandwidth Network

2017-09-15 Thread Mohapatra, Kishore
s don't always hit all 3 dcs - for exactly, you could do a repair between DC1 and DC2 using -dc, then do a repair of DC1 and DC3 using -dc - it's a lot more coordination required, but likely helps cut down on the traffic over your VPN link. On Fri, Sep 15, 2017 at 9:09 AM, Mohapatra, Kishor

Cassandra repair process in Low Bandwidth Network

2017-09-15 Thread Mohapatra, Kishore
Hi, we have a cassandra cluster with 7 nodes each in 3 datacenters. We are using C* 2.1.15.4 version. Network bandwidth between DC1 and DC2 is very good (10Gbit/s) and a dedicated one. However network pipe between DC1 and DC3 and between DC2 and DC3 is very poor and has only 100 MBit/s