I released Spider storage engine version 0.12.(beta)
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.
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 like MyISAM, you should better to set this option to 1 for getting full record count from table status.
- Add table parameter "select_column_mode", add server parameter "spider_select_column_mode".
After this time, you can choose method of deciding used columns at select clause from "easy deciding(existing method)" and "detailed deciding(new method)".
You can reduce the wire traffic to remote servers by using "detailed deciding".
Please see "99_change_logs.txt" in the download documents for checking other changes.