I released Spider storage engine version 0.12.(beta)
http://spiderformysql.com/
Spider storage engine can be used for database sharding by using
table partitioning and table link.
Spider storage engine can synchronize an update for remote MySQL
servers by XA transaction at Spider-internal.
Introduction document:
http://www.mysqlconf.com/mysql2009/public/schedule/detail/6837
The main changes in this version are following.
("Table parameter" that is used following is parameters for each
table. Please see "04_table_create.txt" and
"06_table_parameters.txt" in the download documents for more
details.)
- Add table parameter "table_count_mode".
If storage engine can return correct full record
count from table status …
Jun
29
2009
Apr
29
2009
|
|
At the MySQL
Conference 2009 I attended a session about the Spider
storage engine, an engine with built-in sharding
features. The talk was notable for the speaker wearing a spiderman costume, and for some language barrier that made the talk less enjoyable than it should be. That's a pity, because the engine is very intriguing, and deserves some exploration. |
What is the Spider engine, then? In short, it's an extension to
the partitioning engine with the ability of connecting to remote
servers. Basically, partitions + federated, except that Federated
is explicitly removed during the …