Product filter, how best to do it (large catalog)?

Question

Redis

There is a fairly large catalog of 30,000 products.
The request can be with logical operators AND, OR, NOT, that is, a complex filter.
You need to make a product filter. It seems that on MySQL it will all work slowly.
Project on PHP 7.1 / Laravel 5.4 / MySQL / Redis
Has anyone tried to make filters on nosql for example on Redis or something else?
Please describe an example workflow.

Answer 1

https://habrahabr.ru/post/261137/

Answer 2

30k small store
Do it on sql
When there are brakes - then there will be something to think about

Answer 3

sphinx? if the products are updated once a day.