Mroonga blog

2024-09-25

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

Changes

Here are important changes in this release:

Improvements

  • We use CMake for building instead of the GNU Autotools.

    Using configure is deprecated. We recommend using cmake to build from source.

    Please refer Others about how to build from source with cmake.

Fixes

  • Fixed a bug that SELECT returned wrong result when we used multiple primary keys and primary keys included VARBINARY or BLOB type column.

    This bug only occurred in Mroonga 14.07.

    This bug doesn’t break an index. So, we don’t need to execute REINDEX command after this fix.

    If this bug occurred, the following query retrieved nothing.

    CREATE TABLE logs (
  id INT,
  content VARBINARY(256),
  PRIMARY KEY (id, content)
) ENGINE=Mroonga DEFAULT CHARSET=utf8mb4;

INSERT INTO logs(id, content) VALUES (1, 'aaa');
INSERT INTO logs(id, content) VALUES (2, 'bbb');

SELECT * FROM logs WHERE content = 'aaa';

Conclusion

Let's search by Mroonga!

2024-09-06

Mroonga 14.07 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.07 has been released!

Changes

Here are important changes in this release:

Improvements

  • We added support for MariaDB as below.

    • MariaDB 11.4.3

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

  • Disable descending index support

    If we don't add support for descending index with MariaDB >= 10.8, Mroonga returns wrong result with descending index. So, we disable descending index support now. However, we may re-try it later.

    By the way, if we use descending index with MySQL >= 8.0, MySQL returns error.

Fixes

  • Fix a crash bug with concurrent FLUSH TABLES and INSERT.

Conclusion

Let's search by Mroonga!

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!