Mroonga blog

2024-06-12

Mroonga 14.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 14.04 has been released!

This is long time no release!

Changes

Here are important changes in this release:

Improvements

  • We support for OS as below.

    • Ubuntu 24.04 (Noble Numbat)

  • We support for MySQL, MariaDB, and Percona Server as below.

  • We dropped support for OS as below.

    • Amazon Linux 2
    • CentOS 7
    • Debian GNU/Linux 11 (bullseye)

  • We dropped support for MySQL, MariaDB, and Percona Server as below.

    • MySQL Community Server 5.7
    • Percona Server 5.7
    • MariaDB 10.4、10.7、10.8、10.9、10.10

  • Added functionality to output an error when Mroonga's UDF is used while Mroonga is uninitialized. [MDEV-21166][Reported by Ian Gilfillan.]

    Before this fix, using Mroonga's UDF without initializing Mroonga (not having run INSTALL PLUGIN mroonga) would cause a crash. This patch changes the output from a crash to logging an error.

Fixes

  • Wrapper mode Fixed memory leaks in cases where engines not supporting online DDL are wrapped.

    In general, DDL operations like ALTER TABLE block access to the target table while in progress to maintain exclusive control. However, some storage engines allow operations on the target table during these operations (they can also be executed exclusively). The capability to operate on a table during such DDL operations is referred to as online DDL.

    The issue addressed occurs when wrapping storage engines that do not support online DDL in Mroonga's wrapper mode. It does not occur in storage mode or when using a combination of wrapper mode + InnoDB.

  • Storage mode Fixed a bug causing crashes when inserting into tables with compressed VARCHAR or TEXT columns. [MDEV-31966][Reported by Elena Stepanova.]

    This issue occurs only in storage mode and not in wrapper mode.

Thanks

  • Ian Gilfillan
  • Elena Stepanova

Conclusion

Let's search by Mroonga!

2023-08-02

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

Changes

Here are important changes in this release:

Improvements

  • CentOS, AlmaLinux Added support MySQL 5.7.43.

  • CentOS, AlmaLinux Added support MySQL 8.0.34.

  • CentOS, AlmaLinux Added support for Percona Server 5.7.42-46.

  • CentOS, AlmaLinux Added support for Percona Server 8.0.33-25.

  • CentOS, AlmaLinux Added support MariaDB 10.4.30, 10.5.21, 10.6.14, 10.8.8, 10.9.7, 10.10.5, and 10.11.4.

  • CentOS Added support for MariaDB 10.5.19.

  • CentOS Added newly support for Debian 12 (bookworm).

    However, we only support Mroonga with MariaDB 10.11 in this release.

    Because the source of MySQL Community Server for Debian 12 doesn't exist in MySQL APT Repository(https://repo.mysql.com/apt/debian/dists/) currently.

    Therefore, we don't support Mroonga with MySQL community server 8.0 on Debian 12 temporarily. We will support Mroonga with MySQL community server 8.0 after the source of it for Debian 12 is available.

  • Dropped support for MariaDB 10.3.

    It reached EOL on 2023-05-25.

Conclusion

Please refer to release note about the detail of changes in this release.

Let's search by Mroonga!

2023-04-17

Mroonga 13.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 13.01 has been released!

Changes

Here are important changes in this release:

Improvements

  • CentOS, AlmaLinux Added newly support for MariaDB 10.11.

  • Amazon Linux 2 Added support for MariaDB 10.5.18-1.amzn2.

  • CentOS, AlmaLinux Added support for Percona Server 8.0.32-24.

  • CentOS, AlmaLinux Added support for Percona Server 5.7.41-44.

  • [Oracle Linux] Dropped support for Oracle Linux 8 and 9

    We supported Oracle Linux for installing Mroonga to MySQL official Docker image. However, a package that needed to install to MySQL official Docker image is Mroonga for MySQL community server minimal

    Therefore, we cann't install Mroonga to MySQL official Docker image even if we use Mroonga for Oracle Linux.

  • Ubuntu Dropped support for Ubuntu 18.04.

    Because Ubuntu 18.04 reached EOL.

  • AlmaLinux Added support for MySQL community server minimal 8.0.

    This is for supporting the mysql:8.0-oracle Docker image.

Conclusion

Please refer to release note about the detail of changes in this release.

Let's search by Mroonga!

2023-02-09

Mroonga 13.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 13.00 has been released!

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

Note

Currently, we don't provide packages of Mroonga 13.00 for Percona Server. Because there is a problem with buildong packages of Mroonga 13.00 for Percona Server.

If we will resolve this problem, we will provide packages of Mroonga for Percona Server again.

Changes

Here are important changes in this release:

Improvements

  • CentOS, AlmaLinux Added support for MariaDB 10.3.38, 10.4.28, 10.5.19, 10.6.12, 10.7.8, 10.8.7, 10.9.5, and 10.10.3.

Conclusion

Please refer to release note about the detail of changes in this release.

Let's search by Mroonga!

2023-01-29

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

Changes

Here are important changes in this release:

Improvements

We could not update normal columns when we set composite primary keys using Mroonga storage engine as below.

CREATE TABLE scores (
  name char(30) NOT NULL,
  score int NOT NULL,
  PRIMARY KEY (name, score),
  note char(30),
  FULLTEXT INDEX search_note_idx (note)
) ENGINE = Mroonga DEFAULT CHARSET=utf8mb4;

INSERT INTO scores (name, score) VALUES ("Taro Yamada", 29);

UPDATE scores SET note = "Note"
  WHERE name = "Taro Yamada" AND score = 29;

ERROR 1265 (01000): data truncated for primary key column: <name>

This error doesn’t occur Mroonga with MariaDB.

Thanks

  • handmound

Conclusion

Please refer to release note about the detail of changes in this release.

Let's search by Mroonga!