8/23/2013

[MariaDB][Spider]Spider is bundled in MariaDB!

Spider storage engine is bundled in MariaDB 10.0.4.
https://downloads.mariadb.org/mariadb/10.0.4/

After this release, you can use Spider immediately by installing MariaDB.
For using Spider after installing MariaDB, please execute "install_spider.sql"
which under share directory.

MariaDB 10.0.4 is still alpha version, so please don't use on production systems.
Currently, MariaDB bundled Spider has the following difference than MySQL bundled Spider.

New features
  batched key access
    This is a feature for join performance improvement.
    You can use BKA by setting join_cache_level to 5 and more.
  assisted discovery
    This is a feature for taking table structure from data node.
    For example, if there is a table structure as the following
CREATE TABLE `t1` (
  `id` bigint NOT NULL,
  `c1` varchar(100) NOT NULL,
  `c2` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    you can create a Spider table by using the following DDL.
CREATE TABLE `t1` ENGINE=SPIDER DEFAULT CHARSET=latin1 CONNECTION='database "test", table "t1", server "s1"';

Current limited features
  Slave retring feature by using slave_transaction_retry_errors
  Using Spider table through handlersocket
  Optimization for single table updating
  Partitioned Spider table's
  - engine condition pushsown
  - fulltext index search
  - spacial index search
  - full table count optimization
  - parallel search


I and Groonga Developer Team were won the 8th Japan OSS incentive award after releasing Spider 3.0.
http://ossforum.jp/en/node/1277
Thank you for your cooperation!

2 comments:

  1. What is spider? Is it a network or hierarchy storage engine? If so, how does it differ from OOGraph?

    ReplyDelete
    Replies
    1. In my understanding, OQGRAPH is a storage engine for hierarchical structured data. Spider is a storage engine for sharded data.

      Delete