MySQL Search for Magento 2

MySQL Search Extension for Magento 2
Hyvä Compatible Themes Out-of-the-box
Mage-OS Compatible
Composer Installation Composer Installation?

Run Your Magento Store Without Elasticsearch

Simplify Your Magento 2 Technology Stack:
Run your Magento 2 store with MySQL as search engine instead of Elasticsearch.

Make Your Magento Store Small Again:

  • Magento 2 Without Elasticsearch
  • Reduced Cost
  • Reduced Complexity
  • Get Rid Of A Point-of-Failure

See All Highlights

License:


Magento Marketplace Approved by
  • One-Time Payment
  • Lifetime Access To Source Code
  • 1 Year Free Support
  • 1 Year Free Updates
awesomeicons6/brands/magento

Approved & Verified by Magento Marketplace

awesomeicons6/brands/hyva-monotone

Hyvä Theme
Compatible

awesomeicons6/solid/code-fork

Unencrypted. 100% Open Source & Customizable

awesomeicons6/solid/code

Coding Standards Applied. Clean & Readable Code

awesomeicons6/regular/face-smile-beam

Countless Satisfied Customers: Be The Next One!

awesomeicons6/regular/heart

Made With Love

Our extensions are made with love & passion for building new things, perfection & performance in mind.

awesomeicons6/solid/handshake

Field Tested

Our extensions are field-proven in our own client projects.

Solution

MySQL Search For Your Magento 2 Store

Run Your Magento Store without Elasticsearch

THE PROBLEM
ELASTICSEARCH
IS REQUIRED
FOR MAGENTO 2

Since Magento version 2.4 Elasticsearch is mandatory and required for Magento to run. Without Elasticsearch, Magento has no search function and even does not show any products.
It is great to have Elasticsearch integrated in Magento out-of-the-box as it provides a powerful, modern search experience.
However, many Magento stores do not need Elasticsearch or benefit from Elasticsearch at all.
For example stores with a small catalog or products/customer target group where a fancy full text search is of low priority. Elasticsearch is also not needed by stores that use an external search service such as Algolia, Klevu, Hello Retail, Doofinder etc..
In such cases there is not only no value added by Elasticsearch.
Even worse, it is just an unnecessary additional level of complexity, single point of failure and cost factor for no good reason.

THE SOLUTION
MAGENTO 2
WITHOUT
ELASTICSEARCH

With the MySQL Search extension for Magento 2 by JaJuMa you can now run your Magento 2 store without Elasticsearch again, exactly and just as good as it was before Magento version 2.4.
BUT:

  • Save the money and troubles
    for hosting and maintaining Elasticsearch.
  • Avoid another single-point of failure
    by removing Elasticsearch from your Magento 2 technology stack.
Make your Magento store small again!
Use Magento with the search function based on MySQL as before Magento 2.4 or enjoy the search experience as provided by an external search provider of your choice - while at the same time reducing the complexity and cost of your Magento store!
Get our MySQL Search extension now and start saving money today!
Thanks to reduced hosting requirements and an easier to maintain Magento...

Highlights

MySQL Search for Magento 2 by JaJuMa-Develop
Magento without Elasticsearch =

Reduced Costs - Reduced Complexity - Less Risk Of Failure

awesomeicons6/solid/magnifying-glass-plus

MySQL as Search Engine
For Magento 2

As In Magento Versions < 2.4

awesomeicons6/solid/ban

Run Magento 2
Without Elasticsearch

For A Simplified Technology Stack

awesomeicons6/solid/check

Install Magento 2
Without Elasticsearch

Or Switch Existing Store to MySQL Search

awesomeicons6/solid/money-bill-1wave

Reduced Cost For
Hosting & Hardware

By Getting Rid Of Elasticsearch

awesomeicons6/solid/arrows-to-circle

Reduced Complexity
For Your Magento 2 Store

For Easier Maintenance & Operations

awesomeicons6/solid/bug

Eliminate
Point-of-Failure

For More Reliability

awesomeicons6/brands/hyva-colored
Hyvä Theme Compatible
See Hyvä Demo
awesomeicons6/brands/mage-os-filled
Mage-OS Compatible
See Mage-OS Demo

Details

MySQL Search For Magento 2
by JaJuMa In Detail.
Make Your Magento Store Small Again
By Eliminating Elasticsearch From Your Technology Stack.

JaJuMa MySQL Search Extension

Of Course, It's Great To See Magento Evolving, Getting Better And More Modern.

Any integration of new and contemporary technology into Magento is very welcome.
However, Magento became as popular as it is because of it's flexibility. Magento is Open-Source and Open-Source is always also about choice and the freedom of choice.

