1.下载cassandra数据库:
若上面连接失效:http://cassandra.apache.org/download/
3.进入bin目录执行:cassandra -f
4.再开一个Window,同样在在bin目录执行:cqlsh
5.步骤4成功后,执行操作命令:
CREATE KEYSPACE msgkeyspace WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 };
USE msgkeyspace;
CREATE TABLE msg (
app_id text,
owner_id text,
type_id text,
msg_id text,
msg text,
status int,
sign text,
ser_ip text,
created_time timestamp,
updated_time timestamp,
PRIMARY KEY ((app_id, owner_id,type_id),msg_id)
) WITH CLUSTERING ORDER BY (msg_id DESC);
INSERT INTO msg (app_id,owner_id,type_id,msg_id,msg,status,sign,ser_ip,created_time,updated_time) VALUES ('appId01','userId01','chat','123456789123456789','msgtext', 1,'sign','192.168.0.4','2006-01-02 15:04:05','2006-01-02 15:04:05');
SELECT * FROM msg;
开启远程访问,修改配置文件:./conf/cassandra.yaml
rpc_address: 0.0.0.0 (0.0.0.0适配所有来访IP,可设置一个指定IP)
# broadcast_rpc_address: 1.2.3.4 (放开这段注释,若上面rpc_address不是 0.0.0.0则不需要放开)
----------------------------cassandra.yaml参数说明--------------------------------
默认集群名(cluster_name):Test Cluster
默认缓存文件存放路径(saved_caches_directory):$CASSANDRA_HOME/data/saved_caches
默认数据文件存放路径(data_file_directories):$CASSANDRA_HOME/data/data
默认commitlog存放路径(commitlog_directory):$CASSANDRA_HOME/data/commitlog
默认的Cassandra服务地址(rpc_address):localhost
默认的Cassandra服务端口(rpc_port):9160
默认的CQL本地服务端口(native_transport_port): 9042
Centos yum 安装: