Archive for the ‘other’ Category

[MySQL][Spider][VP][Other]Spider-2.22 VP-0.11 BKA-for-ha_partition-0.3 released

Август 30th, 2010
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!

Vertical Partitioning
- MS Windows support.

Pathced MySQL source code and compiled MySQL binary are available from this release.

Please see "99_change_logs.txt" in the download documents for checking other changes.
Thanks to Toru for working for supporting Windows.

Enjoy!

PlanetMySQL Voting: Vote UP / Vote DOWN

[MySQL][Spider][VP][Other]Spider-2.20 VP-0.10 BKA-for-ha_partition-0.2 released

Май 17th, 2010
I'm pleased to announce the release of Spider storage engine version 2.20(beta), Vertical Partitioning storage engine version 0.10(beta) and BKA-for-ha_partition version 0.2.
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
- "spider_multi_split_read" supports dividing condition count.
From this release, there is "install_spider.sql" file for installing and updating Spider. Please use this file.

Vertical Partitioning
- Support "Batched Key Access".
  This feature is now available on MariaDB 5.3 with "join_cache_level=6 and more".

Please see "99_change_logs.txt" in the download documents for checking other changes.

Enjoy!

PlanetMySQL Voting: Vote UP / Vote DOWN

[MySQL][VP][Other]Start creating Engine Independent Test & VP-0.7 released

Январь 31st, 2010
I started creating "Engine Independent Test".
http://launchpad.net/engineindependenttestformysql

This test aims to be testable with all storage engines.
There is following wiki but test was not created yet.
http://forge.mysql.com/wiki/EngineIndependentTestSuite
I think this test is need for Storage Engine Developers(including me).
Additionally, I already released 2 Storage Engines so I felt needing this test strongly.
So I started creating "Engine Independent Test".

Please tell me without hesitate if you have a demand.


I'm pleased to announce the release of Vertical Partitioning storage engine version 0.7(alpha).
Vertical Partitioning is a Storage Engine for vertical partitioning for a table.
http://launchpad.net/vpformysql

The main changes in this version are following.
  MariaDB support.

Please see "99_change_logs.txt" in the download documents for checking other changes.

Please enjoy and go forward!

PlanetMySQL Voting: Vote UP / Vote DOWN

Who knew Ingres had it in them?

Июль 29th, 2009
VectorWise has emerged from stealth mode. Even more interesting is that Ingres is collaborating with them on Ingres VectorWise. And most interesting is the video made to promote the work. In the interest of disclosure, I have friends who work on this at Ingres and VectorWise.

I have read many of the papers on X100 and MonetDB and believe the performance claims they make. Within the MySQL community, this is most similar to Kickfire in terms of the query workloads it can support. The difference is that VectorWise writes their software to run at full speed on a modern CPU and maintain a high IPC rate while Kickfire uses custom hardware (and a lot of really good software that they probably cannot describe without an NDA). Anyone attempting to build a VectorWise storage engine would have to do all of the fun things that KickFire has done to circumvent much of the MySQL optimizer and execution code, so I doubt that will be repeated.