PHPackages                             swissup/module-search-mysql-legacy - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. swissup/module-search-mysql-legacy

ActiveMagento2-module[Database & ORM](/categories/database)

swissup/module-search-mysql-legacy
==================================

Legacy mysql search for magento 2.4

1.1.13(2mo ago)10483.0k↓32.6%37OSL-3.0PHP

Since Dec 2Pushed 2mo ago11 watchersCompare

[ Source](https://github.com/swissup/module-search-mysql-legacy)[ Packagist](https://packagist.org/packages/swissup/module-search-mysql-legacy)[ RSS](/packages/swissup-module-search-mysql-legacy/feed)WikiDiscussions master Synced 1mo ago

READMEChangelogDependencies (24)Versions (19)Used By (0)

Legacy Mysql Search
===================

[](#legacy-mysql-search)

It's a magento2-module for the [metapackage](https://github.com/swissup/search-mysql-legacy/).

The news sometimes isn't good, but there is always a way out. Yes, [MySQL is no longer supported](https://devdocs.magento.com/guides/v2.4/release-notes/backward-incompatible-changes/#230---24) 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-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](https://user-images.githubusercontent.com/412612/176845092-e72c72dd-6f96-43f9-8bb7-04238802eb3e.png)](https://user-images.githubusercontent.com/412612/176845092-e72c72dd-6f96-43f9-8bb7-04238802eb3e.png)

### [Installation](https://docs.swissuplabs.com/m2/extensions/search-mysql-legacy/installation/)

[](#installation)

###### For clients

[](#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](https://docs.magento.com/marketplace/user_guide/buyers/install-extension.html)
2. Otherwise, you have two options:

    - Install the sources directly from [our repository](https://docs.swissuplabs.com/m2/extensions/search-mysql-legacy/installation/composer/) - **recommended**
    - Download archive and use [manual installation](https://docs.swissuplabs.com/m2/extensions/search-mysql-legacy/installation/manual/)

###### For maintainers

[](#for-maintainers)

```
cd
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

[](#faq)

#### How to install Magento 2.4.0 without Elasticsearch require during installation?

[](#how-to-install-magento-240-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?

[](#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?

[](#how-can-i-change-search-engine)

You can change your current search engine using:

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

```

### Configuration

[](#configuration)

#### Multi-word Search Logic

[](#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.

###  Health Score

58

—

FairBetter than 98% of packages

Maintenance84

Actively maintained with recent releases

Popularity48

Moderate usage in the ecosystem

Community25

Small or concentrated contributor base

Maturity62

Established project with proven stability

 Bus Factor1

Top contributor holds 62.3% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~112 days

Recently: every ~68 days

Total

18

Last Release

82d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/33aea824c2948821ee367ad65fab9d355c71d86ce4ff021a40882a410f14ef94?d=identicon)[swissup](/maintainers/swissup)

![](https://www.gravatar.com/avatar/b5eb663f2c3faab23d84a3ea1e7cbb2ff3afb0e27c10eefd018e48455c997c07?d=identicon)[0m3r](/maintainers/0m3r)

![](https://www.gravatar.com/avatar/8b2b6f9fff4e922d92df0d6a7ee3c1aa93ae22045ea60e1f3b5cf8c57e6deb69?d=identicon)[roma84](/maintainers/roma84)

---

Top Contributors

[![0m3r](https://avatars.githubusercontent.com/u/412612?v=4)](https://github.com/0m3r "0m3r (48 commits)")[![ci-swissuplabs](https://avatars.githubusercontent.com/u/40459861?v=4)](https://github.com/ci-swissuplabs "ci-swissuplabs (17 commits)")[![jissereitsma](https://avatars.githubusercontent.com/u/7670482?v=4)](https://github.com/jissereitsma "jissereitsma (5 commits)")[![valerocompsa](https://avatars.githubusercontent.com/u/95219955?v=4)](https://github.com/valerocompsa "valerocompsa (4 commits)")[![roma84](https://avatars.githubusercontent.com/u/2668851?v=4)](https://github.com/roma84 "roma84 (1 commits)")[![rommmka](https://avatars.githubusercontent.com/u/1327047?v=4)](https://github.com/rommmka "rommmka (1 commits)")[![ryantfowler](https://avatars.githubusercontent.com/u/2093288?v=4)](https://github.com/ryantfowler "ryantfowler (1 commits)")

---

Tags

magentomagento2magento2-extensionmagento2-modulemagento2-searchsearchmysqllegacy

### Embed Badge

![Health badge](/badges/swissup-module-search-mysql-legacy/health.svg)

```
[![Health](https://phpackages.com/badges/swissup-module-search-mysql-legacy/health.svg)](https://phpackages.com/packages/swissup-module-search-mysql-legacy)
```

###  Alternatives

[smile/elasticsuite

Magento 2 merchandising and search engine built on ElasticSearch

8044.5M33](/packages/smile-elasticsuite)[dotdigital/dotdigital-magento2-extension

Dotdigital for Magento 2

50374.2k18](/packages/dotdigital-dotdigital-magento2-extension)[mollie/magento2

Mollie Payment Module for Magento 2

1121.6M10](/packages/mollie-magento2)[mage-os/module-inventory-reservations-grid

Add a grid with the list of inventory reservations.

126.8k](/packages/mage-os-module-inventory-reservations-grid)[loki/magento2-admin-components

N/A

151.6k5](/packages/loki-magento2-admin-components)[pagbank/payment-magento

PagBank - Payment for Magento and Adobe

2128.3k7](/packages/pagbank-payment-magento)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)