Legacy Mysql Search

It's a magento2-module for the metapackage.

The news sometimes isn't good, but there is always a way out. Yes, MySQL is no longer supported for search since Magento 2.4. And you must install Elasticsearch 7.6.x before upgrading to the latest Magento version.

Elastic search is a great solution. Even so, a lot of our customers still prefer using hostings that don’t have it. Let us help you to install Magento 2.4 without Elastic search enabled.

We released the Legacy MySQL Search module for Magento 2

We integrated Magento 2.3.5 MySQL Search mechanism with Magento 2.4. The Legacy MySQL Search module enables a new value in the Search Engine drop-down of Catalog Search config settings.

So you don’t need things to get complicated. You have simply to choose the "Legacy MySQL (Deprecated) value" in drop-down.

Installation

For clients

There are several ways to install extension for clients:

1. If you've bought the product at Magento's Marketplace - use Marketplace installation instructions

2. Otherwise, you have two options:

   • Install the sources directly from our repository - recommended
   • Download archive and use manual installation

For maintainers

cd <magento_root>
composer config repositories.swissup composer https://docs.swissuplabs.com/packages/
composer require swissup/module-search-mysql-legacy --prefer-source --ignore-platform-reqs
bin/magento module:enable Swissup_SearchMysqlLegacy Swissup_Core
bin/magento setup:upgrade --safe-mode=1
bin/magento setup:di:compile
bin/magento indexer:reindex catalogsearch_fulltext

F.A.Q

How to install Magento 2.4.0 without Elasticsearch require during installation?

Use --disable-modules option

bin/magento setup:install -h
...
--disable-modules[=DISABLE-MODULES] List of comma-separated module names, that must be avoided during installation.

php bin/magento setup:install --disable-modules=Magento_InventoryElasticsearch,Magento_Elasticsearch7,Magento_Elasticsearch6,Magento_Elasticsearch

After installing enable all elastic search module with below command.

php bin/magento module:enable Magento_Elasticsearch Magento_Elasticsearch6 Magento_Elasticsearch7 Magento_InventoryElasticsearch

How can I check current search engine?

You can check your current search engine using:

bin/magento config:show catalog/search/engine

How can I change search engine?

You can change your current search engine using:

bin/magento config:set catalog/search/engine 'lmysql'

Configuration

Multi-word Search Logic

Location: Stores > Configuration > Catalog > Catalog Search > Multi-word Search Logic (MySQL Legacy)

Control how multi-word searches are interpreted:

OR Mode (Default) - Original Magento 2.3 behavior

• Search: "red bag"
• Finds: Products containing "red" OR "bag"
• Result: More products, less precise matches

AND Mode (Recommended) - Elasticsearch-like behavior

• Search: "red bag"
• Finds: Products containing "red" AND "bag"
• Result: Fewer products, more relevant matches

Note: Clear cache after changing this setting for immediate effect.

bin/magento cache:clean config

Future: Based on community feedback, AND mode may become the default in version 2.0.