从MariaDB访问Cassandra集群 - Cassandra storage engine

jopen 11年前

Cassandra Storage Engine能够从MariaDB访问Cassandra集群中的数据。下面这张图片展示了整体架构,类似于NDB Cluster存储引擎。

cassandra-se-overview.png

你可以从多个MariaDB实例访问同一个Cassandra集群,它们每一个都可以运行Cassandra Storage Engine:

mariadb-and-cassandra.png

 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.

项目主页:http://www.open-open.com/lib/view/home/1348920942697