The Home for Magento 2 Excellence

Quality-tested Magento 2 modules. Explore. Evaluate. Elevate. #magento2

726 Modules
488 Ready
233 Need Help
🏆 Leaderboard
Actively Maintained v1.1.12

Legacy MySQL Search

redchamps/module-search-mysql-legacy

Restores MySQL-based catalog search for Magento 2.4+, which removed native MySQL search support in favor of Elasticsearch. Enables stores without Elasticsearch to continue using MySQL as their search engine.

1
Downloads
Below average
0
GitHub Stars
1mo ago
Last Release
0
Open Issues
Build Issues
1/3 checks passed

Build Tests

Composer Install
DI Compile
Templates

Code Quality

CS Coding Standard
242 warnings
PHPStan Failed

Tested on Magento 2.4.8-p4

Recent Test History

Each release is tested against the latest Magento version at that time.

v1.1.12 on Magento 2.4.8-p4
Mar 21, 2026

Looking for Contributors

Dependency injection compilation fails. Your contribution could help the entire Magento community!

Contribute

Share This Module's Status

Legacy MySQL Search Magento compatibility status badge

README

Loaded from GitHub

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:

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'

This content is fetched directly from the module's GitHub repository. We are not the authors of this content and take no responsibility for its accuracy, completeness, or any consequences arising from its use.