tag:blogger.com,1999:blog-78701780818550848232024-03-05T13:54:38.235+09:00Wild GrowthKentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.comBlogger49125tag:blogger.com,1999:blog-7870178081855084823.post-22330089997167337982018-09-12T11:59:00.000+09:002018-09-19T00:51:28.614+09:00[MySQL][replication]unknown error reading log event on the masterMySQL 5.7 and 8.0 have an issue of stopping replication on all slaves.
<script async class="speakerdeck-embed" data-id="0a454caa25b648a7b81d846bd579a4ef" data-ratio="1.33333333333333" src="//speakerdeck.com/assets/embed.js"></script>
Kentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.com0tag:blogger.com,1999:blog-7870178081855084823.post-53838164571815139472014-03-24T04:26:00.000+09:002014-03-24T04:26:48.721+09:00[MySQL][Spider][VP]Spider-3.2 VP-1.1 releasedI'm pleased to announce the release of Spider storage engine version 3.2(rc) and Vertical Partitioning storage engine version 1.1(beta).<br>
Spider is a Storage Engine for database sharding.<br>
<a href="http://spiderformysql.com/">http://spiderformysql.com/</a><br>
Vertical Partitioning is a Storage Engine for vertical partitioning for a table.<br>
<a href="http://launchpad.net/vpformysql">http://launchpad.net/vpformysql</a><br>
<br>
Please use the following for downloading binary file.<br>
<a href="http://spiderformysql.com/download_spider.html">http://spiderformysql.com/download_spider.html</a><br>
<br>
The main changes in this version are following.<br>
Spider<br>
- Add server parameter "spider_log_result_error_with_sql", "spider_version", "spider_internal_xa_id_type", "spider_casual_read", "spider_dry_access" and "spider_delete_all_rows_type".<br>
- Add table parameter "casual_read" and "delete_all_rows_type".<br>
<br>
Vertical Partitioning<br>
- Add server parameter "vp_version".<br>
<br>
From this release, release target is not only MySQL 5.5 but also MariaDB 10.0. MariaDB 10.0 version is bundling Spider, VP and Mroonga. Please try to use this. You can use Bached Key Access by setting join_cache_level to 5 and more. So please set it.<br>
Limited Spider features for MariaDB 10.0 which I announced are now available except "Using Spider table through handlersocket".<br>
<br>
Please see "99_change_logs.txt" in the download documents for checking other changes.<br>
<br>
Thanks to Stephane, Nicolas, Koichi, Akihiko, Yasunori for supporting.<br>
<br>
Enjoy!Kentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.com0tag:blogger.com,1999:blog-7870178081855084823.post-42678723209685453372013-10-07T23:50:00.003+09:002013-10-07T23:50:54.893+09:00[MySQL][Spider][VP]Spider-3.1 VP-1.0 releasedI'm pleased to announce the release of Spider storage engine version 3.1(beta) and Vertical Partitioning storage engine version 1.0(beta).<br>
Spider is a Storage Engine for database sharding.<br>
<a href="http://spiderformysql.com/">http://spiderformysql.com/</a><br>
Vertical Partitioning is a Storage Engine for vertical partitioning for a table.<br>
<a href="http://launchpad.net/vpformysql">http://launchpad.net/vpformysql</a><br>
<br>
Please use the following for downloading binary file.<br>
<a href="http://spiderformysql.com/download_spider.html">http://spiderformysql.com/download_spider.html</a><br>
<br>
The main changes in this version are following.<br>
Spider<br>
- Add server parameter "spider_general_log" and "spider_log_result_errors".<br>
- Add table parameter "force_bulk_update" and "force_bulk_delete".<br>
- Add "spider_bka_mode=2" and "bka_mode=2".<br>
- Add "mysql.spider_xa_failed_log" table.<br>
- Performance improvement for "COUNT", "MAX", "MIN" and "SUM" without join and distinct.<br>
- Performance improvement for fulltext search.<br>
- Add case of parallel searching.<br>
Note: "semi_split_read=2" is default value from this version. If you want to use previous version's setting, please set "semi_split_read=0".<br>
<br>
Vertical Partitioning<br>
This release is bug fix release.<br>
<br>
MySQL<br>
Becomes version 5.5.34.<br>
- Add "log_result_errors".<br>
<br>
Please see "99_change_logs.txt" in the download documents for checking other changes.<br>
<br>
Thanks to memorycraft, Adrian, Stephane, Sergey, Elena, Enid, Koichi, Yutaro, Honda-san, Kanzaki-san for bug reporting.<br>
<br>
Enjoy!
Kentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.com0tag:blogger.com,1999:blog-7870178081855084823.post-51019870705493205692013-08-23T01:36:00.000+09:002013-08-23T01:37:11.129+09:00[MariaDB][Spider]Spider is bundled in MariaDB!Spider storage engine is bundled in MariaDB 10.0.4.<br>
<a href="https://downloads.mariadb.org/mariadb/10.0.4/">https://downloads.mariadb.org/mariadb/10.0.4/</a><br>
<br>
After this release, you can use Spider immediately by installing MariaDB.<br>
For using Spider after installing MariaDB, please execute "install_spider.sql"<br>
which under share directory.<br>
<br>
MariaDB 10.0.4 is still alpha version, so please don't use on production systems.<br>
Currently, MariaDB bundled Spider has the following difference than MySQL bundled Spider.<br>
<br>
New features<br>
batched key access<br>
This is a feature for join performance improvement.<br>
You can use BKA by setting join_cache_level to 5 and more.<br>
assisted discovery<br>
This is a feature for taking table structure from data node.<br>
For example, if there is a table structure as the following<br>
<pre>
CREATE TABLE `t1` (
`id` bigint NOT NULL,
`c1` varchar(100) NOT NULL,
`c2` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
</pre>
you can create a Spider table by using the following DDL.<br>
<pre>
CREATE TABLE `t1` ENGINE=SPIDER DEFAULT CHARSET=latin1 CONNECTION='database "test", table "t1", server "s1"';
</pre>
<br>
Current limited features<br>
Slave retring feature by using slave_transaction_retry_errors<br>
Using Spider table through handlersocket<br>
Optimization for single table updating<br>
Partitioned Spider table's<br>
- engine condition pushsown<br>
- fulltext index search<br>
- spacial index search<br>
- full table count optimization<br>
- parallel search<br>
<br>
<br>
I and Groonga Developer Team were won the 8th Japan OSS incentive award after releasing Spider 3.0.<br>
<a href="http://ossforum.jp/en/node/1277">http://ossforum.jp/en/node/1277</a><br>
Thank you for your cooperation!<br>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPFaSTKgjB7Oqomi-9296eWckfapKAZE9vw9qU3wU8q97x6UqwXb9SrrzX8qjEVUGaf_1wZxP2wE2ZSkYSo1hRPAr-NryIC8kB82deDCfDif0L35RPZwhsxDV5GYcP6vyFjTgBCHLzs-s3/s1600/IMG_1154.JPG" imageanchor="1" ><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPFaSTKgjB7Oqomi-9296eWckfapKAZE9vw9qU3wU8q97x6UqwXb9SrrzX8qjEVUGaf_1wZxP2wE2ZSkYSo1hRPAr-NryIC8kB82deDCfDif0L35RPZwhsxDV5GYcP6vyFjTgBCHLzs-s3/s320/IMG_1154.JPG" /></a>Kentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.com2tag:blogger.com,1999:blog-7870178081855084823.post-31942420081359754092013-02-18T04:18:00.000+09:002013-02-18T04:18:38.291+09:00[MySQL][Spider][VP]Spider-3.0 VP-0.18 releasedI'm pleased to announce the release of Spider storage engine version 3.0(beta) and Vertical Partitioning storage engine version 0.18(beta).<br>
Thank you for waiting such a long time! This release includes my 1 year development.<br>
Spider is a Storage Engine for database sharding.<br>
<a href="http://spiderformysql.com/">http://spiderformysql.com/</a><br>
Vertical Partitioning is a Storage Engine for vertical partitioning for a table.<br>
<a href="http://launchpad.net/vpformysql">http://launchpad.net/vpformysql</a><br>
<br>
Please use the following for downloading binary file.<br>
<a href="http://spiderformysql.com/download_spider.html">http://spiderformysql.com/download_spider.html</a><br>
<br>
The main changes in this version are following.<br>
Spider<br>
- Support link to oracle tables.<br>
Connection from Spider to Oracle is now available by using table parameter 'server "oracle"'. For using this feature, please build from source code on Oracle client library installed server with 'ORACLE_HOME'. I can't bundle Oracle client library because Oracle client library isn't GPL. And please set service name of Oracle to table parameter 'host', schema name of Oracle to table parameter 'database'.<br>
- Support handlersocket bulk access feature.<br>
Please read the following 'handlersocket' section.<br>
- Performance improvement for "insert on duplicate key update" with "direct_dup_insert=1".<br>
'insert on duplicate key update' is sent to data node directly as much as possible.<br>
- Add server parameter "spider_bulk_access_free".<br>
If Spider server using handlersocket has enough memory, there is possibility of performance improvement by setting this parameter to '1' for growing memory reusability.<br>
- Add table parameter "pk_name", "sequence_name", "bulk_access_free".<br>
Please set primary key name of data node table to 'pk_name', if primary key name of data node table is not 'PRIMARY' like using Oracle table.<br>
Please set sequence name of data node to 'sequence_name', if you want to use sequence of data node table for auto increment value like using Oracle table with 'auto_increment_mode=2or3'.<br>
Note: "spider_force_commit=1" is default value from this version. If you want to use previous version's setting, please set "spider_force_commit=0".<br>
<br>
Vertical Partitioning<br>
- Support handlersocket bulk access feature.<br>
Please read the following 'handlersocket' section.<br>
<br>
handlersocket<br>
Becomes version 1.2.<br>
- Add bulk access feature.<br>
Handlersocket is multiple clients 1 therad model, so 1 thread can make a bulk request from multiple clients requests. Bulk request can improvement throughput extremely by using Spider.<br>
- Add server parameter "handlersocket_bulk_exec_size".<br>
This parameter is bulk access size of requests. '0' means turning off bulk access feature. If there is a lot of requests greater than this parameter, requests divide multiple bulk requests and send to data node using pipelining by Spider.<br>
This parameter is global parameter and you can change it from SQL interface any time.<br>
<br>
Please see "99_change_logs.txt" in the download documents for checking other changes.<br>
<br>
This release is for 5.5 yet, please wait for next release for 5.6.<br>
<br>
Thanks to Ingo, Enid, Yihuey, Koichi, Hideyuki, Keisuke for bug reporting.<br>
Thanks to Akira for your advice.<br>
<br>
Enjoy!<br>
Kentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.com2tag:blogger.com,1999:blog-7870178081855084823.post-33043143325564048122012-02-10T01:43:00.002+09:002012-02-17T05:01:40.138+09:00[MySQL][Spider][VP]Spider-2.28 VP-0.17 releasedI'm pleased to announce the release of Spider storage engine version 2.28(beta) and Vertical Partitioning storage engine version 0.17(beta).<br />Spider is a Storage Engine for database sharding.<br /><a href="http://spiderformysql.com/">http://spiderformysql.com/</a><br />Vertical Partitioning is a Storage Engine for vertical partitioning for a table.<br /><a href="http://launchpad.net/vpformysql">http://launchpad.net/vpformysql</a><br /><br />Please use the following for downloading binary file.<br /><a href="http://spiderformysql.com/download_spider.html">http://spiderformysql.com/download_spider.html</a><br /><br />The main changes in this version are following.<br />Spider<br />- Support parallel searching. ("spider_bgs_mode > 0")<br /> The table using the Spider bundled MySQL and table partitioning performs parallel search of each partition. However, parallel search is not performed in the case which does not make all the partitions applicable to search like sequential search with limit.<br />- Add server parameter "spider_use_default_database" and "spider_remote_default_database".<br /> These parameter is added for using some replication parameters like "binlog-do-db" on data node. "spider_use_default_database=0" is same of previous versions.<br />- Add table parameter "access_balance".<br /> This parameter is the weight of load balancing for Spider's redundancy feature.<br />- Add INFORMATION SCHEMA "spider_alloc_mem".<br /> This INFORMATION SCHEMA plugin adds "information_schema.spider_alloc_mem" table for showing Spider's using memory status. "alloc_mem_count" and "free_mem_count" columns in "information_schema.spider_alloc_mem" table express the count of increasing and decreasing memory, so they do not necessarily become the same.<br />- Add value of 3 to "quick_mode"(table parameter) and "spider_quick_mode"(server parameter).<br /> "quick_mode=3" is the mode of using temporary table for result set from data node. This mode is useful for searching a huge table.<br /><br />Spider's management table was changed from previous version and add new plugin, please execute "install_spider.sql" for upgrading.<br /><br />Vertical Partitioning<br />- Add UDF paramter "suppress_autoinc".<br />- Add table parameter "allow_bulk_autoinc" and "allow_different_column_type".<br />- Add server parameter "vp_allow_bulk_autoinc".<br /><br />handlersocket<br />Becomes version 1.1.<br />- Add server parameter "handlersocket_slow_log", "handlersocket_long_exec_time" and "handlersocket_close_table_interval".<br /> "handlersocket_slow_log" is logging handlersocket request with slow (spend over "handlersocket_long_exec_time" micro second) response into slow log with "slow_query_log=on".<br /> "handlersocket_close_table_interval" is interval of closing table internally for releasing meta data lock for executing like "alter table". You can use this parameter "handlersocket_close_table_interval=0" (doesn't close) for normally and only change this parameter for executing like "alter table".<br /> These parameters are global parameter and you can change them from SQL interface.<br /><br />Please see "99_change_logs.txt" in the download documents for checking other changes.<br /><br />Thanks to Takafumi, Yukihiro, Jung, Adrian, leechangyeol, liuyanhong, Hisazumi, Hideyuki, Keisuke for bug reporting.<br />Thanks to Akira for your advice.<br /><br />Enjoy!<br /><br /><br />--- 2/17 postscript ---<br /> Spider binaries is updated for fixing getting no result bug of parallel searching. I'm sorry.<br /> Updated version's handlersocket is added the following parameter.<br />- Add server parameter "handlersocket_get_lock".<br /> This parameter makes handlersocket possible turning off get_lock for write threads. "handlersocket_get_lock=off" is useful for increasing "handlersocket_threads_wr" for some case as using Spider through handlersocket.Kentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.com0tag:blogger.com,1999:blog-7870178081855084823.post-7493231168066014412011-10-19T22:35:00.001+09:002011-10-19T22:38:05.414+09:00[MySQL][Spider][VP]Spider-2.27 VP-0.16 releasedI'm pleased to announce the release of Spider storage engine version 2.27(beta) and Vertical Partitioning storage engine version 0.16(beta).<br />Spider is a Storage Engine for database sharding.<br /><a href="http://spiderformysql.com/">http://spiderformysql.com/</a><br />Vertical Partitioning is a Storage Engine for vertical partitioning for a table.<br /><a href="http://launchpad.net/vpformysql">http://launchpad.net/vpformysql</a><br /><br />Please use the following for downloading binary file.<br /><a href="http://spiderformysql.com/download_spider.html">http://spiderformysql.com/download_spider.html</a><br /><br /><span style="font-weight:bold;">The main changes in this version are following.</span><br />Q4M is bundled for Linux 64bit.<br /> Bundled Q4M supports replication, but please use it carefully.<br /><br /><span style="font-weight:bold;">Spider</span><br />- Support R-Tree index.<br />- Support direct updating for SQL access.<br />- Support handlersocket increment and decrement.<br />- Change table parameter from "net_timeout" to "connect_timeout", "net_read_timeout" and "net_write_timeout".<br />- Change server parameter from "spider_net_timeout" to "spider_connect_timeout", "spider_net_read_timeout" and "spider_net_write_timeout".<br />- Add UDF paramter "access_mode". "spider_direct_sql" support handlersocket access.<br />- Add server parameter "spider_hs_ping_interval", "spider_error_read_mode" and "spider_error_write_mode".<br />- Add table parameter "hs_write_to_read", "error_read_mode" and "error_write_mode".<br />- Performance improvement for "COUNT(*)", "MAX" and "MIN" without clause.<br />Note<br />- Change parameter from "net_timeout" and "spider_net_timeout" to "connect_timeout", "net_read_timeout", "net_write_timeout", "spider_connect_timeout", "spider_net_read_timeout" and "spider_net_write_timeout" from this version.<br />- From this version, you can't compile with static link option for Spider.<br /><br /><span style="font-weight:bold;">Vertical Partitioning</span><br />- Support R-Tree index.<br />- Support direct updating.<br />- Support handlersocket increment and decrement.<br />Note<br />- From this version, you can't compile with static link option for VP.<br /><br /><span style="font-weight:bold;">handlersocket</span><br />- Add server parameter "handlersocket_general_log".<br /> Logging handlersocket request into general log with "general_log=on". This parameter is global parameter and you can change it from SQL interface.<br /><br />Please see "99_change_logs.txt" in the download documents for checking other changes.<br /><br />Enjoy!Kentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.com2tag:blogger.com,1999:blog-7870178081855084823.post-38581151762633651242011-07-22T01:46:00.000+09:002011-07-22T01:48:46.518+09:00[MySQL][Spider][VP]Spider-2.26 VP-0.15 releasedI'm pleased to announce the release of Spider storage engine version 2.26(beta) and Vertical Partitioning storage engine version 0.15(beta).<br />Spider is a Storage Engine for database sharding.<br /><a href="http://spiderformysql.com/">http://spiderformysql.com/</a><br />Vertical Partitioning is a Storage Engine for vertical partitioning for a table.<br /><a href="http://launchpad.net/vpformysql">http://launchpad.net/vpformysql</a><br /><br />Recently, I can't upload the binary file to Launchpad, so I put the binary file at the following. Please use the following for downloading binary file.<br /><a href="http://spiderformysql.com/download_spider.html">http://spiderformysql.com/download_spider.html</a><br /><br />The main changes in this version are following.<br />Spider<br />- Add table parameter "active_link_count", "read_only_mode", "first_read" and "second_read".<br />- Add server parameter "spider_read_only_mode", "spider_first_read", "spider_second_read", "spider_remote_time_zone" and "spider_sync_time_zone".<br /> "active_link_count" is a parameter for using Active-Standby database for data node. Normally, set "active_link_count" to 1 for using Active-Standby data node. Currently, this feature supports only Active-Standby that can switch immediately. For this changing, Spider's management table was changed from previous version, please execute "install_spider.sql" for upgrading.<br />- Reducing access to data nodes.<br /> By this change, even if a shard is crushed, you can continue accessing to other shard.<br /><br />Vertical Partitioning<br /> This release is bug fix release.<br /><br />Please see "99_change_logs.txt" in the download documents for checking other changes.<br /><br />Enjoy!Kentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.com4tag:blogger.com,1999:blog-7870178081855084823.post-8144464163847299112011-05-12T02:07:00.001+09:002011-05-12T02:10:02.394+09:00[MySQL][Spider][VP]Spider-2.25 VP-0.14 releasedI'm pleased to announce the release of Spider storage engine version 2.25(beta) and Vertical Partitioning storage engine version 0.14(beta).<br />Spider is a Storage Engine for database sharding.<br /><a href="http://spiderformysql.com/">http://spiderformysql.com/</a><br />Vertical Partitioning is a Storage Engine for vertical partitioning for a table.<br /><a href="http://launchpad.net/vpformysql">http://launchpad.net/vpformysql</a><br /><br />The main changes in this version are following.<br />Spider<br />- Add table parameter "skip_default_condition" and "direct_order_limit".<br />- Add server parameter "spider_skip_default_condition" and "spider_direct_order_limit".<br /> "direct_order_limit" improves some SQL with "order by" and "limit" performance.<br />- Add UDF "spider_flush_table_mon_cache".<br /> "spider_flush_table_mon_cache" is used for reflecting changing of table monitoring server information.<br />- Wild card for monitoring server information is now available.<br /> Wild card like used for user information can be used for monitoring server information(db_name、table_name、link_id), and you can set a monitoring server information for multiple tables. For this changing, Spider's management table was changed from previous version, please execute "install_spider.sql" for upgrading.<br /><br />Vertical Partitioning<br /> This release is bug fix release.<br /><br />- Table partitioning supports fulltext searching.<br /><br />- Added following parameters to bundled handlersocket.<br /> - handlersocket_bulk_insert<br /> Handlersocket supports bulk inserting.<br /> This parameter is bulk size of inserting.<br /> There is a feature that insert from multiple users becomes bulk insert, and there is the speed-up of insert of the application to which insert of a single line is done with the MultiThreading.<br /> 0:Disable bulk inserting.<br /> 1-:Execute bulk inserting when the stocked records increase more than the values of the parameter.<br /> - handlersocket_bulk_insert_timeout<br /> The maximum standby time of the state that it doesn't reach the number of records of handlersocket_bulk_insert to execute bulk insert. (second)<br /><br />- Table partitioning supports "handlersocket_direct_update_mode" with Spider. (It only works with unlimited updating and deleting with handlersocket_unlimited_boundary.)<br /><br />Please see "99_change_logs.txt" in the download documents for checking other changes.<br /><br />Thanks to Kazuhide, Takahiro, Yuki, Hiroshi and Sangjin for bug reporting.<br />Thanks to Mikiya for your advice.<br /><br />Enjoy!Kentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.com0tag:blogger.com,1999:blog-7870178081855084823.post-32654346371445693472011-02-13T03:34:00.004+09:002011-02-14T04:26:52.012+09:00[MySQL][Spider][VP][Other]Spider-2.24 VP-0.13 releasedI'm pleased to announce the release of Spider storage engine version 2.24(beta) and Vertical Partitioning storage engine version 0.13(beta).<br />Spider is a Storage Engine for database sharding.<br /><a href="http://spiderformysql.com/">http://spiderformysql.com/</a><br />Vertical Partitioning is a Storage Engine for vertical partitioning for a table.<br /><a href="http://launchpad.net/vpformysql">http://launchpad.net/vpformysql</a><br /><br />The main changes in this version are following.<br />Spider<br />- MySQL 5.5 support.<br />- handlersocket support.<br /> You can use handlersocket through Spider table that called by handlersocket. It means handlersocket can access to sharded databases. Currently, handlersocket support only Linux.<br /> Set "spider_use_hs_read=1" and "spider_use_hs_write=1" for activating this feature.<br /> Added following parameters to bundled handlersocket.<br /> #1 handlersocket_support_merge_table<br /> Please set this parameter to 1, if you want to use merge_myisam and vp tables through handlersocket.<br /> #2 handlersocket_direct_update_mode<br /> Improvement performance for a lot of rows updating. Currentry, this parameter works only for Spider table(except partitioned Spider table). I will add a direct update feature for partitioned Spider table at next release.<br /> There are following modes.<br /> 0:Normal<br /> 1:direct update mode 1<br /> This mode can write binary logs on local server at direct updating.<br /> 2:direct update mode 2<br /> This mode cannot write binary logs on local server at direct updating, but this mode is the fastest. (This mode can write binary logs on remote server)<br /> #3 handlersocket_unlimited_boundary<br /> If limit value is more than this parameter, limit value means unlimited.<br />- Support fulltext search.<br /> Except partitioned Spider table. I will add a fulltext search feature for partitioned Spider table at next release.<br />- It's available to set monitoring_node for per table, per link_id and per pertition to mysql.spider_link_mon_servers.<br />- Add table parameter "hs_read_port", "hs_write_port", "use_handler", "use_hs_read", "use_hs_write", "hs_read_socket" and "hs_write_socket".<br />- Add server parameter "spider_use_handler", "spider_use_hs_read", "spider_use_hs_write", "spider_hs_r_conn_recycle_mode", "spider_hs_r_conn_recycle_strict", "spider_hs_w_conn_recycle_mode" and "spider_hs_w_conn_recycle_strict".<br />- Add value of 3 to "auto_increment_mode"(table parameter) and "spider_auto_increment_mode"(server parameter).<br /><br />Vertical Partitioning<br />- MySQL 5.5 support.<br />- Support full text search.<br /> Except partitioned VP table. I will add a fulltext search feature for partitioned VP table at next release.<br /><br />Please see "99_change_logs.txt" in the download documents for checking other changes.<br /><br />Thanks to Gen, Yoshihiko, Satoko and Makoto for testing and bug reporting for online schema changing.<br />Thanks to Takahiro and Kazuhide for testing and bug reporting for Spider's HA feature and VP.<br />Thanks to Kamipo and Laurent for bug report.<br /><br />Enjoy!Kentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.com3tag:blogger.com,1999:blog-7870178081855084823.post-55066130112353309122010-10-17T02:02:00.000+09:002010-10-17T02:04:22.060+09:00[MySQL][Spider][VP]Spider-2.23 VP-0.12 releasedI'm pleased to announce the release of Spider storage engine version 2.23(beta) and Vertical Partitioning storage engine version 0.12(beta).<br />Spider is a Storage Engine for database sharding.<br /><a href="http://spiderformysql.com/">http://spiderformysql.com/</a><br />Vertical Partitioning is a Storage Engine for vertical partitioning for a table.<br /><a href="http://launchpad.net/vpformysql">http://launchpad.net/vpformysql</a><br /><br />The main changes in this version are following.<br />Spider<br />- Add server parameter "spider_udf_ct_bulk_insert_interval" and "spider_udf_ct_bulk_insert_rows".<br /><br />Vertical Partitioning<br /> This release is bug fix release.<br /><br />Please see "99_change_logs.txt" in the download documents for checking other changes.<br /><br />Thanks to Gen, Yoshihiko, Satoko and Makoto for testing for clustering and online schema changing.<br />Thanks to Frederic for bug report.<br /><br />Enjoy!Kentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.com0tag:blogger.com,1999:blog-7870178081855084823.post-86273818778596285232010-08-31T01:35:00.001+09:002010-08-31T01:37:16.921+09:00[MySQL][Spider][VP][Other]Spider-2.22 VP-0.11 BKA-for-ha_partition-0.3 releasedI'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.<br />Spider is a Storage Engine for database sharding.<br /><a href="http://spiderformysql.com/">http://spiderformysql.com/</a><br />Vertical Partitioning is a Storage Engine for vertical partitioning for a table.<br /><a href="http://launchpad.net/vpformysql">http://launchpad.net/vpformysql</a><br />BKA-for-ha_partition is a patch file of supporting "Batched Key Access" for table partitioning feature.<br /><a href="http://launchpad.net/partitionmrrformysql">http://launchpad.net/partitionmrrformysql</a><br /><br />The main changes in this version are following.<br />Spider<br />- MS Windows support.<br />- Add UDF "spider_copy_tables".<br /> Spider HA feature is now available!<br /><br />Vertical Partitioning<br />- MS Windows support.<br /><br />Pathced MySQL source code and compiled MySQL binary are available from this release.<br /><br />Please see "99_change_logs.txt" in the download documents for checking other changes.<br />Thanks to Toru for working for supporting Windows.<br /><br />Enjoy!Kentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.com1tag:blogger.com,1999:blog-7870178081855084823.post-26590981126254197292010-06-27T02:19:00.001+09:002010-06-27T02:21:29.895+09:00[MySQL][Spider]Spider-2.21 releasedI'm pleased to announce the release of Spider storage engine version 2.21(beta).<br />Spider is a Storage Engine for database sharding.<br />http://spiderformysql.com/<br /><br />The main changes in this version are following.<br />- Add table parameter "bka_mode" and "bka_engine".<br />- Add server parameter "spider_bka_mode" and "spider_bka_engine".<br /> This parameters are for improvement performance for using BKA and using a lot of conditions with IN clause and so on.<br /><br />"mysql-5.1.44.slave-trx-retry.diff" is included in the source tar ball from this release.<br />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".<br /><br />Please see "99_change_logs.txt" in the download documents for checking other changes.<br />Thanks to Mikiya for your advice.<br /><br />Enjoy!Kentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.com2tag:blogger.com,1999:blog-7870178081855084823.post-84506804013914622482010-05-18T00:38:00.000+09:002010-05-18T00:40:27.912+09:00[MySQL][Spider][VP][Other]Spider-2.20 VP-0.10 BKA-for-ha_partition-0.2 releasedI'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.<br />Spider is a Storage Engine for database sharding.<br /><a href="http://spiderformysql.com/">http://spiderformysql.com/</a><br />Vertical Partitioning is a Storage Engine for vertical partitioning for a table.<br /><a href="http://launchpad.net/vpformysql">http://launchpad.net/vpformysql</a><br />BKA-for-ha_partition is a patch file of supporting "Batched Key Access" for table partitioning feature.<br /><a href="http://launchpad.net/partitionmrrformysql">http://launchpad.net/partitionmrrformysql</a><br /><br />The main changes in this version are following.<br />Spider<br />- "spider_multi_split_read" supports dividing condition count.<br />From this release, there is "install_spider.sql" file for installing and updating Spider. Please use this file.<br /><br />Vertical Partitioning<br />- Support "Batched Key Access".<br /> This feature is now available on MariaDB 5.3 with "join_cache_level=6 and more".<br /><br />Please see "99_change_logs.txt" in the download documents for checking other changes.<br /><br />Enjoy!Kentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.com2tag:blogger.com,1999:blog-7870178081855084823.post-21602543900877816602010-05-04T01:36:00.000+09:002010-05-04T01:38:21.801+09:00[MySQL][Spider]Spider-2.19 releasedI'm pleased to announce the release of Spider storage engine version 2.19(beta).<br />Spider is a Storage Engine for database sharding.<br /><a href="http://spiderformysql.com/">http://spiderformysql.com/</a><br /><br />The main changes in this version are following.<br />- Support "Batched Key Access".<br /> This feature is now available on MariaDB 5.3 with "join_cache_level=6 and more".<br /><br />Please see "99_change_logs.txt" in the download documents for checking other changes.<br /><br />Enjoy!Kentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.com0tag:blogger.com,1999:blog-7870178081855084823.post-21980056206255034032010-04-29T16:28:00.000+09:002010-04-29T16:29:37.915+09:00[MySQL][Spider]Spider-2.18 releasedI'm pleased to announce the release of Spider storage engine version 2.18(beta).<br />Spider is a Storage Engine for database sharding.<br /><a href="http://spiderformysql.com/">http://spiderformysql.com/</a><br /><br />The main changes in this version are following.<br /> This release is bug fix release.<br /><br />Please see "99_change_logs.txt" in the download documents for more detail.<br /><br />Enjoy!Kentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.com0tag:blogger.com,1999:blog-7870178081855084823.post-52506470757693874412010-03-27T05:54:00.000+09:002010-03-27T05:55:28.573+09:00[MySQL][Spider]Spider-2.17 releasedI'm pleased to announce the release of Spider storage engine version 2.17(beta).<br />Spider is a Storage Engine for database sharding.<br /><a href="http://spiderformysql.com/">http://spiderformysql.com/</a><br /><br />The main changes in this version are following.<br />- Add table parameter "semi_split_read_limit".<br />- Add server parameter "spider_semi_split_read_limit".<br /> This parameters are for searching performance improvement.<br /><br />Please see "99_change_logs.txt" in the download documents for checking other changes.<br /><br />Enjoy!Kentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.com0tag:blogger.com,1999:blog-7870178081855084823.post-42534794540021631122010-03-15T04:04:00.001+09:002010-03-15T04:06:29.805+09:00[MySQL][Spider][VP]Spider-2.16 Vartical Partitioning-0.9 releasedI'm pleased to announce the release of Spider storage engine version 2.16(beta) and Vertical Partitioning storage engine version 0.9(beta).<br />Spider is a Storage Engine for database sharding.<br /><a href="http://spiderformysql.com/">http://spiderformysql.com/</a><br />Vertical Partitioning is a Storage Engine for vertical partitioning for a table.<br /><a href="http://launchpad.net/vpformysql">http://launchpad.net/vpformysql</a><br /><br />The main changes in this version are following.<br />(This release for Vertical Partitioning is a bug fix release)<br />- Add table parameter "semi_split_read".<br />- Add server parameter "spider_semi_split_read".<br /> This parameters are for searching performance improvement.<br /><br />Please see "99_change_logs.txt" in the download documents for checking other changes.<br /><br />Enjoy!Kentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.com0tag:blogger.com,1999:blog-7870178081855084823.post-77863561742589846962010-03-08T03:30:00.001+09:002010-03-08T03:30:52.041+09:00[MySQL][Spider]Spider-2.15 releasedI'm pleased to announce the release of Spider storage engine version 2.15(beta).<br />Spider is a Storage Engine for database sharding.<br /><a href="http://spiderformysql.com/">http://spiderformysql.com/</a><br /><br />The main changes in this version are following.<br /> This release is bug fix release.<br /><br />Please see "99_change_logs.txt" in the download documents for more detail.<br /><br />Enjoy!Kentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.com0tag:blogger.com,1999:blog-7870178081855084823.post-89298190940976287472010-03-02T04:00:00.001+09:002010-03-02T04:00:52.474+09:00[MySQL][Spider]Spider-2.14 releasedI'm pleased to announce the release of Spider storage engine version 2.14(beta).<br />Spider is a Storage Engine for database sharding.<br /><a href="http://spiderformysql.com/">http://spiderformysql.com/</a><br /><br />The main changes in this version are following.<br />- Add table parameter "bulk_update_mode" and "bulk_update_size".<br />- Add server parameter "spider_bulk_update_mode" and "spider_bulk_update_size".<br /> This parameters are for performance improvement.<br /> Please examine to use "spider_direct_dup_insert", if "REPLACE" and "INSERT IGNORE" are slow.<br /> Please examine to use "spider_bulk_update_mode", if "UPDATE" and "DELETE" are slow.<br /><br />Please see "99_change_logs.txt" in the download documents for checking other changes.<br /><br />Enjoy!Kentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.com0tag:blogger.com,1999:blog-7870178081855084823.post-29882463730923127462010-02-21T15:41:00.001+09:002010-02-21T15:43:40.919+09:00[MySQL][Spider]Spider-2.13 releasedI'm pleased to announce the release of Spider storage engine version 2.13(beta).<br />Spider is a Storage Engine for database sharding.<br /><a href="http://spiderformysql.com/">http://spiderformysql.com/</a><br /><br />The main changes in this version are following.<br /> This release is bug fix release.<br /><br />Please see "99_change_logs.txt" in the download documents for more detail.<br />Thanks to Mitsuhiro for bug report.<br /><br />Enjoy!Kentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.com0tag:blogger.com,1999:blog-7870178081855084823.post-56989063614480442912010-02-18T04:56:00.001+09:002010-02-18T04:56:44.917+09:00[MySQL][VP]VP-0.8 releasedI'm pleased to announce the release of Vertical Partitioning storage engine version 0.8(alpha).<br />Vertical Partitioning is a Storage Engine for vertical partitioning for a table.<br /><a href="http://launchpad.net/vpformysql">http://launchpad.net/vpformysql</a><br /><br />The main changes in this version are following.<br /> This release is bug fix release.<br /><br />Please see "99_change_logs.txt" in the download documents for more detail.<br /><br />Enjoy!Kentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.com0tag:blogger.com,1999:blog-7870178081855084823.post-31639437738592091712010-01-31T18:28:00.002+09:002010-01-31T18:30:34.821+09:00[MySQL][VP][Other]Start creating Engine Independent Test & VP-0.7 releasedI started creating "Engine Independent Test".<br /><a href="http://launchpad.net/engineindependenttestformysql">http://launchpad.net/engineindependenttestformysql</a><br /><br />This test aims to be testable with all storage engines.<br />There is following wiki but test was not created yet.<br /><a href="http://forge.mysql.com/wiki/EngineIndependentTestSuite">http://forge.mysql.com/wiki/EngineIndependentTestSuite</a><br />I think this test is need for Storage Engine Developers(including me).<br />Additionally, I already released 2 Storage Engines so I felt needing this test strongly.<br />So I started creating "Engine Independent Test".<br /><br />Please tell me without hesitate if you have a demand.<br /><br /><br />I'm pleased to announce the release of Vertical Partitioning storage engine version 0.7(alpha).<br />Vertical Partitioning is a Storage Engine for vertical partitioning for a table.<br /><a href="http://launchpad.net/vpformysql">http://launchpad.net/vpformysql</a><br /><br />The main changes in this version are following.<br /> MariaDB support.<br /><br />Please see "99_change_logs.txt" in the download documents for checking other changes.<br /><br />Please enjoy and go forward!Kentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.com0tag:blogger.com,1999:blog-7870178081855084823.post-53350653292952035262010-01-22T03:22:00.000+09:002010-01-22T03:23:53.557+09:00[MySQL][Spider]Spider-2.12 releasedI'm pleased to announce the release of Spider storage engine version 2.12(beta).<br />Spider is a Storage Engine for database sharding.<br /><a href="http://spiderformysql.com/">http://spiderformysql.com/</a><br /><br />The main changes in this version are following.<br /> MariaDB support.<br />- Add server parameter "spider_connect_mutex", "spider_connect_retry_count" and "spider_connect_retry_interval".<br /> This parameters are used for avoiding failed connected processing caused by intense connected processing. (Especially for using "spider_conn_recycle_mode=0")<br /><br />Please see "99_change_logs.txt" in the download documents for checking other changes.<br />Thanks to Mohammad and Jay for bug report.<br /><br />Enjoy!Kentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.com0tag:blogger.com,1999:blog-7870178081855084823.post-46993393611507460072009-12-28T01:48:00.000+09:002009-12-28T01:49:09.331+09:00[MySQL][Spider]Spider-2.11 releasedI'm pleased to announce the release of Spider storage engine version 2.11(beta).<br />Spider is a Storage Engine for database sharding.<br /><a href="http://spiderformysql.com/">http://spiderformysql.com/</a><br /><br />The main changes in this version are following.<br />- Add table link background monitoring feature.<br />- Add table parameter "monitoring_bg_interval" and "monitoring_bg_kind".<br /><br />Please see "99_change_logs.txt" in the download documents for checking other changes.<br /><br />Enjoy!Kentokuhttp://www.blogger.com/profile/18099681482278224662noreply@blogger.com0