Create keyspace on startup

[ghost]

Is there any way to copy a .cql script into the cassandra image which gets automatically executed as soon as cassandra is fully initialized and available on port 9042?

[rodrigorodrigues]

Hi all,

I have the same issue, is there one way to load a script after cassandra is ready?

I'm using Vagrant + docker-compose on Win 7.

[SpinGit]

Hi i have the same issue as well. I would like to configure a keyspace for my integration tests.

I'm using bitbucket pipeline and i have the following setup:

  default:
    - step:
        script:
          - sleep 15
          - npm test
        services:
          - cassandra
definitions:
  services:
    cassandra:
      image: cassandra
      environment:
        MAX_HEAP_SIZE: 512M # Need to restrict the heapsize or else Cassandra will OOM
        HEAP_NEWSIZE: 128M

I would like to have an environment variable to set the default keyspace, with an default strategey. Otherwise provisioning of an running cassandra db must be done with another docker container...

Thank you very much - Not sure if this issue is a problem of the docker image itself.

[ghost]

Hey guys, hope this helps ;-)

https://github.com/dschroe/cassandra-docker

[MatteoJoliveau]

@dschroe can you add a README with a short example about how to run your image?

[Chabane]

@dschroe not working, the CQL scripts are never executed

[ghost]

Can you share your configuration pls?

My dummy-configuration (docker-compose and .cql file) looks like this:

cassandra-db:
    image: dschroe/cassandra-docker
    restart: always
    volumes:
      - /cassandra:/var/lib/cassandra
      - ./db-schema:/docker-entrypoint-initdb.d/

CREATE KEYSPACE IF NOT EXISTS kspace WITH replication = 
{'class':'SimpleStrategy','replication_factor':'1'};

CREATE TABLE IF NOT EXISTS kspace.model
(
  timestamp timestamp,
  id varchar,
  PRIMARY KEY (id, timestamp)

) WITH CLUSTERING ORDER BY (timestamp DESC);

and it works fine for me.

[Chabane]

@dschroe Thanks for sharing!
If you put your configuration in the readme, I think the vote would be a more reasonable ;-)

It works with this solution https://stackoverflow.com/a/46037377

[daggerok]

I cannot use image: dschroe/cassandra-docker from dokerhub, but I can build from Dockerfile of repository @dschroe provided, ie:

git clone https://github.com/dschroe/cassandra-docker .

docker-compose.yml

version: "2.1"

services:

  cassadnra:
    image: 127.0.0.1:5000/cassandra
    build: .
    restart: unless-stopped
    ports: ["9042:9042"]
    volumes:
      - cassandra-data:/var/lib/cassandra
      - cassandra-data:/home/cassandra/.cassandra
      - ./docker-entrypoint-initdb.d:/docker-entrypoint-initdb.d
    networks: [backing-services]

volumes:
  cassandra-data: {}

networks:
  backing-services:

docker-entrypoint-initdb.d/init.cql

CREATE KEYSPACE IF NOT EXISTS demo WITH replication = 
{'class':'SimpleStrategy','replication_factor':'1'};

and then

