Mroonga blog

2019-06-29

Mroonga 9.04 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine.

Mroonga 9.04 has been released!

Changes

The main changes are as follows.

  • Added support for MySQL 8 packages experimentally.

  • Fixed a crash bug with ((MATCH OR MATCH) AND (MATCH)) query.

Added support for MySQL 8 packages

In this release, Mroonga package which supports MySQL 8 are available on CentOS.

This is experimental, so if you found a bug or doubt behavior, please report to us!

Here is the documentation about "How to report a bug".

Here are already known issues about MySQL 8.0

Fixed a crash bug with ((MATCH OR MATCH) AND (MATCH)) query.

In this release, a crash bug was fixed. This crash bug was occurred when ((MATCH AGAINST (...) OR MATCH AGAINST(...)) AND (MATCH AGAINST(...))) was used in where clause.

Mroonga has condition push down feature (Optimization to process search condition at Groonga level rather than MySQL level). This bug was derived from incorrect handling of above query optimization.

Conclusion

See Release 9.04 - 2019-06-29 about detailed changes since 9.03.

Let's search by Mroonga!

2019-05-29

Mroonga 9.03 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine.

Mroonga 9.03 has been released!

Changes

The main changes are as follows.

  • Added support for INDEX_LARGE flag.
  • Added support for latest MySQL/MariaDB/Percona Server.
  • Added support for MariaDB 10.1/10.2 windows packages again.

Added support for INDEX_LARGE flag

In this release, INDEX_LARGE flags is supported.

This flag is used to create index which supports large data. In this context, "large data" depends on its data. But there is a indicator for it - normally at least 10 millions records and targets are multiple columns or index table has tokenizer.

You can specify INDEX_FLAG in COMMENT.

CREATE TABLE memos (
  content VARCHAR(64) NOT NULL,
  KEY (content) COMMENT 'flags "INDEX_LARGE"'
) ENGINE=Mroonga DEFAULT CHARSET=utf8mb4;

Note that INDEX_FLAG requires 2 times larger memory usage than the default index column.

Added support for latest MySQL/MariaDB/Percona Server

In this release, the following latest MySQL/MariaDB/Percona Server has been supported.

  • MySQL 5.6.44, 5.7.26
  • MariaDB 10.1.40.
  • MariaDB 10.2.24.
  • MariaDB 10.3.14, 10.3.15.
  • Percona Server 5.6.44.

Added support for MariaDB 10.1/10.2 windows packages again

In the previous version, we don't officially announced it yet. We began to provide not only MariaDB 10.3 bundled windows package, but also 10.1 and 10.2 package too.

If you use older version of MariaDB (10.1 or 10.2) bundled Mroonga, and not yet upgraded, it is a time to upgrade from it.

Conclusion

See Release 9.03 - 2019-05-29 about detailed changes since 9.01.

Let's search by Mroonga!

2019-03-29

Mroonga 9.01 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine.

Mroonga 9.01 has been released!

Changes

The main changes are as follows.

  • Improved support for more table and comment parameter about tokenizer/nomalizer/indexes.
  • Added support for latest MariaDB/Percona Server.
  • Added support for building bundled MariaDB package on AppVeyor.

Improved support for table and comment parameter about tokenizer/nomalizer/indexes

In this release, tokenizer/nomalizer/indexes support is improved.

In storage mode, you can specify tokenizer options in COMMENT section.

CREATE TABLE foo (...) COMMENT='tokenizer "TokenNgram('n', 4)"'

Note that default_tokenizer is deprecated. use tokenizer instead.

You can also specify LEXICON index parameter.

FULLTEXT INDEX foo (bar) LEXICON='terms'

or

FULLTEXT INDEX foo (bar) COMMENT 'lexicon "terms"'

for MariaDB, TOKENIZER, NORMALIER and TOKEN_FILTERS table parameter has been supported.

CREATE TABLE foo (...) TOKENIZER='TokenNgram("n", 4)'
CREATE TABLE foo (...) NORMALIZER='NormalizerNFKC100("unify_kana", true)'
CREATE TABLE foo (...) TOKEN_FILTERS='TokenFilterNFKC100("unify_katakana_v_sounds", true)'

Added support for latest MariaDB/Percona Server

In this release, the following latest MariaDB/Percona Server has been supported.

  • Percona Server 5.7.25-28.
  • MariaDB 10.3.13.
  • MariaDB 10.2.23.

Added support for building bundled MariaDB package on AppVeyor

In the previous versions, we use AppVeyor just for testing build on Windows. So, release package for Windows had been built manually.

In this release, packages are also available on AppVeyor.

Mroonga package is also available as artifacts from:

Conclusion

See Release 9.01 - 2019-03-29 about detailed changes since 9.00.

Let's search by Mroonga!

2019-02-09

Mroonga 9.00 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine.

This is a major version up! But It keeps backward compatibility. You can upgrade to 9.00 without rebuilding database.

Mroonga 9.00 has been released!

Changes

The main changes are as follows.

  • Added support for MariaDB 10.3.12.
  • Added support for MariaDB 10.2.21.
  • Added support for Percona Server 5.7.24-27.
  • Added support for Percona Server 5.6.43 rel84.3.
  • Added support for MySQL 5.7.25.
  • Added support for MySQL 5.6.43.

In Groonga 9.0.0, TokenPattern, TokenTable tokenizer and remove_blank for NormalizerNFKC100 is supported.

If you upgrade to Groonga 9.0.0, you can use them from Mroonga 9.00!

Conclusion

See Release 9.00 - 2019-02-09 about detailed changes since 8.09.

Let's search by Mroonga!

2018-11-29

Mroonga 8.09 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine.

Mroonga 8.09 has been released!

Changes

The main changes are as follows.

  • Supported Ubuntu 18.10 (Cosmic Cuttlefish).
  • Supported MariaDB 10.3.10.
  • Supported MariaDB 10.2.19
  • Supported MariaDB 10.1.37
  • Supported Percona Server 5.7.23-25.
  • Supported MariaDB 10.3.11.
  • Supported MySQL 5.6.42.
  • Supported MySQL 5.7.24.

Revision: We deleted information as below. "Supported MySQL8 anew"

Sorry, There was wrong release information in Mroonga 8.09. The MySQL 8 is not supported. That is still being handled.

Conclusion

See Release 8.09 - 2018-11-29 about detailed changes since 8.07.

Let's search by Mroonga!