Mroonga blog

2017-01-13

Mroonga 6.13 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 6.13 has been released!

Changes

Here are the topics in this release:

  • Supported MySQL 5.7.17.
  • Supported MariaDB 10.2.3.

Now, you can use Mroonga with the latest MySQL and MariaDB!

Conclusion

Please refer to Release 6.13 about detailed changes since 6.11.

Let's go all out to search by Mroonga!

2016-11-29

Mroonga 6.11 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 6.11 has been released!

We recommends to upgrade if you use COUNT(*) in InnoDB wrapper mode for MySQL 5.7.

Changes

Here is the topics in this release.

  • Supported Mroonga with MariaDB 10.x for Debian jessie

Supported Mroonga with MariaDB 10.x for Debian jessie

In this release, we began to support Mroonga packages for MariaDB 10.x on Debian jessie.

This support is provided for Debian jessie because MariaDB 10.x packages are also available on this release and it aims to make it easy to try Mroonga for user of MariaDB.

To install Mroonga package for MariaDB, use mariadb-server-10.0-mroonga.

$ sudo apt-get install -y -V mariadb-server-10.0-mroonga

Conclusion

Please refer to Release 6.11 - 2016-11-29 about detailed changes since 6.10.

Let's go all out to search by Mroonga!

2016-10-29

Mroonga 6.10 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 6.10 has been released!

We recommends to upgrade if you use COUNT(*) in InnoDB wrapper mode for MySQL 5.7.

Changes

Here is the topics in this release.

  • Supported Ubuntu 16.10 (Yakkety Yak)
  • Supported Mroonga with MariaDB 10.x for Ubuntu 16.04 or later

Supported Ubuntu 16.10 (Yakkety Yak)

In this release, we began to support Ubuntu 16.10 (Yakkety Yak).

Mroonga packages are provided on PPA, you can install as follows:

$ sudo apt-get install -y -V software-properties-common lsb-release
$ sudo add-apt-repository -y universe
$ sudo add-apt-repository "deb http://security.ubuntu.com/ubuntu $(lsb_release --short --codename)-security main restricted"
$ sudo add-apt-repository -y ppa:groonga/ppa
$ sudo apt-get update
$ sudo apt-get install -y -V mysql-server-mroonga

Supported Mroonga with MariaDB 10.x for Ubuntu 16.04 or later

In this release, we began to support Mroonga packages for MariaDB 10.x.

This support is provided for Ubuntu 16.04 or later because MariaDB 10.x packages are available on these releases and it aims to make it easy to try Mroonga for user of MariaDB.

To install Mroonga package for MariaDB, use mariadb-server-mroonga.

$ sudo apt-get install -y -V mariadb-server-mroonga

Conclusion

Please refer to Release 6.10 - 2016-10-29 about detailed changes since 6.09.

Let's go all out to search by Mroonga!

2016-09-29

Mroonga 6.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 6.09 has been released!

Changes

Here is the topic in this release.

  • Supported nonexistent reference insert check for FOREIGN KEY

Supported nonexistent reference insert check for FOREIGN KEY

In the previous versions, there is no support about reference insert check for FOREIGN KEY.

create table HOGES( 
  ID         INT PRIMARY KEY AUTO_INCREMENT,
  HOGE       VARCHAR(255)
) ENGINE=Mroonga;
create table FOODS( 
  ID         INT PRIMARY KEY AUTO_INCREMENT,
  HOGE_ID    INT(10),
  FOO        VARCHAR(255),
  foreign key(HOGE_ID) references HOGES(ID)
) ENGINE=Mroonga ;

so, invalid data was inserted without error if you use above schema.

Note that FOREIGN KEY check doesn't work for old version of MySQL and folks such as MySQL 5.5 or MariaDB 5.5, and FOREIGN KEY check for INSERT/DELETE is not supported yet. (it will be supported in the future release!)

Conclusion

Please refer to Release 6.09 - 2016-09-29 about detailed changes since 6.08.

Let's go all out to search by Mroonga!

2016-08-29

Mroonga 6.08 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 6.08 has been released!

Changes

There are two topics in this release.

  • Limitation about the maximum number record is relaxed
  • Fixed compile error with GCC 6

Limitation about the maximum number record is relaxed

A table had the following limitations. This limitation is derived from Groonga.

  • The maximum one key size: 4KiB
  • The maximum total size of keys: 4GiB
  • The maximum number of records: 268,435,455 (more than 268 million)

In the past, the maximum number of records is announced as 268 million.

With recent research, it turns out that there is a capability to store more records than ever.

Here is the updated limitation about the maximum number of records:

  • No primary key table: 1,073,741,815 (2^30 - 9)
  • PRIMARY KEY or PRIMARY KEY USING BTREE table: 1,073,741,823 (2^30 - 1)
  • PRIMARY KEY USING HASH table: 536,870,912 (2^29)

Keep in mind that these limitations may vary depending on conditions.

Fixed compile error with GCC 6

In this release, compile error with GCC 6.1.1 was fixed.

If you failed to compile Mroonga from source archive, please confirm whether the version of GCC is matched to GCC 6.1.1.

Conclusion

Please refer to Release 6.08 - 2016-08-29 about detailed changes since 6.07.

Let's go all out to search by Mroonga!