Questions tagged [cassandra]
Apache Cassandra is an open source distributed key-value database cluster, designed to scale linearly when adding nodes. It provides multi-datacenter replication.
215
questions
0
votes
0
answers
13
views
Necessity to backup Cassandra system keyspaces
I was wondering about the necessity to backup (in order to restore of course) the system keyspaces of Cassandra.
My backup/restore procedure is the following:
backup: snapshots (nodetool) + dump of ...
- 311
0
votes
0
answers
258
views
Connection error: (Unable to connect to any servers, {127.0.0.1:9042: ConnectionRefusedError(111, Tried connecting to [(127.0.0.1, 9042)]
Sometimes when I try cqlsh command on my Ubuntu 22.04 machine I get the following error:
Connection error: (Unable to connect to any servers, {127.0.0.1:9042:
ConnectionRefusedError(111, Tried ...
- 337
1
vote
1
answer
35
views
What data type do big applications use to store time data?
I am trying to find out which data type is better to store time data inside either MySQL or Cassandra database for a big application like Facebook or Instagram? There are a lot of similar questions ...
- 337
2
votes
1
answer
197
views
Is it better to generate "UUID" and "TIMESTAMP" within the NodeJS application or using the database built-in functions?
I am writing a TypeScript-NodeJS application and want to handle object ids and created_at TIMESTAMP within the NodeJS application, instead of using MySQL or Cassandra built-in UUID or TIMESTAMP ...
- 337
-1
votes
1
answer
133
views
How can I release previously allocated resources of a deleted pod?
I already had 3 Cassandra node/pods running. I deleted them and tried to re create them again using the same YAML file as following, on the same Kind cluster, but it stuck pending status:
apiVersion: ...
- 337
0
votes
1
answer
39
views
How should I replace this line "provisioner: k8s.io/minikube-hostpath" for a "Kind" statefulset.yaml file?
The following is a StatefulSet.yaml file for deploying Cassandra database on a minikube cluster. I am not sure what lines should be replaced if I want to use a Kind cluster instead of a minikube one, ...
- 337
0
votes
2
answers
613
views
What is the equivalent command of "minikube start --memory 5120 --cpus=4" for "Kind"?
Here in Cassandra deployment instruction, it says:
Caution:
Minikube defaults to 2048MB of memory and 2 CPU. Running Minikube with
the default resource configuration results in insufficient resource
...
- 337
0
votes
1
answer
53
views
When and How we should specify "clusterIP" inside the "service.yaml" file?
I tried to deploy mysql and cassandra databases using kubernetes.io/docs instructions. In both of them, within the service.yaml files, they use clusterIP: None like following:
For cassandra:
...
- 337
0
votes
1
answer
101
views
Why "Cassandra" uses "StatefulSet" instead of "Deploymdnt" file for "Kubernetes"?
I am trying to deploy Cassandra on my local Kind cluster running on my Ubuntu 22.04 machine. The only instruction I found is this, that uses a StatefulSet for that. I am just wondering to know, isn't ...
- 337
0
votes
0
answers
134
views
Finding pending cassandra pending compactions information
I am trying to understand the pending compaction statistics that are displayed by cassandra nodetool that can be seen two ways. I am on cassandra 3.11.3. Why would the compaction statistics be ...
0
votes
0
answers
23
views
Is there any way to take scylla db snapshot from a remote server
We have a disk space issue.
So, in order to upgrade the node , we are thinking of taking a snapshot before the upgrade of the node.
So, in order to not disturb the existing disk space, is there any ...
2
votes
1
answer
1k
views
Which version of the JDK should we install for Cassandra 4.0.1
We are planning to upgrade our Cassandra servers from 3.0.11 to 4.0.1
Here it says to use JDK 8. I would like to know if as of this writing this is still the case. I believe the latest released Oracle ...
- 123
1
vote
0
answers
1k
views
High CPU usage and traffic on some Cassandra nodes
As stated in the title, we are having a problem with our Cassandra cluster. There are 9 nodes with a replication factor of 3 using NetworkTopologyStrategy. All in the same DC and Rack. Cassandra ...
1
vote
0
answers
79
views
Throttle Spark Cassandra Connector Reads on a Production Cluster
We're currently running a 24 Node Cassandra Cluster in Production that holds 30Tb of data and handles an average live load of 100k Requests Per Min 24/7. We support multiple partners. One of our ...
- 11
0
votes
1
answer
359
views
Does Cassandra rebalance the data after inserting additional disks?
I'm running a Cassandra cluster with 5 nodes, each having 10 1Tb disks (JBOD). Currently, one of the nodes is in the problematic situation where a large compaction can no longer succesfully complete ...
- 3
0
votes
1
answer
1k
views
Spark-Cassandra-Connector Issue Exception in thread "main" java.lang.NoClassDefFoundError: com/datastax/spark/connector/rdd/reader/RowReaderFactory
What is going wrong with the Spark Cassandra Connector could you please help to solve this?
Scala File:
import com.datastax.spark.connector._
import org.apache.spark.sql.SparkSession
import org.apache....
0
votes
0
answers
91
views
Required best GUI of Cassandra DB for user interface communication
I am new to the Cassandra DB. Started learning using the command shell.
I am searching for the GUI, so please suggest me the best GUI for the Cassandra DB.
GUI should have all features like DDL, DML, ...
0
votes
1
answer
212
views
Cassandra NAMED datacenter
After a day of research, I open a question.
I can't rename a cassandra node. I would like to put a node at D1, and another one at D2 both in rack1.
But here is the result I get
$ nodetool status
...
- 3
0
votes
1
answer
51
views
cassandra backup - errors during compression
My cassandra backup often returns with errors because users move/change it during the compression (we just tar it). Users are logged to the server 24/7 so we can't just change backup hours.
I need ...
0
votes
1
answer
887
views
cassandra replication not 100 percent on each node
I had Cassandra cluster of 3 nodes. I was performing some colud migration activity and for that, I added two more nodes in an existing cluster and the result is as follows.
Datacenter: datacenter1
===...
- 21
0
votes
1
answer
748
views
Elassandra "action_request_validation_exception"
Elasticsearch DEBUG: 2019-09-23T09:23:39Z
starting request {
"method": "HEAD",
"castExists": true,
"path": "/my_keyspace",
"query": {}
}
Elasticsearch TRACE: 2019-09-23T09:23:39Z
...
- 193
0
votes
1
answer
340
views
System_auth keyspace overwritten in Cassandra cluster
I was adding a Node2 to another cassandra Node1 to form a cluster and I lost my user database (which caused authentication problems). I appreciate if someone can help me to understand what happened (...
- 111
1
vote
1
answer
385
views
Apache Cassandra repair snapshots are not deleted
On a Cassandra cluster running Apache Cassandra 3.11.4 that is repaired using Cassandra Reaper 1.4.1, I am experiencing the problem that the snapshots that are created by the repair process are ...
1
vote
0
answers
57
views
Risks of adding Cassandra 3.11 nodes to a 2.1 cluster
We're running DSE v4.8.5 (which uses Cassandra 2.1.13), and we need to migrate to the community edition of Cassandra v3.11 and then retire the old DSE servers.
Someone (it might have been me) ...
- 11
0
votes
1
answer
205
views
Access Cassandra on Google Cloud - Kubernetes from local DataStax Studio
I've setup Cassandra cluster on Kubernetes on GCP. I can very well execute the cqlsh from my local machine, using the CLI. However, I've DataStax Studio installed in my machine and I wish to access ...
- 1
0
votes
1
answer
167
views
Cassandra long queries (33s for dropping empty table)
Currently trying a setup for a large project.
The project will utilize tens of thousands of tables to chunk the big data into separate pieces that are faster to search. So to test this I'm creating ...
- 1
0
votes
1
answer
730
views
Connection refused with internal private DNS name
I have a Cassandra cluster set up on 5 EC2 nodes. The nodes can communicate using the private IP addresses just fine, but get connection failures when using the private internal DNS name. Localhost ...
- 121
1
vote
1
answer
6k
views
Can't authenticate to cassandra: cannot achieve consistency level LOCAL_ONE
Context:
We have a Cassandra cluster with 3 nodes deployed as a Stateful Set in Openshift. The three nodes are configured in the same datacenter, same rack.
I also made a script to test the ...
- 360
1
vote
0
answers
1k
views
How to use Cassandra with Spark in a Docker image?
(I hope this question is fit for ServerFault, if not, comment and I'll delete it)
I'm trying to create a docker image where Cassandra and Spark would be installed and configured to work together.
I ...
- 113
0
votes
1
answer
93
views
What happens when I insert empty column families in cassandra. How many memtables and sstables will be created?
What happens when I insert empty column families in cassandra. How many memtables and sstables will be created ?
1
vote
1
answer
46
views
I have 2 DCs, RF is 3 in both of them and consistency is set to quorum. What will happen when a read/write request comes and one of the DC is down?
I have 2 DCs, RF is 3 in both of them and consistency is set to quorum. What will happen when a read/write request comes and one of the DC is down ?
3
votes
1
answer
2k
views
How to restrict Cassandra to use fixed memory
We are using Cassandra in order to collect data from Thingsboard. The memory it started with was 4GB (after executing the systemctl status for Cassandra) and after 15 hours it has reached up to 9.3GB. ...
- 131
1
vote
1
answer
130
views
Should I see identical sstables on multiple cassandra nodes?
We're trying to verify the state of replication in our cassandra cluster. My colleague has found that only a small number of sstable files exist on multiple nodes. The others are all unique.
To me, ...
- 223
0
votes
1
answer
1k
views
Can't remove tombstones cells in Cassandra
we are using a cassandra single node cluster for experimenting and one problem we are hitting now is tombstones cells. Each row contain 2 tombstone cells and we are stuck in trying to remove them. ...
- 121
0
votes
1
answer
254
views
Trigger compactions when TWCS TTL changes in Cassandra 3.0
I have a table in cassandra where I saved data using clients TTL = 1 month (tables TTL is 0), the table is configured with time window compaction strategy.
Everyday Cassandra cleaned one single ...
- 101
1
vote
1
answer
3k
views
cassandra port is closed
I am trying to connect to a cassandra installation from a remote machine. Cassandra is running the thrift service on 9160 which is the default port. But I cannot connect the DB and I always get ...
- 13
0
votes
1
answer
1k
views
Unable to start Cassandra cluster after configure SSL configuration
I configured client-node encryption using reference http://cloudurable.com/blog/cassandra-ssl-cluster-setup/index.html
cassandra version 2.1.16
java version jdk1.8.0_131
JCE version JAVA 8
netty-all-...
- 1
4
votes
1
answer
3k
views
Error When Starting Cassandra for First Time [closed]
I'm trying to get a single-node cluster of Cassandra set up on my VPS for a school project. So I installed cassandra on Ubuntu 16.04 (JVM 1.8.0_161), but when I run, I encounter this error... https://...
- 593
1
vote
1
answer
823
views
Cassandra multinode installation,Cannot open file /var/log/cassandra/gc.log due to Permission denied
I want to install Cassandra on 4 remote nodes.
Everything works fine until I come to point when I check status
nodetool status
Datacenter: datacenter1
=======================
Status=Up/Down
|/ State=...
- 323
0
votes
1
answer
537
views
.UnavailableSocketError: Inet address 127.0.0.1:7000 is not available
I tried to create a cluster with three Cassandra nodes on my machine.I have unpacked tar.gz and changed listen and rpc_addresses, also JMX_PORT.It did not work
~/apache-cassandra-3.11.1-1/bin$ ...
- 323
1
vote
0
answers
232
views
How to edit my host file to enable three Cassandra nodes?
This is my /etc/host
cat /etc/hosts
127.0.0.1 localhost
127.0.1.1 jholmes-System-Product-Name
My nodetool status
nodetool --host 127.0.0.1 status
Datacenter: datacenter1
=======================
...
- 323
1
vote
1
answer
2k
views
What is the side effect of having Cassandra tables with partition sizes of more than 100MB?
I am running Apache Cassandra 3.11.1 and have 6 tables sizes in the failing state.
Max partition is larger than 100MB.
For these 6 tables the partition sizes are on average between 200MB and upwards ...
0
votes
0
answers
67
views
Not able to open doors on router
I have a Cassandra broker in my lan and I want to allow to execute query on it from the web.
So I made an association on my router (vodafone station revolution) between the external port 9042 with ...
- 135
1
vote
1
answer
444
views
How to do an automated Restore of Cassandra Backup(Snapshot)?
I do have a single node Cassandra EC2 instance (apache-cassandra-3.10), in which I take snapshots (backup) on daily basis and upload it on AWS S3.
I also take the backup of complete "schema" and "...
1
vote
1
answer
570
views
Can't access Cassandra remote node
I’m using cassandra on a remote node I can access just with console.
Since the node has a private ip, the cluster manager set a proxy to access private_ip:9042 in order to allow me to execute query ...
- 135
0
votes
1
answer
2k
views
Cassandra initial token in cassandra.yaml
I followed the following steps to migrate all the data from one cluster to a completely new cluster:
http://datascale.io/cloning-cassandra-clusters-fast-way/
I managed to get all the data to the new ...
- 321
0
votes
1
answer
456
views
Ubuntu - Install cassandra version 3.0.9 fails: Version '3.0.9' for 'cassandra' was not found
I have ansible scripts that were used to provision some cassandra servers a couple months ago.
They are failing now on this command:
ubuntu@ip-172-30-0-193:~$ sudo apt-get install cassandra=3.0.9
...
- 123
1
vote
0
answers
247
views
Apache Cassandra / Presto select query
We have 2 node cluster with RF2. When we select data using Presto and passing all partition key in where condition. Sometime data is returned and sometimes it is not though the cqlsh does return data ...
- 157
3
votes
0
answers
5k
views
Cassandra ReadTimeout: code=1200 - Coordinator node timed out waiting for replica nodes
I've got 3 node cluster on DSE 4.8.8 with replication factor = 2 and consistency on write quorum and on read one. When I'm trying to select some of the data I get this error:
cqlsh:production> ...
2
votes
0
answers
241
views
Monitoring Cassandra Server Logs?
I've done some searching and have not found any examples of people using something like FluentD to forward Cassandra log file data (system.log) to a log indexer.
Is this something any is doing? If ...
- 123