從MariaDB訪問Cassandra集群 - Cassandra storage engine

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.

項目主頁：http://www.baiduhome.net/lib/view/home/1348920942697