Unfortunately, with the decision to remove MySQL as search engine from Magento core and making Elasticsearch the only supported and thus required search engine, Adobe broke with the previous Magento philosophy of being powered by flexibility, freedom of choice and being a suitable solution for merchants and online stores from small/medium size businesses up to enterprise level companies.
The good news is: Magento is still open source and will always be open source.
This means nothing less than that the legendary community can still shape Magento to keep up with it's original philosophy and with everyone's needs.
JaJuMa MySQL Search is one small piece of the puzzle of giving merchants the freedom of choice, the option to use and run Magento in whatever way is most suitable for them. And not be dependent on some obscure decision made by some big company that does not care about the users of their product.

MySQL Search For Magento 2
Use-Cases Why You Might Not Need Elasticsearch

Stores With A Small Catalog

Search results with MySQL Search are not all bad. After all, it was good enough for most Magento stores before Magento 2.4.
E. g. Stores with a rather small catalog are one example use-case where Elasticsearch is simply over-engineered and does not justify the extra costs and complexity over MySQL as search engine.

Full-Text Search Not Important For Customers

Who knows your customers, their wishes and behavior better than you as a merchant?
You have setup your store with a well organized navigation structure, customers find the products they are looking for easily without a search or simply use the full-text search only very little for whatever reason.

Stores That Are Using External Search Services

No question: An outstanding and excellent search experience is crucial for most Magento stores!
Nowadays many Magento stores integrate external search services that provide search experiences that are superior to the Magento default one based on Elasticsearch. Faster, better Live-Search, better search results...
But why take the cost and troubles for two search engines, the external one + Elasticsearch?

Development Environments

Developing on Magento is challenging enough.
And the last thing you want as a developer is wasting your time getting your development environment up and running and maintaining it. For many developer and testing tasks, the search function is simply not necessary.
Reduce your development times by having an option to switch to a search engine that simply works without further ado.

Write Your Review

Your Rating:
Loading...

You submitted your review for moderation.

Frequently Asked Questions

General Magento Extension Questions
How to install Magento 2 extensions from JaJuMa?

We offer different ways of Magento 2 extension installation:

Before Installing

  • We recommend you to duplicate your live store on a staging/test site and try installation on your staging/test site before deploying to your live store
  • Backup Magento files and the store database


Please Note:
It’s very important to backup all themes and extensions in Magento before installation, especially when you are working on a live server. We strongly recommend you to do not skip this step.

Manual Extension Installation via FTP/SSH:

After purchasing an extension, you can download the module as .zip package in your Customer Account.
After downloading the .zip package, please follow these steps for installation:

  1. Log into your hosting space via a FTP client (e. g. FileZilla, WinSCP, cuteFtp)
  2. Create Folder: /app/code/Jajuma/[ExtensionName]*
  3. Unzip extension package and upload files into: /app/code/Jajuma/[ExtensionName]*
  4. Enter and run the following commands at the command line:
    php bin/magento setup:upgrade
    php bin/magento setup:static-content:deploy

* Note: [ExtensionName] can be found in registration.php file: Jajuma_[ExtensionName]

 

Extension Installation via Composer / Magento Marketplace:

For installation via composer, please get the extension

  • from Github and install as any other extension from Github or
  • from Magento Marketplace and follow this Installation Guide and
    make sure to use the correct key for Marketplace repo (the key that belongs to the account that purchased the module).
    In case of issue with installing via composer, please double-check to use the correct key for Marketplace repo.
    Your key should be in your auth.json file.


Links for composer installation to Github/Marketplace can be found on top of this page in technical info section - Click Here

Error Could not find a matching version of package jajuma/[module-name]. Check the package spelling, your version constraint and that the package

With this error message, most likely the key used for the Marketplace repo is wrong/invalid, i. e. not the key that belongs to the account that purchased the module. Please double-check to use the correct key for the Marketplace repo.

For installing extensions from Magento Marketplace, please follow this guide and make sure to use the correct key for the Marketplace repo:
Installation Guide

Please feel free to get in touch with our support in case you have any further questions or concerns or check with Marketplace support in case the installation issue can not be resolved.

Do you offer free technical support?

After purchasing a (non-free) extension we provide 12 month support via support ticket for free.

Do you offer customization service for your extensions?

Yes, please get in touch with our customer support so we can clarify your requirement and provide a quote.

Where can I download my extension?

You can download your extension from your customer account as soon as the payment has been processed.

Do you offer a free trial period?

Unfortunately, we can not offer a free trial period.

However, we do have demo site for all our extensions. Feel free to test all the features and see how the extensions work.

In case of any questions or concerns regarding compatibility or how some extension works our customer support is also always happy to help.

Do you offer refunds?

All our extensions are non-tangible downloadable goods. Hence we can unfortunately not issue refunds.

Refunds will NEVER be issued for services provided such as installation support, customization and software development work.

Changelog

Version: 1.0.0

  • Initial Release

Version: 1.0.1

  • Updated: M2.4.6 Compatibility & Coding Standard Updates

Version: 1.0.2

  • Improved: Compatibility with 3rd party layered navigation's

More Extensions

Maybe also interesting for you?
More valuable Extensions and Add-Ons for your Magento Store

Our Customers Are Excited!