Cassandra Database(8)Upgrade to 2.1.2 and OpsCenter
Our project is using version 1.2.13. The latest version is 2.1.2 now.
Some example about the 2.0.4 version, using java driver and cqlsh http://sillycat.iteye.com/admin/blogs/2011991.
Configure the cluster without other tool, http://sillycat.iteye.com/blog/2166583.
Backup and restore data
1. Useful command
List all the key spaces we have.
> describe keyspaces;
Show the structure of the one key space and its tables.
> describe keyspace device_lookup;
CREATE KEYSPACE device_lookup WITH replication = {
'class': 'SimpleStrategy',
'replication_factor': '2'
};
USE device_lookup;
CREATE TABLE profile_devices (
brandcode ascii,
profileid bigint,
deviceid ascii,
PRIMARY KEY ((brandcode, profileid), deviceid)
) WITH COMPACT STORAGE AND
bloom_filter_fp_chance=0.100000 AND
caching='KEYS_ONLY' AND
comment='' AND
dclocal_read_repair_chance=0.000000 AND
gc_grace_seconds=864000 AND
read_repair_chance=0.100000 AND
replicate_on_write='true' AND
populate_io_cache_on_flush='false' AND
compaction={'sstable_size_in_mb': '5', 'class': 'LeveledCompactionStrategy'} AND
'class': 'SimpleStrategy',
'replication_factor': '2'
};
USE device_lookup;
CREATE TABLE profile_devices (
brandcode ascii,
profileid bigint,
deviceid ascii,
PRIMARY KEY ((brandcode, profileid), deviceid)
) WITH COMPACT STORAGE AND
bloom_filter_fp_chance=0.100000 AND
caching='KEYS_ONLY' AND
comment='' AND
dclocal_read_repair_chance=0.000000 AND
gc_grace_seconds=864000 AND
read_repair_chance=0.100000 AND
replicate_on_write='true' AND
populate_io_cache_on_flush='false' AND
compaction={'sstable_size_in_mb': '5', 'class': 'LeveledCompactionStrategy'} AND
compression={'sstable_compression': 'SnappyCompressor'};
Opscenter
2. Try Install the Latest Version
Set it up as normal. Edit the cassandra.yaml
listen_address: ubuntu-dev1
seed_provider:
# Addresses of hosts that are deemed contact points.
# Cassandra nodes use this list of hosts to find each other and learn
# the topology of the ring. You must change this if you are running
# multiple nodes!
- class_name: org.apache.cassandra.locator.SimpleSeedProvider
parameters:
# seeds is actually a comma-delimited list of addresses.
# Ex: "<ip1>,<ip2>,<ip3>"
# Addresses of hosts that are deemed contact points.
# Cassandra nodes use this list of hosts to find each other and learn
# the topology of the ring. You must change this if you are running
# multiple nodes!
- class_name: org.apache.cassandra.locator.SimpleSeedProvider
parameters:
# seeds is actually a comma-delimited list of addresses.
# Ex: "<ip1>,<ip2>,<ip3>"
- seeds:"ubuntu-dev1,ubuntu-dev2"
rpc_address: 0.0.0.0
broadcast_rpc_address: ubuntu-dev1
When start the cassandra server
> nohup cassandra -f conf/cassandra.yaml &
I get error message as follow:
Cassandra 2.0 and later require Java 7u25 or later.
Try to upgrade the JDK
>sudo add-apt-repository ppa:webupd8team/java
>sudo apt-get update
> sudo apt-get install oracle-java7-installer
>sudo update-alternatives --config java
>sudo update-alternatives --config javac
After the cassandra running, we can use cqlsh to connect to that.
9160 is used for thrift clients, 9042 is for native protocol clients.
Check the cluster
> nodetool -h ubuntu-dev1 status
3. Try to install OpsCenter
Find the latest version here.
>wget
> sudo ln -s /home/carl/tool/opscenter-5.0.2 /opt/opscenter-5.0.2
> sudo ln -s /opt/opscenter-5.0.2 /opt/opscenter
Start the opscenter
> bin/opscenter -f
Visit the webpage
Put ubuntu-dev1 and connect from there.
Plan to start cassandra and nodeJS later after gatling.
References:
old blog 1 ~ 7
official website
相关推荐
在这个场景中,“cassandra2.1.2 JDBC最少依赖jar”指的是为了通过Java的JDBC API与Cassandra 2.1.2进行通信,你需要的最小Java库集合。 在使用JDBC操作Cassandra时,首先需要理解Cassandra的驱动模型。Cassandra...
Cassandra 2.1.2 源代码 part1 编译过
Beginning Apache Cassandra Development takes you through the Apache Cassandra NoSQL database and how to build applications that leverage its capabilities. As Java, PHP, Python, and JavaScript are the ...
Cassandra 2.1.2 源代码 part2 已经编译
Cassandra is a distributed database that stands out thanks to its robust feature set and intuitive interface, while providing high availability and scalability of a distributed data store. This book ...
Beginning Apache Cassandra Development introduces you to one of the most robust and best-performing NoSQL database platforms on the planet. Apache Cassandra is a document database following the JSON ...
The rising popularity of Apache Cassandra rests on its ability to handle very large data sets that include hundreds of terabytes -- and that's why this distributed database has been chosen by ...
Big Data SMACK: A Guide to Apache Spark, Mesos, Akka, Cassandra, and Kafka by Raul Estrada, Isaac Ruiz English | ISBN: 1484221745 | 2016 | EPUB | 264 pages | 2.35 MB This book is about how to ...
This book will teach you how to use Storm for real-time data processing and to make your applications highly available with no downtime using Cassandra. The book starts off with the basics of Storm ...
Apache Cassandra is the most commonly used NoSQL database written in Java and is renowned in the industry as the only NoSQL solution that can accommodate the complex requirements of today’s modern ...
Build, manage, and configure high-performing, reliable NoSQL database for your applications with Cassandra Key Features Write programs more efficiently using Cassandra's features with the help of ...