📊 State of Magento 2025

The Home for Magento 2 Excellence

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

606 Modules
385 Ready
218 Need Help
🏆 Leaderboard
Stable v1.1.11

Legacy Mysql Search

swissup/module-search-mysql-legacy

MySQL is no longer supported for search since Magento 2.4. This extension brings back the usage of the MySQL search engine on Magento 2.

79,224
Downloads
Below average
105
GitHub Stars
3x above avg
5mo ago
Last Release
3
Open Issues
Build Passing
Ready to install

Build Tests

Composer Install
DI Compile
Templates

Code Quality

CS Coding Standard
202 warnings
PHPStan Failed

Tested on Magento 2.4.8-p3

Recent Test History

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

v1.1.11 on Magento 2.4.8-p3
Dec 16, 2025
v1.1.11 on Magento 2.4.8-p2
Aug 27, 2025
v1.1.9 on Magento 2.4.8-p2
Aug 14, 2025
v1.1.9 on Magento 2.4.8
Jun 14, 2025
v1.1.8 on Magento 2.4.8
May 22, 2025
v1.1.8 on Magento 2.4.7-p4
Feb 15, 2025

+6 older tests

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.

the_new_legacy_mysql_search_module_for_magento_2-1

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.