docker-compose up --build
# ...
cassadnra_1  | INFO  [Native-Transport-Requests-2] 2017-10-06 20:59:03,847 MigrationManager.java:310 - Create new Keyspace: KeyspaceMetadata{name=demo, ...

see fork

---

Regards,
Maksim

[hantsy]

@daggerok I am using DockerToolbox under Windows 10, it seems the ./docker-entrypoint-initdb.d:/docker-entrypoint-initdb.d volume mapping does not work.

[daggerok]

Hi @hantsy,

unfortunately I have not tested it using toolbox on Windows 10
verified on Docker CE on OSX and Docker on Linux ubuntu

---

Regards

[moharnab123saikia]

@dschroe Your script worked for me on OSX. Thanks.

[tianon]

Closing in favor of #104 (comment) / https://stackoverflow.com/a/46037377/433558:

FROM cassandra

COPY entrypoint-wrap.sh /entrypoint-wrap.sh
ENTRYPOINT ["/entrypoint-wrap.sh"]
CMD ["cassandra", "-f"]

#!/bin/bash

if [[ ! -z "$CASSANDRA_KEYSPACE" && $1 = 'cassandra' ]]; then
  # Create default keyspace for single node cluster
  CQL="CREATE KEYSPACE $CASSANDRA_KEYSPACE WITH REPLICATION = {'class': 'SimpleStrategy', 'replication_factor': 1};"
  until echo $CQL | cqlsh; do
    echo "cqlsh: Cassandra is unavailable - retry later"
    sleep 2
  done &
fi

exec /docker-entrypoint.sh "$@"

👍

[aisven]

It is a very common use-case in software development. I do not like the workaround, because it means so many people now need to build their own C* Docker Images.

I would much prefer to see support for this Issue in the official Docker image.

[veysiertekin]

I was able to initialize Cassandra without a new Docker image by inspiring above comments.

I have added volumes and command sections to my compose.yml file:

version: '2.1'
...
  cassandra:
    image: cassandra:3.11.2
    volumes:
      - "./cassandra-init.sh:/cassandra-init.sh"
    command: "sh /cassandra-init.sh"
...

But called docker-entrypoint.sh at the end of cassandra-init.sh.
The contents of cassandra-init.sh:

cat >/import.cql <<EOF
DROP keyspace test;
CREATE keyspace test with replication = {'class':'SimpleStrategy', 'replication_factor' : 1};
EOF

# You may add some other conditionals that fits your stuation here
until cqlsh -f /import.cql; do
  echo "cqlsh: Cassandra is unavailable to initialize - will retry later"
  sleep 2
done &

exec /docker-entrypoint.sh "$@"

[veselinnguyen]

Why the issue has been closed? Has someone found already a solution?

[fogrizovic]

Hi,
I have succesfully tried the approach from @veysiertekin .

docker-compose.yml

cassandra:
    image: cassandra:2.1.20
    volumes:
      - "./cassandra-init.sh:/cassandra-init.sh"
    command: "sh /cassandra-init.sh"
    healthcheck:
      test: ["CMD-SHELL", "[ $$(nodetool statusgossip) = running ]"]

cassandra-init.sh

CQL="DROP keyspace name;
CREATE KEYSPACE name WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '1'} AND durable_writes = true;
CREATE TABLE name.blabla (search_hash text, PRIMARY KEY (search_hash));"

until echo $CQL | cqlsh; do
  echo "cqlsh: Cassandra is unavailable to initialize - will retry later"
  sleep 2
done &

exec /docker-entrypoint.sh "$@"

[edugmes]

Hi, I have succesfully tried the approach from @veysiertekin .

docker-compose.yml

cassandra:
    image: cassandra:2.1.20
    volumes:
      - "./cassandra-init.sh:/cassandra-init.sh"
    command: "sh /cassandra-init.sh"
    healthcheck:
      test: ["CMD-SHELL", "[ $$(nodetool statusgossip) = running ]"]

cassandra-init.sh

CQL="DROP keyspace name;
CREATE KEYSPACE name WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '1'} AND durable_writes = true;
CREATE TABLE name.blabla (search_hash text, PRIMARY KEY (search_hash));"

until echo $CQL | cqlsh; do
  echo "cqlsh: Cassandra is unavailable to initialize - will retry later"
  sleep 2
done &

exec /docker-entrypoint.sh "$@"

Thanks for your script! I got it working by adding a if not exists on the create keyspace command. Without that the loop would run indefinately, even after the keyspace was created, as the command would return false to until. The version I used:

cas_query="create keyspace if not exists posts_k with replication = {'class': 'SimpleStrategy', 'replication_factor': 2};"

until echo $cas_query | cqlsh
do
	now=$(date +%T)
	echo "[$now INIT CQLSH]: Node still unavailable, will retry another time"
	sleep 2
done &

exec /usr/local/bin/docker-entrypoint.sh "$@"