从MariaDB访问Cassandra集群 - Cassandra storage engine
jopen
12年前
Cassandra Storage Engine能够从MariaDB访问Cassandra集群中的数据。下面这张图片展示了整体架构，类似于NDB Cluster存储引擎。
你可以从多个MariaDB实例访问同一个Cassandra集群，它们每一个都可以运行Cassandra Storage Engine：
Cassandra SE (Storage Engine)的目的实现SQL与NoSQL之间数据交换。
set cassandra_default_thrift_host='192.168.0.10' -- Cassandra's address. It can also -- be specified as startup parameter -- or on per-table basis create table cassandra_tbl -- table name can be chosen at will ( rowkey type PRIMARY KEY, -- represents Column Family's rowkey. Primary key -- must be defined over this column. column1 type, -- Cassandra's static columns can be mapped to column2 type, -- regular SQL columns. dynamic_cols blob DYNAMIC_COLUMN_STORAGE=yes -- If you need to access Cassandra's -- dynamic columns, you can define -- a blob which will receive all of -- them, packed as MariaDB's dynamic -- columns. ) engine=cassandra keyspace= 'cassandra_key_space' -- Cassandra's keyspace.columnFamily we column_family='column_family_name'; -- are accessing.