Re: Best Practices for Managing Concurrent Client Connections in Cassandra

2024-02-29 Thread Andrew Weaver
We've used these settings in production with no issues. What has been more valuable to us though is limiting the rate of client connections via iptables. Often times users configure an aggressive reconnection policy that floods the cluster with connections in certain circumstances like a node

Re: Cassandra p95 latencies

2023-08-25 Thread Andrew Weaver
Do you have the SSTables per read metric for before and after you increased the key cache size? If it was high before, that may have been the culprit meaning compaction tuning is in order. On Fri, Aug 25, 2023, 12:35 PM Shaurya Gupta wrote: > Thanks everyone. > Updating this thread - > We

Re: Testing Cassandra connectivity at application startup

2023-08-25 Thread Andrew Weaver
For a readiness probe and for ongoing ECV checks, just making sure the driver is initialized is enough. I've seen problems recently with applications running "select cluster_name from system.local" for ECV checks. We haven't dug into it in detail yet but with a large number of clients it puts a

Re: Survey about the parsing of the tooling's output

2023-07-10 Thread Andrew Weaver
iated a lot if you gave us more feedback on this. I > understand that not all questions are relatable to everyone. > > Even you are not relying on the output of the tooling in some custom > scripts where you parse it, please tell us so. We are progressively trying > to provide CQL way how to query the internal state of Cassandra, via > virtual tables, for example. > > Regards > > Stefan Miklosovic -- Andrew Weaver

Re: Corruption of frozen UDT during upgrade

2020-02-14 Thread Andrew Prudhomme
What does http://cassandra.apache.org/doc/latest/tools/sstable/sstablemetadata.html show as the type in the upgraded table? Also, the ticket mentions serialization ordering being incorrect between single and multi-cell column data. Perhaps there needs to be other non-PK fields to trigger this

Re: re-add column with same UDT fail

2019-11-21 Thread Andrew Prudhomme
It looks like there are a couple of things going on here. The type check when adding a UDT column: new_type.isValueCompatibleWith(dropped_type) will only be true if the dropped type is a UDT. This however will never be the case, since UDT types are replaced with tuple when converted to a dropped

Re:

2018-09-05 Thread Andrew Baker
and videos too as I recall. -Andrew On Wed, Sep 5, 2018 at 6:19 AM sha p wrote: > Hi all , > Me new to Cassandra , i was asked to migrate data from Oracle to Cassandra. > Please help me giving your valuable guidance. > 1) Can it be done using open source Cassandra. > 2) Where should I s

Re: GUI clients for Cassandra

2018-04-22 Thread Andrew Baker
https://zeppelin.apache.org/ is pretty nice, not a fully fledge Cassandra GUI, but worth a look. Plus it can be used for all sorts of other things. On Sun, Apr 22, 2018 at 8:59 AM Hannu Kröger wrote: > Hello everyone! > > I have been asked many times that what is a good GUI

Is this SSTable restore merging scenario possible ?

