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(4mo ago)10489.2k↓36.2%38OSL-3.0PHP

Since Dec 2Pushed 4mo 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 today

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

56

—

FairBetter than 97% of packages

Maintenance77

Regular maintenance activity

Popularity48

Moderate usage in the ecosystem

Community25

Small or concentrated contributor base

Maturity63

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

128d 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://avatars.githubusercontent.com/u/2668851?v=4)[Chumak Roman](/maintainers/roma84)[@roma84](https://github.com/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

[mollie/magento2

Mollie Payment Module for Magento 2

1131.9M16](/packages/mollie-magento2)[buckaroo/magento2

Buckaroo Magento 2 extension

32420.3k8](/packages/buckaroo-magento2)[smile/elasticsuite

Magento 2 merchandising and search engine built on ElasticSearch

8064.7M49](/packages/smile-elasticsuite)[run-as-root/magento2-prometheus-exporter

Magento2 Prometheus Exporter

68357.9k](/packages/run-as-root-magento2-prometheus-exporter)[opengento/module-category-import-export

This module add the capability to import and export the categories from the back-office.

1310.9k2](/packages/opengento-module-category-import-export)[loki/magento2-components

Core module for defining Alpine.js components with advanced AJAX features

1011.8k26](/packages/loki-magento2-components)

PHPackages © 2026

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