Mroonga blog

2021-05-31

Mroonga 11.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 11.03 has been released!

Important notice

There are a few words caution about upgrade to this version. If we upgrade to this version, please always be sure to confirm below points.

1.

  • The package names are changed from this release. Mroonga may be invalid after upgrade to this version by the influence of this modification.

  • If Mroonga is invalid after the upgrade, we need to install manually Mroonga again. Please refer to the following URL about the manual installation of Mroonga and how to confirming whether Mroonga is valid or not.

  • Besides, please be careful the above phenomenon will continue from now if we will upgrade mroonga to stride over a Mroonga 11.03.

  • If Mroonga is valid after upgrade to this version but, Mroonga's version is old, we need to restart MySQL, MariaDB, or PerconaServer.

    • We can confirm Mroonga's version as the below command.

      • SHOW VARIABLES LIKE 'mroonga_version';

2.

  • There are broken backward compatibility on this version.

  • Users that are using GEOMETRY type need to store the current data before upgrading to Mroonga 11.03 and restore the stored data after upgrading to Mroonga 11.03.

  • Users can use the following methods for dumping/restoring data.

    • mysqldump
    • Execute ALTER TABLE ENGINE=InnoDB before upgrading and execute ALTER TABLE ENGINE=Mroonga after upgrading.

Changes

The main changes are as follows.

Improvements

  • Renamed package names as below.

    • mariadb-server-10.x-mroonga -> mariadb-10.x-mroonga
    • mysql-server-5.x-mroonga -> mysql-community-5.x-mroonga
    • mysql-server-8.x-mroonga -> mysql-community-8.x-mroonga
    • percona-server-5x-mroonga -> percona-server-5.x-mroonga
    • percona-server-8x-mroonga -> percona-server-8.x-mroonga

  • Debian GNU/Linux Added support for the Oracle MySQL 5.7 package and the Oracle MySQL 8.0 package.

    • In this release, we newly provided the package of Mroonga for Debian GNU/Linux with the Oracle MySQL 5.7 and the Oracle MySQL 8.0.

      • By this, we make the Docker image of Mroonga with MySQL for Docker official images.

    • There are below restrictions in the MySQL8 package.

      • Wrapper mode Wrapper mode is not supported yet.

      • Storage mode Storage mode does not support the following feature.

        • The feature of relevant to the optimization.

  • Added support for the SRID of Spatial Indexes.

    • the index of Mroonga is used in search with MBRContains function on MySQL 8.x since this release.

  • We added condition expressions that are applied condition push down.

    Note

    • Condition push down doesn't evaluate condition expressions in MySQL, but it evaluate condition expressions in Mroonga.

    • Therefore, more queries will become high-performance, but the result of search may different than usual by Mroonga evaluate them.**

    • If Mroonga returns unexpected search results, we request that you report from the below URL. And we would like you to invalid for condition push down.

      • https://github.com/mroonga/mroonga/issues/

    • We can invalid condition push down as below.

      • SET GLOBAL mroonga_condition_push_down_type = "NONE"

  • CentOS Added support for Percona Server 8.0.23

Fixes

  • Fixed a bug that latitude and longitude are stored conversely.

    Important

    • backward compatibility is broken by this fix.

    • Users that are using GEOMETRY type need to store the current data before upgrading to Mroonga 11.03 and restore the stored data after upgrading to Mroonga 11.03. Users can use the following methods for dumping/restoring data.

      • mysqldump
      • Execute ALTER TABLE ENGINE=InnoDB before upgrading and execute ALTER TABLE ENGINE=Mroonga after upgrading.

    • If without this fix, INSERT/UPDATE/SELECT/SELECT works well but data stored in Groonga are wrong (Latitude and longitude are swapped in Groonga). Therefore, mroonga_command('select ...') doesn't work for spatial data.

Conclusion

See Release 11.03 - 2021-05-31 about detailed changes since 11.02.