2018-03-21 Thread Andrew Voumard
Hi All, I am using Cassandra 3.10 I would like to know if the following SSTable row level merging scenario is possible: 1. On a Production Cluster - Take a full snapshot on every node 2. On a new, empty Secondary Cluster with the same topology - Create a matching schema (keyspaces + tables as

CDC usability and future development

2018-01-30 Thread Andrew Prudhomme
Hi all, We are currently designing a system that allows our Cassandra clusters to produce a stream of data updates. Naturally, we have been evaluating if CDC can aid in this endeavor. We have found several challenges in using CDC for this purpose. CDC provides only the mutation as opposed to the

Re: Hinted handoff throttled even after "nodetool sethintedhandoffthrottlekb 0"

2017-10-27 Thread Andrew Bialecki
r something related to a timeout setting? On Fri, Oct 27, 2017 at 1:49 AM, Andrew Bialecki < andrew.biale...@klaviyo.com> wrote: > We have a 96 node cluster running 3.11 with 256 vnodes each. We're running > a rolling restart. As we restart nodes, we notice that each node takes a

Hinted handoff throttled even after "nodetool sethintedhandoffthrottlekb 0"

2017-10-26 Thread Andrew Bialecki
reasons why hinted handoff runs so slowly? -- Andrew Bialecki

InternalResponseStage low on some nodes

2017-05-23 Thread Andrew Jorgensen
these numbers seems reasonable for a idle cluster? Thanks! Andrew Jorgensen @ajorgensen

Re: Non-zero nodes are marked as down after restarting cassandra process

2017-05-16 Thread Andrew Jorgensen
actful fix was from the usage side. As far as I can tell there are no dropped messages, there are some pending Compactions and a few Native-Transport_Request in the all time blocked column. Thanks! Andrew Jorgensen @ajorgensen On Wed, Mar 1, 2017 at 12:58 PM, benjamin roth <brs...@gmail.com&g

Re: Does Java driver v3.1.x degrade cluster connect/close performance?

2017-03-07 Thread Andrew Tolbert
made for JAVA-914 <https://datastax-oss.atlassian.net/browse/JAVA-914> which was introduced in 2.1.9 and 3.0.x, not the netty 3.9 to 4.0 version change which I was incorrect about as that change was made earlier (at driver 2.1.6). Thanks, Andy On Mon, Mar 6, 2017 at 11:11 PM, Satoshi Hikida <sa

Re: Does Java driver v3.1.x degrade cluster connect/close performance?

2017-03-06 Thread Andrew Tolbert
99.9% <= 8.03 milliseconds Similary when using a local C* node, initialization times are pretty similar. I'd be interested to see if running the same test <https://gist.github.com/tolbertam/e6ac8b71a7703a6fc4561356767a1501> in your environment creates different results. Th

Re: Does Java driver v3.1.x degrade cluster connect/close performance?

2017-03-06 Thread Andrew Tolbert
Hi Satoshi, This question would be better for the 'DataStax Java Driver for Apache Cassandra mailing list ', but I do have a few thoughts about what you are observing: Between java-driver 2.1 and 3.0 the driver

Non-zero nodes are marked as down after restarting cassandra process

2017-03-01 Thread Andrew Jorgensen
this before and is there anything I can do to fix/reduce the impact of running a restart on a cassandra node? Thanks, Andrew Jorgensen @ajorgensen

Re: Authentication with Java driver

2017-02-07 Thread Andrew Tolbert
Hello, The API seems kind of not correct because credentials should be > usually set with a session but actually they are set with a cluster. > With the datastax driver, Session is what manages connection pools to each node. Cluster manages configuration and a separate connection ('control

Re: Inserting list data

2016-11-30 Thread Andrew Baker
that to the test and let you know. -Andrew On Fri, Oct 14, 2016 at 11:00 PM Russell Spitzer <russell.spit...@gmail.com> wrote: > Are you sure you aren't using batches? These will assign the same > timestamp to your inserts which can lead to unexpected behaviors. > > On Fri, Oct 14, 2016 a

Row and column level tombstones

2016-11-23 Thread Andrew Cooper
is taken into consideration on the read path and all columns with timestamp less than key tombstone are ignored in the response. I have not dug into the codebase yet. If anyone can shed light on this question from their own experiences that would be helpful. Thanks, -Andrew

Cluster nodes not catching up on total hints

2016-11-22 Thread Andrew Kenney
We’re seeing a strange issue on our Cassandra cluster wherein 3 nodes out of 21 appear to have a significant amount of hints piling up. We’re not seeing a lot in the system log showing that the node is having issues with hints and nodetool status is not showing any issues with the other nodes in

Re: cassandra python driver routing requests to one node?

2016-11-14 Thread Andrew Bialecki
, Alex Popescu <al...@datastax.com> wrote: > I'm wondering if what you are seeing is https://datastax-oss. > atlassian.net/browse/PYTHON-643 (that could still be a sign of a > potential data hotspot) > > On Sun, Nov 13, 2016 at 10:57 PM, Andrew Bialecki < > andrew.

Re: cassandra python driver routing requests to one node?

2016-11-13 Thread Andrew Bialecki
t to debug. On Mon, Nov 14, 2016 at 12:39 AM, Ben Slater <ben.sla...@instaclustr.com> wrote: > What load balancing policies are you using in your client code ( > https://datastax.github.io/python-driver/api/cassandra/policies.html)? > > Cheers > Ben > > On Mon, 14 Nov 2016 a

cassandra python driver routing requests to one node?

2016-11-13 Thread Andrew Bialecki
We have an odd situation where all of a sudden of our cluster started seeing a disproportionate number of writes go to one node. We're using the Python driver version 3.7.1. I'm not sure if this is a driver issue or possibly a network issue causing requests to get routed in an odd way. It's not

Re: Consistency when adding data to collections concurrently?

2016-11-12 Thread Andrew Tolbert
Nov 12, 2016 at 8:41 PM, Ali Akhtar <ali.rac...@gmail.com> wrote: > > Andrew, > > I was thinking about setting up an accessor with that query and a bound > variable ? which binds to the instance being added, e.g: > > @Query("UPDATE my_table SET labels = labels +

Re: Consistency when adding data to collections concurrently?

2016-11-12 Thread Andrew Tolbert
You can do it in a SimpleStatement assuming you provide the CQL exactly as you provided, but in a PreparedStatement it will not work because cql prohibits provide bind values in collection literals. For it to work you could provide a List of UDT values in a bound prepared statement, i.e.:

Re: Deadlock in callbacks to async operations (Java)

2016-11-12 Thread Andrew Tolbert
> > Will the above example work if instead of session.execute, it was doing > session.executeAsync()? > It will work as executeAsync will not block waiting on behavior in a I/O thread (that may also happen to be the calling thread), so it is not susceptible to deadlock. To be extra safe, you

Re: Being asked to use frozen for UDT in 3.9

2016-10-10 Thread Andrew Tolbert
Y KEY, > this_doesnt_work test > ) WITH bloom_filter_fp_chance = 0.01 > > > On Mon, Oct 10, 2016 at 9:25 PM Ali Akhtar <ali.rac...@gmail.com> wrote: > >> CREATE TYPE test ( >> foo text, >> bar text >> ); >> >> CREATE TABLE test_table

Re: Being asked to use frozen for UDT in 3.9

2016-10-10 Thread Andrew Tolbert
xt, > this_doesnt_work test, > PRIMARY KEY (id) > ); > > On Tue, Oct 11, 2016 at 9:23 AM, Andrew Tolbert < > andrew.tolb...@datastax.com> wrote: > > Can you please share an example where it doesn't work? > > Thanks, > Andy > > On Mon, Oct 10, 2016 at 11:

Re: NamingStrategy for the Java Driver for camelCase / snake_case conversion?

2016-10-10 Thread Andrew Tolbert
ow does that work - do I just create a pojo for the UDT, and use > @Column on the fields, and it will work if I define a field in the table > mapping class as being of that pojo type? > > On Tue, Oct 11, 2016 at 8:57 AM, Andrew Tolbert < > andrew.tolb...@datastax.com> wrot

Re: Being asked to use frozen for UDT in 3.9

2016-10-10 Thread Andrew Tolbert
ed to define a column (not primary or > cluster key) as being of that type, but it doesn't let me do that unless i > set it as frozen. Docs indicate otherwise though > > On Tue, Oct 11, 2016 at 9:09 AM, Andrew Tolbert < > andrew.tolb...@datastax.com> wrote: > > I

Re: Being asked to use frozen for UDT in 3.9

2016-10-10 Thread Andrew Tolbert
Is the column you are using that has the UDT type is the or is part of the primary key? If that is the case it still needs to be frozen (the same goes for list, set, tuple as part of primary key). This is the error I get when I try that: InvalidRequest: Error from server: code=2200 [Invalid

Re: NamingStrategy for the Java Driver for camelCase / snake_case conversion?

2016-10-10 Thread Andrew Tolbert
at 10:30 PM Ali Akhtar <ali.rac...@gmail.com> wrote: > Please fix this. > > > > On Tue, Oct 11, 2016 at 8:28 AM, Andrew Tolbert < > andrew.tolb...@datastax.com> wrote: > > Hi Ali, > > As far as I know this hasn't changed. Either the field name on the cl

Re: NamingStrategy for the Java Driver for camelCase / snake_case conversion?

2016-10-10 Thread Andrew Tolbert
Hi Ali, As far as I know this hasn't changed. Either the field name on the class has to match the name of the column or you have to use the @Column with the name attribute to set the column name being mapped by that field. Thanks, Andy On Mon, Oct 10, 2016 at 8:03 PM Ali Akhtar

Re: Running Cassandra in Integration Tests

2016-10-06 Thread Andrew Tolbert
Hi Ali, cassandra-unit might be what you are looking for. It allows you to run an embedded cassandra instance along side your tests and has some nice integration with JUnit. Thanks, Andy On Thu, Oct 6, 2016 at 7:13 PM Ali Akhtar

Re: Re : Generic keystore when enabling SSL

2016-09-20 Thread Andrew Tolbert
e're using 3rd party signed certificates, and want to avoid > the hassle of managing 100's of certificates. > > thanks > Sai > -- [image: DataStaxLogo copy3.png] <http://www.datastax.com/> Andrew Tolbert Software Engineer in Test | (612)-222-6271 | andrew.tolb...@datastax.com &l

Re: How to define blob column in Java?

2016-09-11 Thread Andrew Tolbert
Hi Alexandr, I am assuming you are referring to the @Table annotation in the mapping module in the Datastax Java Driver for Apache Cassandra (please correct me if I am wrong). You can achieve this with any of these three types using a custom codec

Re: Guava version check in 3.0

2016-02-11 Thread Andrew Jorgensen
${main.class} -- Andrew Jorgensen @ajorgensen On Thu, Feb 11, 2016, at 03:40 PM, Andrew Jorgensen wrote: > He

Guava version check in 3.0

2016-02-11 Thread Andrew Jorgensen
with older versions of Guava or would it be possible to turn off the sanity check? Thanks, -- Andrew Jorgensen @ajorgensen

Re: Maximum Row Limit

2015-08-24 Thread Andrew Tolbert
Hello Mangeet, According to CassandraLimitations http://wiki.apache.org/cassandra/CassandraLimitations the maximum cells per Partition key is 2 billion: - The maximum number of cells (rows x columns) in a single partition is 2 billion. Therefore the maximum number of rows per

Re: COMMERCIAL:Re: Cross-datacenter requests taking a very long time.

2015-04-02 Thread Andrew Vant
that. I should add that one of the other teams here has a similar setup (3 nodes in 3 DCs) that is working correctly. We're going to go through the config files and see if we can figure out what's different. -- Andrew

Cross-datacenter requests taking a very long time.

2015-03-31 Thread Andrew Vant
not entirely sure what direction to look in to find the problem. -- Andrew

Re: run cassandra on a small instance

2015-02-18 Thread Andrew
to approach versions... Andrew On February 18, 2015 at 5:16:27 PM, Robert Coli (rc...@eventbrite.com) wrote: On Wed, Feb 18, 2015 at 5:09 PM, Tim Dunphy bluethu...@gmail.com wrote: I'm attempting to run Cassandra 2.1.2 on a smallish 2.GB ram instance over at Digital Ocean. It's a CentOS 7 host

Re: UDF and DevCenter

2015-01-23 Thread Andrew Cobley (Staff)
...@datastax.com. And the good news is that in the next release there will be an integrated feedback form directly in DevCenter. On Thu, Jan 22, 2015 at 8:15 AM, Andrew Cobley (Staff) a.e.cob...@dundee.ac.ukmailto:a.e.cob...@dundee.ac.uk wrote: I’m not sure where to send “faults” for the DataStax

UDF and DevCenter

2015-01-22 Thread Andrew Cobley (Staff)
I’m not sure where to send “faults” for the DataStax Devcenter so I’ll send them here. If I define a UDT such as: CREATE TYPE if not exists sensorsync.SensorReading ( fValue float, sValue text, iValue int ); and a table Create table if not exists sensorsync.Sensors( name uuid,

Re: Saving file content to ByteBuffer and to column does not retrieve the same size of data

2014-09-30 Thread Andrew Cobley
I too have saved images in blobs (in development environment admittedly) . Sample code can be seen here: https://github.com/acobley/instagrim/blob/master/src/main/java/uk/ac/dundee/computing/aec/instagrim/models/PicModel.java Note this code uses the org.imgscalr.Scalr to resize and process

Re: DSE install interfering with apache Cassandra 2.1.0

2014-09-30 Thread Andrew Cobley
September 2014 01:25, Andrew Cobley a.e.cob...@dundee.ac.ukmailto:a.e.cob...@dundee.ac.uk wrote: Without the apache cassandra running I ran jps -l on this machine ,the only result was 338 sun.tool.jps.Jps The Mac didn’t like the netstat command so I ran netstat -atp tcp | grep 9160 no result Also

DSE install interfering with apache Cassandra 2.1.0

2014-09-29 Thread Andrew Cobley
Hi All, Just come across this one, I’m at a bit of a loss on how to fix it. A user here did the following steps On a MAC Install Datastax Enterprise (DSE) using the dmg file test he can connect using the DSE cqlsh window Unistall DSE (full uninstall which stops the services) download apache

Re: DSE install interfering with apache Cassandra 2.1.0

2014-09-29 Thread Andrew Cobley
, Andrew Cobley a.e.cob...@dundee.ac.ukmailto:a.e.cob...@dundee.ac.uk wrote: Hi All, Just come across this one, I’m at a bit of a loss on how to fix it. A user here did the following steps On a MAC Install Datastax Enterprise (DSE) using the dmg file test he can connect using the DSE cqlsh window

Re: using dynamic cell names in CQL 3

2014-09-29 Thread Andrew Cobley
Isn’t the correct way to do this in CQL3 to use sets and user defined types (in C* 2.1) ?: create type sensorreading( date timestamp, name text, value int); CREATE TABLE sensordata ( name text, data setfrozen sensorreading, PRIMARY KEY (name) ); insert into keyspace2.sensordata (name, data)

DevCenter and Cassandra 2.1

2014-09-26 Thread Andrew Cobley
Hi all, I notice that descanter 1.1.1doesn’t support User defined types (as far as I can see). Is it just a matter of importing a template or will we need to wait for full 2.1 support in descanter ? Andy The University of Dundee is a registered Scottish Charity, No: SC015096

Re: too many open files

2014-08-09 Thread Andrew
for the connection itself, maxing out at 128 local/remote.  I’m not sure if a Session results in a new file handle on the server side, but I saw the same issue (hundreds of thousands of sockets opened on the server). The cluster was also using hsha; most of the other settings were default in 2.0.7. Andrew

Re: too many open files

2014-08-09 Thread Andrew
logic; I had a restriction of about 128 connections per host, but the connections were in the 100s of thousands, like the OP mentioned.  Again, I’ll see about reproducing it on Monday, but just wanted the repro steps (overall) to live somewhere in case I can’t. :) Andrew On August 8, 2014 at 4

Re: too many open files

2014-08-09 Thread Andrew
a significantly large number of connections until the Cassandra server ran out of connections.  Tyler was asking for a repro case and requesting that I file a possible bug, if this was something that SHOULD have been caught on the client side (via the max connections client configuration). Andrew

Re: All writes fail with ONE consistency level when adding second node to cluster?

2014-07-22 Thread Andrew
ONE means write to one replica (in addition to the original).  If you want to write to any of them, use ANY.  Is that the right understanding? http://www.datastax.com/docs/1.0/dml/data_consistency Andrew On July 22, 2014 at 7:43:43 PM, Kevin Burton (bur...@spinn3r.com) wrote: I'm super

Re: All writes fail with ONE consistency level when adding second node to cluster?

2014-07-22 Thread Andrew
I looked into this; ONE means it must be written to one replica—i.e., a node the data is supposed to be written to.  ANY means a hinted handoff will “count”.  So as long as it writes to any node on the cluster—even one that it’s not supposed to be on—it will be a success.  Good to know. Andrew

Re: Size-tiered Compaction runs out of memory

2014-07-09 Thread Andrew
for expired TTLs. Thanks, Andrew On Mon, Jul 7, 2014 at 3:45 PM, Robert Coli rc...@eventbrite.com wrote: On Mon, Jul 7, 2014 at 9:52 AM, Redmumba redmu...@gmail.com wrote: Would adjusting the maximum sstables before a compaction is performed help this situation?  I am currently using the default

Re: Backup Cassandra to

2014-06-12 Thread Andrew
! Andrew On June 12, 2014 at 6:18:57 AM, Jack Krupansky (j...@basetechnology.com) wrote: The doc for backing up – and restoring – Cassandra is here: http://www.datastax.com/documentation/cassandra/2.0/cassandra/operations/ops_backup_restore_c.html   That doesn’t tell you how to move the “snapshot

Re: Migrate from Hector(unmaintained) to Astyanax for Cassandra 2.0.7, (delaying thrift to CQL migration plan) ?

2014-05-28 Thread Andrew
it and the Datastax Cassandra driver.  I’m not sure what the perceived benefits of Thrift over the binary interface are, other than people being familiar with one over another. Andrew On May 28, 2014 at 7:19:52 AM, user 01 (user...@gmail.com) wrote: Currently I am using Hector which is no longer maintained

Stalled streams during repairs

2014-04-16 Thread Andrew Cooper
Responses n/a 0 21929307 I would appreciate any feedback or advice on this. thanks, -Andrew andrew.coo...@nisc.coopmailto:andrew.coo...@nisc.coop

RE: Stalled streams during repairs

2014-04-16 Thread Andrew Cooper
/post/bulk-loading-options-for-cassandra/ -Andrew

Can a column index be renamed in Cassandra 1.2.13

2014-04-06 Thread Andrew Bruno
(617265614d616e616765724964) Validation Class: org.apache.cassandra.db.marshal.BytesType Index Name: areaManagerId_idx Index Type: KEYS Does anyone know if there is a way around this? How can I rename the areaManagerId_idx index for a particular column family? Regards Andrew

Primary index component is missing for sstable

2014-03-27 Thread Andrew Bruno
:3https://synetek.atlassian.net/wiki/display/SSTableBatchOpen/3 2014-03-23 14:26:38,314 SSTableReader.java (line 192) Opening e:\data\cassandra\reports\fr\le-financial_reports.storeCustomField28Id_idx-e-9120 (2202 bytes) Cheers Andrew

InvalidRequestException(why:Duplicate index

2014-03-27 Thread Andrew Bruno
) at org.apache.cassandra.thrift.Cassandra$Client.system_update_column_family(Cassandra.java:1325) at me.prettyprint.cassandra.service.ThriftCluster$5.execute(ThriftCluster.java:130) ... 14 more Regards Andrew

Issue retrieving blobs with CQL

2014-03-19 Thread Andrew Cobley
Cassandra 2.0.4 I’m using blobs to save and retrieve images in cassanda. However the blob I get back is not the blob I saved ! I’m saving to CQL like this: byte[] b= {(byte)10,(byte)20,(byte)30}; int length=b.length; ByteBuffer buffer =ByteBuffer.wrap(b); Session session =

Re: Issue retrieving blobs with CQL

2014-03-19 Thread Andrew Cobley
Apologies, this seems to be addressed in the thread : https://groups.google.com/a/lists.datastax.com/forum/#!searchin/java-driver-user/blob$20ByteBuffer/java-driver-user/4_KegVX0teo/2OOZ8YOwtBcJ Andy On 19 Mar 2014, at 11:55, Andrew Cobley a.e.cob...@dundee.ac.ukmailto:a.e.cob...@dundee.ac.uk

CQLException ?

2014-02-24 Thread Andrew Cobley
I’m just converting some code from SQL to CQL. The code can throw a SQLException. however I note that there is no equivalent in CQL, I’m just wondering whys this is the case ? Regards Andy The University of Dundee is a registered Scottish Charity, No: SC015096

CQL get unique row keys ?

2014-02-15 Thread Andrew Cobley
I may be missing something here, but is there a way in cql to get all unique row keys in a column family(table) ? I’ve created a table like this: CREATE TABLE totp ( artist varchar, track varchar, appearance_type varchar, PRIMARY KEY ((artist),track) ) WITH CLUSTERING ORDER BY (track asc);

RE: CQL get unique row keys ?

2014-02-15 Thread Andrew Cobley
(not clustering keys) with: SELECT DISTINCT pk FROM More info on the feature here: https://issues.apache.org/jira/browse/CASSANDRA-4536 This query is quite efficient because the key cache is used most of the time. Regards Duy Hai DOAN On Sat, Feb 15, 2014 at 6:05 PM, Andrew Cobley a.e.cob

CQL list command

2014-02-06 Thread Andrew Cobley
TL;DR Is there a CQL equivalent of the CLI List command ? yes or No? Long version I often use the CLI command LIST for debugging or when teaching students showing them what’s going on under the hood of CQL. I see that CLI swill be removed in Cassandra 3 and we will lose this ability. It

nodetool removenode hangs - for everyone?

2014-01-24 Thread Andrew Losey
The problem described in ticket 6542, https://issues.apache.org/jira/browse/CASSANDRA-6542, has been observed in my environment. This isn't a new problem, as it's been seen across several differently sized, vnode enabled, clusters for much longer than the age of the ticket. The problem has

Migrate data to new cluster using datacenters?

2013-12-12 Thread Andrew Cooper
am aware of other tools available including sstableloader, etc, but this seemed like a more elegant solution, leveraging cassandra's active-active features. Thanks, -Andrew NISC

Re: Large system.Migration CF after upgrade to 1.1

2013-11-27 Thread Andrew Cooper
, but this is our largest and most problematic cluster :) -Andrew Hope that helps. - Aaron Morton New Zealand @aaronmorton Co-Founder Principal Consultant Apache Cassandra Consulting http://www.thelastpickle.comhttp://www.thelastpickle.com/ On 23/11/2013, at 10:35 am, Andrew Cooper

Large system.Migration CF after upgrade to 1.1

2013-11-22 Thread Andrew Cooper
advice and I can provide more details if needed. -Andrew Andrew Cooper National Information Solutions Cooperative® 3201 Nygren Drive NW Mandan, ND 58554 * e-mail: andrew.coo...@nisc.coopmailto:andrew.coo...@nisc.coop * phone: 866.999.6472 ext 6824 * direct: 701-667-6824

High number of ReplicateOnWriteStage All timed blocked, counter CF

2013-10-22 Thread Andrew Bialecki
in advance for any insights! Andrew

NetworkTopologyStrategy and nodes ?

2013-10-12 Thread Andrew Cobley
Reading this explanation of NetworkTopologyStrategy in 1.1: http://www.datastax.com/docs/1.1/cluster_architecture/replication Is there a suitable explanation of how it will work with Vnodes ? I notice this line in the explanation: In the following graphic, notice the tokens are assigned to

C* 2.0 reduce_cache_sizes_at ?

2013-09-08 Thread Andrew Cobley
I'm following John Berryman's blog Building the Perfect Cassandra Test Environment concerning running C* in a very small amount of memory. he recommends theses settings in cassandra.yaml reduce_cache_sizes_at: 0 reduce_cache_capacity_to: 0 (Blog is at

Re: Setting up a multi-node cluster

2013-08-29 Thread Andrew Cobley
Have you tried setting rpc_address to the same as listen_address ? Andy On 29 Aug 2013, at 07:47, Dinesh dinesh.gad...@gmail.commailto:dinesh.gad...@gmail.com wrote: My first node is running and second node is not running in this case I tried telnet from second node to first node. Following

Vnodes, adding a node ?

2013-08-14 Thread Andrew Cobley
I have small test cluster of 2 nodes. I ran a stress test on it and with nodetool status received the following: /usr/local/bin/apache-cassandra-2.0.0-rc1/log $ ../bin/nodetool status Datacenter: datacenter1 === Status=Up/Down |/ State=Normal/Leaving/Joining/Moving --

RE: Vnodes, adding a node ?

2013-08-14 Thread Andrew Cobley
it after cleaning /var/lib/cassandra. Andy From: Richard Low [rich...@wentnet.com] Sent: 14 August 2013 20:11 To: user@cassandra.apache.org Subject: Re: Vnodes, adding a node ? On 14 August 2013 20:02, Andrew Cobley a.e.cob...@dundee.ac.ukmailto:a.e.cob

Re: Cassandra HANGS after some writes

2013-08-13 Thread Andrew Cobley
Agreed with Alain, There are a number of reasons that he may be running on windows, a development environment comes to mind,or simply to learn about C* BTW Has anyone ever done any performance comparisons of linux vs a headless windows server ? Andy On 13 Aug 2013, at 17:07, Alain RODRIGUEZ

Re: Any good GUI based tool to manage data in Casandra?

2013-08-12 Thread Andrew Cobley
Actually, is that true ? Certainly I guess most versions of C* run on Linux, but do most C* db admins use linux on the desktop ? Or ar they connecting form Mac/PC for management purposes ? Andy On 9 Aug 2013, at 21:11, Keith Freeman 8fo...@gmail.comhttp://gmail.com wrote: Sounds like a

Re: Counters and replication

2013-08-05 Thread Andrew Bialecki
We've seen high CPU in tests on stress tests with counters. With our workload, we had some hot counters (e.g. ones with 100s increments/sec) with RF = 3, which caused the load to spike and replicate on write tasks to back up on those three nodes. Richard already gave a good overview of why this

Re: Choosing Java Driver for using Cassandra with Java EE7

2013-08-03 Thread Andrew Cobley
I've used most of the java drivers under Glashfish without a problem. IMHO it's really down to the functionality you require in your application. The Java Driver form datastax has the lowest learning curve for any java programmer familiar with JDBC and I believe deals with pool management.

Re: Choosing Java Driver for using Cassandra with Java EE7

2013-08-03 Thread Andrew Cobley
Im referring to the core driver from datastax: https://github.com/datastax/java-driver You should be able to build it with maven. Andy On 3 Aug 2013, at 16:35, Jan Algermissen jan.algermis...@nordsc.com wrote: Hi Andrew, On 03.08.2013, at 14:30, Andrew Cobley a.e.cob...@dundee.ac.uk wrote

Re: Strange cassandra-stress results with 2.0.0 beta1

2013-07-25 Thread Andrew Cobley
administrator$ Andy C On 25 Jul 2013, at 15:28, Sávio Teles savio.te...@lupa.inf.ufg.brmailto:savio.te...@lupa.inf.ufg.br wrote: Some bug was fixed in 2.0.0-beta2 by C* developers. Try it! 2013/7/22 Andrew Cobley a.e.cob...@dundee.ac.ukmailto:a.e.cob...@dundee.ac.uk I've been noticing some strange

Re: Strange cassandra-stress results with 2.0.0 beta1

2013-07-25 Thread Andrew Cobley
So is that in Cassandra somewhere ? Any idea on how I can go about pinpointing the problem to raise a JIRA issue ? Andy On 25 Jul 2013, at 17:50, Radim Kolar h...@filez.com wrote: I'm wondering if it's a GC issue ? yes it is: 1039280992 used; max is 1052770304 most likely memory leak.

Re: Cassandra and RAIDs

2013-07-24 Thread Andrew Cobley
From: http://www.datastax.com/docs/1.2/cluster_architecture/cluster_planning * RAID on data disks: It is generally not necessary to use RAID for the following reasons: * Data is replicated across the cluster based on the replication factor you've chosen. * Starting in version 1.2,

Cassandra 2 vs Java 1.6

2013-07-22 Thread Andrew Cobley
I know it was decided to drop the requirement for Java 1.6 for cassandra some time ago, but my question is should 2.0.0-beta1http://www.apache.org/dyn/closer.cgi?path=/cassandra/2.0.0/apache-cassandra-2.0.0-beta1-bin.tar.gz run under java 1.6 at all ? I tried and got the following error:

RE: Cassandra 2 vs Java 1.6

2013-07-22 Thread Andrew Cobley
is 1.6 and 51 is 1.7). M. W dniu 22.07.2013 10:06, Andrew Cobley pisze: I know it was decided to drop the requirement for Java 1.6 for cassandra some time ago, but my question is should 2.0.0-beta1http://www.apache.org/dyn/closer.cgi?path=/cassandra/2.0.0/apache-cassandra-2.0.0-beta1-bin.tar.gz

Strange cassandra-stress results with 2.0.0 beta1

2013-07-22 Thread Andrew Cobley
I've been noticing some strange casandra-stress results with 2.0.0 beta 1. I've set up a single node on a Mac (4 gig ram, 2.8Ghz core 2 duo) and installed 2.0.0 beta1. When I run ./cassandra-stress -d 134.36.36.218 I'm seeing the interval-op-rate drop from a peek of 11562 at the start to 0

Re: Cassandra 2.0 : Ant build issue

2013-07-22 Thread Andrew Cobley
Are you using JDK 1.6. If so you'll need to get the 1.7 jdk (Java SE 7u25) from oracle to do the compile. See my message thread earlier today subject Cassandra 2 vs Java 1.6 for a few more details. Andy On 22 Jul 2013, at 20:16, Soumava Ghosh

RE: Cassandra 2.0 : Ant build issue

2013-07-22 Thread Andrew Cobley
1.7.0_21 (not 25 though).. soumava$ java -version java version 1.7.0_21 Java(TM) SE Runtime Environment (build 1.7.0_21-b12) Java HotSpot(TM) 64-Bit Server VM (build 23.21-b01, mixed mode) Thanks, Soumava On Mon, Jul 22, 2013 at 1:06 PM, Andrew Cobley a.e.cob...@dundee.ac.ukmailto:a.e.cob

RE: Cassandra 2.0 : Ant build issue

2013-07-22 Thread Andrew Cobley
To: user Subject: Re: Cassandra 2.0 : Ant build issue There you go: soumava$ javac -version javac 1.7.0_25 Thanks, Soumava On Mon, Jul 22, 2013 at 1:19 PM, Andrew Cobley a.e.cob...@dundee.ac.ukmailto:a.e.cob...@dundee.ac.uk wrote: What version do you get with javac -version ? Andy

RE: Cassandra 2.0 : Ant build issue

2013-07-22 Thread Andrew Cobley
: Cassandra 2.0 : Ant build issue Thanks Andrew! JAVA_HOME was the issue. It was not set, and I think that's why the build was somehow defaulting to /Library/Java/Home which was a 1.6 JDK. It should have been /Library/Java/JavaVirtualMachines/jdk1.7.0_25.jdk/Contents/Home. Setting JAVA_HOME

Re: Deletion use more space.

2013-07-16 Thread Andrew Bialecki
I don't think setting gc_grace_seconds to an hour is going to do what you'd expect. After gc_grace_seconds, if you haven't run a repair within that hour, the data you deleted will seem to have been undeleted. Someone correct me if I'm wrong, but in order to order to completely delete data and

Re: V2 Beta 1 bootstrap behaviour ?

2013-07-16 Thread Andrew Cobley
Righto ! Will do a JIRA report.. Many thanks Andy On 16 Jul 2013, at 18:50, Robert Coli rc...@eventbrite.commailto:rc...@eventbrite.com wrote: On Tue, Jul 16, 2013 at 1:16 AM, Andrew Cobley a.e.cob...@dundee.ac.ukmailto:a.e.cob...@dundee.ac.uk wrote: I'm setting up a new test cluster using

Re: node tool ring displays 33.33% owns on 3 node cluster with replication

2013-07-12 Thread Andrew Bialecki
include the keyspace as part of your query, you'll get it weighted by the RF of that keyspace. I believe the same logic applies for nodetool status. Andrew On Thu, Jul 11, 2013 at 12:58 PM, Jason Tyler jaty...@yahoo-inc.com wrote: Thanks Rob! I was able to confirm with getendpoints. Cheers

Lots of replicate on write tasks pending, want to investigate

2013-07-03 Thread Andrew Bialecki
is incrementing counters because disk reads are part of the write path for counters and are not for appending columns to a row. Does that logic make sense? Thanks in advance, Andrew

  1   2   >