How to use cassandra of python better?

2019-12-12 Thread lampahome
As title, I want to utilize cassandra's advantages in maximum but I don't know how. So far, I know I can improve performance by execute_async and batchstatement. When I want more nodes scalability, just add server and modify some config files. Are there ways to help me use cassandra-python bette

Re: Data is not syncing up when we add one more Node(DR) to existing 3 node cluster

2019-12-12 Thread John Belliveau
Hi Anil, In the cassandra.yaml file on your new node in DC2, is the IP address for the seeds set to the seed node in DC1? Best, John On Wed, Dec 11, 2019 at 11:09 PM Anil Kumar Ganipineni < akganipin...@adaequare.com> wrote: > Hi All, > > > > We have 3 node cluster on datacentre DC1 and below i

Re: Measuring Cassandra Metrics at a Sessions/Connection Levels

2019-12-12 Thread Reid Pinchback
Metrics are exposed via JMX. You can use something like jmxtrans or collectd with the jmx plugin to capture metrics per-node and route them to whatever you use to aggregate metrics. From: Fred Habash Reply-To: "user@cassandra.apache.org" Date: Thursday, December 12, 2019 at 9:38 AM To: "user@

Re: average row size in a cassandra table

2019-12-12 Thread Raney, Michael
For rough estimate, I’ve seen the following pattern. Sudo code Do queries by token range at random. Select asjson * from table; Take the length of json string of each row. Perform average. Cheers. From: Ayub M Reply-To: "user@cassandra.apache.org" Date: Wednesday, December 11, 2019 at 11:17

Measuring Cassandra Metrics at a Sessions/Connection Levels

2019-12-12 Thread Fred Habash
Hi all ... We are facing a scenario where we have to measure for some metrics on a per connection or client basis. For example. count of read/write request by client IP/host/user/program. We want to know the source of C* requests for budgeting, capacity planing, or charge-backs. We are running 2.2

Re: execute is faster than execute_async?

2019-12-12 Thread Avi Kivity
On 12/12/2019 06.25, lampahome wrote: Jon Haddad mailto:j...@jonhaddad.com>> 於 2019年12月12日 週四 上午12:42寫道: I'm not sure how you're measuring this - could you share your benchmarking code? s the details of theri? start = time.time() for i in range(40960):     prep = session.