blob: da6bbb184cf0a0645011002ee0fe4710297f82d1 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
|
#!/bin/bash
CASSANDRA_USER=asdc_user
CASSANDRA_PASS='Aa1234%^!'
KEYSPACE="CREATE KEYSPACE IF NOT EXISTS dox WITH REPLICATION = { 'class' : 'NetworkTopologyStrategy', '<%= @DC_NAME %>': '1'};"
KEYSPACE1="CREATE KEYSPACE IF NOT EXISTS zusammen_dox WITH REPLICATION = { 'class' : 'NetworkTopologyStrategy', '<%= @DC_NAME %>': '1'};"
echo "run create_dox_keyspace.cql"
echo -e "$KEYSPACE\n$KEYSPACE1" > /tmp/create_dox_keyspace.cql
chmod 755 /tmp/create_dox_keyspace.cql
cqlsh -u $CASSANDRA_USER -p $CASSANDRA_PASS -f /tmp/create_dox_keyspace.cql > /dev/null 2>&1
CS_VERSION=`cassandra -v`
CS_MAJOR_VERSION=`cassandra -v | cut -c1`
if [ ${CS_MAJOR_VERSION} -gt 2 ]; then
echo "`date` --- CS [${CS_VERSION}] uses system_schema.keyspaces"
res=`echo "select keyspace_name from system_schema.keyspaces ;" | cqlsh -u $CASSANDRA_USER -p $CASSANDRA_PASS |grep -c dox 2>/dev/null`
else
echo "`date` --- CS [${CS_VERSION}] uses system.schema_keyspaces"
res=`echo "select keyspace_name from system.schema_keyspaces ;" | cqlsh -u $CASSANDRA_USER -p $CASSANDRA_PASS |grep -c dox 2>/dev/null`
fi
if [ $res -gt 0 ]; then
echo "`date` --- dox keyspace was created "
else
echo "`date` --- Failed to create dox keyspace"
fi
echo "run create_dox_db.cql"
chmod 755 /tmp/create_dox_db.cql
cqlsh -u $CASSANDRA_USER -p $CASSANDRA_PASS -f /tmp/create_dox_db.cql > /dev/null 2>&1
$res=$?
if [ $res -gt 0 ]; then
echo "`date` --- dox keyspace: create_dox_db.cql failed ! "
else
echo "`date` --- dox keyspace: create_dox_db.cql completed successfully "
fi
sleep 10
echo "run alter_dox_db.cql"
chmod 755 /tmp/alter_dox_db.cql
cqlsh -u $CASSANDRA_USER -p $CASSANDRA_PASS -f /tmp/alter_dox_db.cql > /dev/null 2>&1
$res=$?
if [ $res -gt 0 ]; then
echo "`date` --- dox keyspace: alter_dox_db.cql failed !"
else
echo "`date` --- dox keyspace: alter_dox_db.cql completed successfully "
fi
|
