Apache Cassandra is an open source distributed database management system.

learn more… | top users | synonyms

0
votes
0answers
10 views

Cassandra database design with long row [closed]

I have project I need to move from mongodb to cassandra. Problem is I have query that selects last 1000 "items" sorted by insert time. This is like "select item from x order by created desc" The way ...
0
votes
1answer
42 views

EBS vs Instance Local storage for MongoDB in ec2

Cassandra recommends using instance local storage for EC2 deployments instead of EBS I am deploying MongoDB in EC2... should I also be using instance local storage instead of EBS PIOPS?
0
votes
0answers
37 views

nodetool repair fails with snapshot error

When running nodetool repair, the repair fails on the system_auth keyspace with the following log entries: INFO [AntiEntropySessions:5] 2015-03-17 20:00:34,795 RepairSession.java:260 - [repair ...
0
votes
1answer
230 views

datastax-agent Cannot connect Error

Seeing an issue with the Opscenter Agents. Opscenter reports the agents are not connected and in the agent.log on each node, they all report the following: ...
-1
votes
1answer
27 views

Cassandra versions supported in OpsCenter 5.1.0

We are planning to use Cassandra 2.0.11 but the latest OpsCenter 5.1.0 doesn't support creating a new cluster with Cassandra 2.0.11 package. It shows only 2.0.9. How do we proceed?
1
vote
3answers
358 views

DataStax OpsCenter agent fails to start when Cassandra requires authentication

Problem I can not get OpsCenter get to connect to datastax-agent. It seems that datastax-agent starts and tries to connect to cassandra, fails because it does not know the correct credentials, but it ...
0
votes
0answers
44 views

cassandra on centos 7 - service control issues

I'm trying to join a set of new CentOS 7 servers to an existing cassandra cluster. All systems are running the same version (2.1.2). Running into these problems and would appreciate some pointers: ...
2
votes
1answer
55 views

Incredibly high load average on a Centos server

I have a Centos 6.4 server that's being used as a Cassandra node in a production environment, it is still working and responding to queries etc, but the load average is rather "high" a.k.a. buggy? In ...
1
vote
1answer
47 views

4 node cassandra - skip redundancy?

After much pleading and case building my group got the budget to buy 4 nodes and start a cassandra cluster. Each machine has 3x1Tb drives so I'm wondering whether it's reasonable to skip the 1 way ...
0
votes
0answers
20 views

opscenter agent -f works

I feel certain this is something fairly basic that I'm missing, I'm new to Cassandra and very new to Opscenter and the agent. In brief, Opscenter is working fine and the agent install seems to have ...
2
votes
1answer
134 views

Tunneling cassandra via ssh gives me a connection closed error

I have a server with two network interfaces. Cassandra is listening on a dedicated internal database network on eth1 (not accessable from outside). So I do my tunnel like this: ssh -f -N ...
1
vote
0answers
128 views

Repairing OpsCenter rollups60 Results in Snapshot Errors

I am running a 6 node cluster using Apache Cassandra 2.1.2 with DataStax OpsCenter 5.0.2 from the AWS EC2 AMI "DataStax Auto-Clustering AMI 2.5.1-hvm" (DataStax Community AMI). When I try to run a ...
0
votes
0answers
56 views

OpsCenter : Error loading column family: Make sure all agents are running and connected properly

I'm using OpsCenter version: 5.0.2 and Cassandra 2.1.2 on localhost. I can access keyspaces and see columns list, but when trying to display content of any column I'm getting message: Error ...
0
votes
1answer
32 views

datastax opscenter - how is 'storage capacity' determined?

I installed the OS version this recently (5.0.2) and am wondering about this graph. To date I've had a hard time finding a metric for 'cluster capacity' when it comes to Cassandra. Magically, datastax ...
2
votes
1answer
242 views

Cassandra: do more storage size, needs more CPU and RAM

I have gone through the recommended architecture of the Cassandra node configuration! according to which the recommended hardware infrastructure for the node is to have RAM: 16-32 GB, storage: 500GB ...
0
votes
0answers
402 views

Opscenter is connected to datastax agents but no data available

We installed opscenter and datastax agents on a cluster with private network through datastax community packages. Configurations seems to be ok and we don't have connectivity issues on jmx or stomp. ...
0
votes
1answer
54 views

How to avoid constant schema disagreement flapping in Cassandra?

We have a 3 node Cassandra cluster with a small amount of data on 'em (about 2.3GB total). The nodes are hosted on GCE and each have four cores and 16GB memory. We're running the Debian package build ...
8
votes
1answer
497 views

How to resolve a stuck major compaction in Apache Cassandra?

I've got a one-node Cassandra cluster which is currently stuck in a major compaction process. After executing a nodetool compactit started the compaction and I see the tmp-sstable files with a size of ...
0
votes
1answer
72 views

Change hostname in datastax-agent

I've noticed when working in Opscenter that all the nodes are displayed with the result of hostname and their IP address. For an ec2 host this is a little redundant since the hostnames look like ...
1
vote
1answer
16 views

cassandra setup - uneven load - what did I do wrong?

For the sake of understanding I setup a 4 node cluster using the latest/greatest(released) version of Cassandra. The four nodes were brought up in sequence using almost entirely default settings and ...
1
vote
1answer
155 views

cassandra nodetool repair - how to schedule properly?

Im putting together a 16 node cassandra cluster (replication factor 2) and want to setup a schedule for nodetool repair. gc_grace_seconds is at the default. Two questions: My first impulse is to ...
0
votes
2answers
96 views

Cassandra: understanding replication factor

Hypothetical situation: Setup a cassandra cluster with N nodes. Create a keyspace and set replication_factor to 1 and use SimpleStrategy. Add some data. Remove 1 node. Does this mean that 1/N of ...
0
votes
1answer
72 views

Which direction does `nodetool repair` go?

Let's say I log into a Cassandra node X and issue nodetool repair. Will I only repair the data residing on X? Or will I also automatically repair all other nodes that have replicas of what X holds ...
0
votes
1answer
91 views

Agent connected to Opscenter but no data available

I'm currently running Cassandra, the OpsCenter, and the OpsCenter agent all on my dev Windows box. The agent is successfully connected to OpsCenter and I can see it listed there along with the amount ...
0
votes
1answer
129 views

Can't get datastax-agent to run on a new node

I'm trying to install the datastax-agent on a new CentOS node (there are 3 other nodes currently up and running correctly). After installing the datastax-agent via the Opscenter UI it appears to ...
0
votes
1answer
30 views

Cassandra: when to add capacity?

How does one know when it's time to add capacity to a cassandra cluster? Error msgs? Performance? Some other tell-tale sign? Since capacity planning with Cassandra is a (seemingly) black art knowing ...
1
vote
0answers
80 views

When adding data to cassandra cluster from C#, I get an this exception

From C# when I try to add data to a cassandra cluster, I get this exception: {Not enough replicas available for query at consistency One (1 required but only 0 alive)"} When I run nodetool from ...
0
votes
1answer
70 views

Multiple data centers and DataStax OpsCenter

Multiple questions regarding DataStax OpsCenter. I am evaluating for our use OpsCenter 5.0.1 I am able to build a cassandra cluster using opscenter sucessfully. However, all nodes belong to one ...
1
vote
1answer
59 views

Datastax Opscenter 5.0: Getting “InvalidGroup.NotFound” when adding node via AWS

I am getting an "InvalidGroup.NotFound" when trying to add an additional node to my cluster through OpsCenter via AWS. The existing node running OpsCenter is in the VPC and is already using the ...
1
vote
1answer
127 views

Operator \> and \< (string version comparison) are not recognised in shell script

I am trying to run Casandra nodetool and getting warnings coming from .sh script. [root@d11ca4cc-fa95-c8a9-e133-e64c434f0e6f ~]# nodetool status /opt/local/share/cassandra/bin/nodetool[53]: .[97]: ...
0
votes
2answers
174 views

azure endpoint for cassandra does not work for ports 7000, 7001, 7199

I have setup apache cassandra on a centos7 compatible linux machine in azure. I can telnet directly to port 7000, etc on the IP address on the machine, however I cannot telnet to that same port from ...
0
votes
0answers
33 views

Cassandra 2.x - Problems with not accessible data

I had 3 nodes with 1.5TB of data. At some point my import hit a wall as disk space ended on one of those 3 nodes. I've resized disks and added 4 more nodes and 1.5TB of data more. I did also repair ...
0
votes
1answer
106 views

How to authenticate with cassandra-stress 2.1

Is there a way to authenticate to cassandra using the new cassandra-stress tool released with cassandra 2.1? It appears as if the '-un' (username) and '-pw' (password) switches have been removed from ...
0
votes
1answer
732 views

Cassandra 2.x - cluster does not rebalance after adding new nodes

I had 3 nodes, all with ~550GB, and added 4 more. I hoped that data would migrate on its own from old servers to new ones. Unfortunately after one day, data seems to stay in old places. In parallel, ...
1
vote
0answers
75 views

VPN load balancing between AWS regions for DataStax cluster

I am testing some DataStax Enterprise clusters in different AWS regions and working on a desirable architecture. Currently - I have one cluster with datacenters in us-east, us-west, and eu-ireland. I ...
1
vote
1answer
123 views

DataStax OpsCenter 5.0.0 API doesn't increase last_seen when nodes down if DataStax OpsCenter Agent is down, used to work with 3.2.2

I've been using the DataStax OpsCenter (Enterprise) 5.0.0 REST API with DSE 4.5.1 (Cassandra 2.0.9) to query the /$cluster_name/nodes endpoint and see the last_seen field for the number of seconds ...
2
votes
0answers
122 views

Does nodetool repair repair the next node?

Let's assume we have a Cassandra cluster with the following ring: A -> B -> C -> D (no virtual nodes), and we assume that all the data is stored at RF=2. Now let's say that B dies, leaving us ...
-2
votes
1answer
147 views

OpsCenter on AWS: No permission to create /mnt/cassandra/data directory [closed]

Followed the instructions here: http://www.datastax.com/documentation/cassandra/2.0/cassandra/install/installAMILaunch.html Installed OpsCenter on m3.large. When launching an instance, I get this ...
0
votes
0answers
82 views

Broken apt trying to install Cassandra

While trying to install Cassandra on Ubuntu 13.10, the installation crashed and now I'm stuck with broken (?) apt-get. Here is the output of an apt-get install -f: Reading package lists... Done ...
0
votes
1answer
35 views

How to copy perf graphs from one user to another in datastax OpsCenter?

I have lots of perf graphs in datastax OpsCenter under my "admin" user. I've created a new read-only user that i can let anyone in the company use, but how do i copy all the already configured perf ...
-2
votes
1answer
285 views

DataStax OpsCenter - can't connect with agents

I've installed DataStax OpsCenter (Apache Cassandra) and in OpsCenter, there is an error: "0 of 1 agents connected". When I click "fix", enter credentials and try to install nodes, i get error: ...
0
votes
0answers
144 views

Creating Table in mariaDB - ERROR 1429 (HY000)

I successfully integrated mariaDB-10.0.13 with Cassandra-2.0.8 and 2.0.9 I was able to created a table present in cassandra on mariaDB and was able to query successfully. But my problem is that ...
1
vote
1answer
345 views

Opscenter is unable to install agents due permission denied to /tmp

O am not able to install agents on 10.0.0.29 IP through opscenter. It says below error. The user is pavan and this user is having sudo access. Opscenter is unable to install the agents and I'm not ...
1
vote
1answer
905 views

Setting-up OpsCenter gives: scp /tmp/.. Permission denied

I'm trying to setup OpsCenter by adding my localhost Cassandra node (for testing). The login credentials I used for SSH has sudo/root rights, nevertheless I get the error: scp: /tmp/tmpXInRfq: ...
1
vote
0answers
201 views

Adding Cassandra Node in OpenShift to Existing Cluster

I have 3 cassandra nodes(S1,S2,S3) which are installed on CentOS 6. Two of them (S1,S2) are in datacenter A and one of them (S3) is in openshift. I am trying to make benchmark test with multiple node ...
0
votes
1answer
515 views

OpsCenter 5.0: No Data on Dashboard Graphs

I have an OpsCenter 5.0 instance running and 10 agents connected. The agents are in 2 regions in AWS, so everything is using external addresses to communication. All the necessary ports are open, ...
0
votes
1answer
68 views

Opscenter 5.0: User management query

I've installed the free tarball version of opscenter and am having problems with the user management aspect of it. I have authentication enabled via: [authentication] enabled = true ...and can ...
0
votes
1answer
459 views

Opscenter 5.0: error when adding cluster, cluster added anyway, no clusters shown

I have a new Opscenter installation. After adding my "existing cluster" to opscenter, I get the following error dialog boxes: Error creating cluster: Cannot read property 'datasource' of undefined ...
0
votes
1answer
57 views

Cassandra - moving data from multiple nodes to a single node

I need to copy data from 3 nodes to a single node. I know about snapshot command and I was able to successfully copy data from a cluster where each node had 100% data (full replication) to a ...
0
votes
1answer
100 views

Opscenter 4.1.4: Authentication failing

I'm getting authentication errors when starting the opscenter agents on each of my cassandra (v1.2.5) nodes: INFO [main] 2014-07-23 12:18:03,880 Starting Stomp INFO [main] 2014-07-23 12:18:03,881 SSL ...