I'm pleased to announce the release of Spider storage engine
version 2.24(beta) and Vertical Partitioning storage engine
version 0.13(beta).
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.
Spider
- MySQL 5.5 support.
- handlersocket support.
You can use handlersocket through Spider table that
called by handlersocket. It means handlersocket can access to
sharded databases. Currently, handlersocket support only
Linux.
Set "spider_use_hs_read=1" and
"spider_use_hs_write=1" for activating this feature.
Added following parameters to …
I'm pleased to announce the release of Spider storage engine
version 2.23(beta) and Vertical Partitioning storage engine
version 0.12(beta).
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.
Spider
- Add server parameter "spider_udf_ct_bulk_insert_interval" and
"spider_udf_ct_bulk_insert_rows".
Vertical Partitioning
This release is bug fix release.
Please see "99_change_logs.txt" in the download documents for
checking other changes.
Thanks to Gen, Yoshihiko, Satoko and Makoto for testing for
clustering and online schema …
I'm pleased to announce the release of Spider storage engine
version 2.22(beta), Vertical Partitioning storage engine version
0.11(beta) and BKA-for-ha_partition version 0.3.
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
BKA-for-ha_partition is a patch file of supporting "Batched Key
Access" for table partitioning feature.
http://launchpad.net/partitionmrrformysql
The main changes in this version are following.
Spider
- MS Windows support.
- Add UDF "spider_copy_tables".
Spider HA feature is now available!
…
I'm pleased to announce the release of Spider storage engine
version 2.21(beta).
Spider is a Storage Engine for database sharding.
http://spiderformysql.com/
The main changes in this version are following.
- Add table parameter "bka_mode" and "bka_engine".
- Add server parameter "spider_bka_mode" and
"spider_bka_engine".
This parameters are for improvement performance for
using BKA and using a lot of conditions with IN clause and so
on.
"mysql-5.1.44.slave-trx-retry.diff" is included in the source tar
ball from this release.
mysql-5.1.44.slave-trx-retry.diff adds a option
"slave_transaction_retry_errors". This parameter is used like
"slave_transaction_retry_errors=1158,1159,2013,12701". Slave sql
thread retries the transaction if slave sql thread encounters the
errors at this parameter. Number of retries are at
"slave_transaction_retries".
Please see …
I'm pleased to announce the release of Spider storage engine
version 2.18(beta).
Spider is a Storage Engine for database sharding.
http://spiderformysql.com/
The main changes in this version are following.
This release is bug fix release.
Please see "99_change_logs.txt" in the download documents for
more detail.
Enjoy!
The history tells that a single RDBMS node cannot handle tons of
traffics on web system which come from all over the world, no
matter how the database is tuned. MySQL has implemented a
master/slave style replication built-in for long time, and it has
enabled web applications to handle traffics using a scale-out
strategy. Having many slaves has been suitable for web sites
where most of traffics are reads. Thus, MySQL's master/slave
replication has been used on many web sites, and is being used
still.
However, when a site grow large, amount of traffic may exceed the
replication's capacity. In such a case, people may use memcached.
It's an in-memory, very fast and well-known KVS, key value store,
and its read throughput is far better than MySQL. It's been used
as a cache for web applications to store 'hot' data with MySQL as
a back-end storage, as it can reduce read requests to MySQL
dramatically.
While 1:N replication …
I'm pleased to announce the release of Spider storage engine
version 2.17(beta).
Spider is a Storage Engine for database sharding.
http://spiderformysql.com/
The main changes in this version are following.
- Add table parameter "semi_split_read_limit".
- Add server parameter "spider_semi_split_read_limit".
This parameters are for searching performance
improvement.
Please see "99_change_logs.txt" in the download documents for
checking other changes.
Enjoy!
I'm pleased to announce the release of Spider storage engine
version 2.16(beta) and Vertical Partitioning storage engine
version 0.9(beta).
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.
(This release for Vertical Partitioning is a bug fix
release)
- Add table parameter "semi_split_read".
- Add server parameter "spider_semi_split_read".
This parameters are for searching performance
improvement.
Please see "99_change_logs.txt" in the download documents for
checking other changes.
Enjoy!
I'm pleased to announce the release of Spider storage engine
version 2.15(beta).
Spider is a Storage Engine for database sharding.
http://spiderformysql.com/
The main changes in this version are following.
This release is bug fix release.
Please see "99_change_logs.txt" in the download documents for
more detail.
Enjoy!
I'm pleased to announce the release of Spider storage engine
version 2.14(beta).
Spider is a Storage Engine for database sharding.
http://spiderformysql.com/
The main changes in this version are following.
- Add table parameter "bulk_update_mode" and
"bulk_update_size".
- Add server parameter "spider_bulk_update_mode" and
"spider_bulk_update_size".
This parameters are for performance improvement.
Please examine to use "spider_direct_dup_insert", if "REPLACE"
and "INSERT IGNORE" are slow.
Please examine to use "spider_bulk_update_mode", if "UPDATE" and
"DELETE" are slow.
Please see "99_change_logs.txt" in the download documents for
checking other changes.
Enjoy!