genaker/module-search-mysql

Legacy mysql search for magento 2.4

3.3.6 2024-03-05 06:29 UTC

Requires

• magento/framework: >=102.0
• magento/module-backend: >=101.0
• magento/module-catalog: >=103.0
• magento/module-catalog-inventory: >=100.3
• magento/module-catalog-search: >=101.0
• magento/module-checkout: >=100.3
• magento/module-cms: >=103.0
• magento/module-customer: >=102.0
• magento/module-eav: >=102.0
• magento/module-search: >=101.0
• magento/module-store: >=101.0

OSL-3.0

• search
• mysql
• legacy

README

^{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 require genaker/module-search-mysql
bin/magento setup:upgrade --safe-mode=1
bin/magento setup:di:compile
bin/magento config:show catalog/search/engine
bin/magento config:set catalog/search/engine 'lmysql'
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'