Is it possible to get the OS Cassandra is installed on using CQL? For example in PostgreSQL you can run the query select version(); which will return: PostgreSQL 11.12 (Debian 11.12-0+deb10u1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit…
I have installed Cassandra database on my CentOs system. after that, I tried to install the Cqlsh package using this command sudo yum install cqlsh and it has been installed successfully. but when I tried to run cqlsh from the…
I've a simple crud based application in which Apache Cassandra is used as the default database. I've used Spring Data Cassandra for the Cassandra connectivity. Now, I'm trying to move into AWS Keyspace which which is well supported with the…
I've been trying to start a mongoDB and cassandra container and make them pass two simple health checks, but they keep failing no matter what health check I put: For mongoDB, here's my yml file: version: '3.1' services: mongo: image:…
I‘m rather new to distributed databases, though I have already studied related literature (e.g. CAP theorem, CRDT) and implemented some POC to allow scaling my application horizontally. Now I however face a challenging problem. In ordere to scale the app…
the local DC must be explicitly set (see basic.load-balancing-policy.local-datacenter in the config, or set it programmatically with SessionBuilder.withLocalDatacenter) Running single node cluster on localhost. Able to query cassandra keyspace using cqlsh. Running Cassandra Version: 3.11.8 Using Spring Boot Version: 2.3.4…
In this config : 64 Gb, 16 cores, Linux CentOS with Cassandra 3.1 row_cache_size_in_mb is set to zero now (cassandra.yaml) It seems working well since the OS Page cache is used for caching read. So, is there any benefits/risks (JVM…
I have a join query which takes a lot of time to process. SELECT COUNT(c.id) FROM `customers` AS `c` LEFT JOIN `setting` AS `ssh` ON `c`.`shop_id` = `ssh`.`id` LEFT JOIN `customer_extra` AS `cx` ON `c`.`id` = `cx`.`customer_id` LEFT JOIN `customers_address`…
I have installed docker on redhat/centos server. docker services are running fine but how I can install or build cassandra/scylla image on docker. my server is not connected with internet so while building cassandra/scylla image or run then getting below…
I am running Cassandra 2.2.14 on a virtual machine (CentOS). The issue is that I cannot run the command "cqlsh" to create tables and keyspaces. when I was tipping at the terminal: cqlsh localhost ks-schema-local.cql bash shell : bash: cqlsh:…