Spider is a Storage Engine for database sharding.
http://spiderformysql.com/
Vertical Partitioning is a Storage Engine for vertical partitioning for a table.
http://launchpad.net/vpformysql
The main changes in this version are following.
- The standalone compilation with Vertical Partitioning storage engine is now available.
- Vertical Partitioning can be used for multi-step partitioning.
Example:
create table a(a int primary key)engine=myisam;
create table b(a int primary key)engine=vp comment 'tnl "a"';
create table c(a int primary key)engine=vp comment 'tnl "b"';
- Add table parameter "bgs_mode", "bgi_mode" and "bgu_mode".
- Add server parameter "vp_bgs_mode", "vp_bgi_mode" and "vp_bgu_mode".
Parallel search and update from Vertical Partitioning to Spider are now available by using this parameters.
Please see "99_change_logs.txt" in the download documents for checking other changes.
Enjoy!
PlanetMySQL Voting: Vote UP / Vote DOWN
