MySQL configure as ACI vs Redis
There are too many differences to enumerate.  The choice between them is heavily based on your application, which you have not described.

That setting affects writes, not reads.

If you are not exceeding 100 queries per second on slow spinning drives, MySQL will do just fine.  Or, if it does not, then we should look at your indexes and queries.