Mroonga blog

2017-02-09

Mroonga 7.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.

Mroonga 7.00 has been released!

Changes

This is major version upgrade of Mroonga - 7.00! Even though major version upgrade, it keeps compatibility of Mroonga database.

Here are changes in this release.

  • Supported FOREIGN KEY constrain on UPDATE and DELETE parent row. In the previous versions, only FOREIGN KEY constrain on INSERT is supported.
  • [Storage mode] Supported updating row even though its table has primary key with ROW binlog format. In the previous version, it causes update statement error.

Conclusion

See Release 7.00 - 2017-02-09 about detailed changes since 6.13.

Let's search by Mroonga!

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!