Let's search by Mroonga!

2021-05-10

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

Changes

The main changes are as follows.

Improvements

  • CentOS Added support for MySQL 5.7.34, 8.0.25.

    • There are below restrictions in the MySQL8 package.

      • [Wrapper mode] Wrapper mode is not supported yet.

      • [Storage mode] Storage mode does not support the following feature.

        • The feature of relevant to the optimization.
        • The SRID of Spatial Indexes.
          • For example, the index of Mroonga is not used in search with MBRContains function. (It search by sequential search.)

  • CentOS Added support for MariaDB 10.2.38, 10.3.29, 10.4.19, and 10.5.10.

  • Ubuntu Dropped Ubuntu 16.04 (Xenial Xerus) support.

    • Because it reached End of Standard Support at April, 2021.

Conclusion

See Release 11.02 - 2021-05-10 about detailed changes since 11.01.

Let's search by Mroonga!

2021-04-02

Mroonga 11.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 11.01 has been released!

Changes

The main changes are as follows.

Improvements

  • CentOS Added support for MariaDB 10.2.37, 10.3.28, 10.4.18, and 10.5.9.

  • CentOS Added support for Percona Server 5.7.33.

  • Added support for adding value with text in JSON format to reference vector columns.

Fixes

  • Fixed a bug that FOREIGN KEY constraint was not registered.

    • This bug had only occurred on MySQL 8.0.

  • Fixed a bug that DROP DATABASE had failed if a target database had FOREIGN KEY constraint.

  • Fixed a bug that DROP COLUMN had failed if a target table was referred to the other tables.

  • Fixed a build error when we built Mroonga with MariaDB 10.3.28, 10.4.18, or 10.5.9.

  • Fixed a bug that an update of Mroonga fails on MariaDB.

Conclusion

See Release 11.01 - 2021-04-02 about detailed changes since 11.00.

Let's search by Mroonga!

2021-02-09

Mroonga 11.00 has been released!

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

In this version, MySQL, MariaDB, or PerconaServer will be automatically restarted. Because Mroonga 11.00 requires Groonga 11.0.0 or later but it will not reloaded until MySQL, MariaDB, or PrerconaServer is restarted.

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

Changes

The main changes are as follows.

  • CentOS Dropped support for MySQL 5.6

    • Because it reached EOL at Feb 1, 2021.

  • CentOS Dropped support for Percona Server 5.6

  • Dropped support for MariaDB 10.1 on Ubuntu 18.04 LTS.

    • Because MariaDB 10.1 already has reached EOL in upstream.

  • Updated version of Groonga to 11.0.0 or later that Mroonga requires.

    • Because a high impact bug of index corruption is fixed in Groonga 11.0.0.

Conclusion

See Release 11.00 - 2021-02-09 about detailed changes since 10.11.

Let's search by Mroonga!

2021-01-29

Mroonga 10.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 10.11 has been released!

Changes

The main changes are as follows.

  • Added support for lexicon_flags parameter.

    • We can add KEY_LARGE flag to a USING HASH (non full-text search index) index by this parameter.

  • CentOS Added support for MySQL 5.6.51, 5.7.33, and 8.0.23.

    • There are below restrictions in the MySQL8 package.

      • [Wrapper mode] Wrapper mode is not supported yet.
      • [Storage mode] JSON data type is not supported yet.

  • Optimizations Fixed a bug that the fast order limit optimization doen’t work when “WHERE COLUMN IN (SUBQUERY)” exists.

    • Fixed a bug that we can’t use in place ALTER TABLE when we modify the data type of a column that has any indexes.
    • This bug occur when we execute ALTER TABLE in ALGORITHM=INPLACE. Therefore, this bug doesn’t occur when we use ALTER TABLE in ALGORITHM=COPY.

Conclusion

See Release 10.11 - 2021-01-29 about detailed changes since 10.11.

Let's search by Mroonga!