Which is better for storage and cache?

[qnkov 4]

http://prntscr.com/msqjgm

How should i use those options? I was thinking about"

- Mysql datebase for storage and Memached for cache.

Like this:

http://prntscr.com/msqlmz

Edited March 3, 2019 by qnkov

[SeeBeyond 14]

Each option provides it's own negatives and positives. MySQL, as the text states, provides better speeds in conjunction with a caching method enabled. Which I do recommend enabling. Do note that whichever method you choose enable needs to be installed on your server. You plan to use Memcached so ensure it is installed. Because you appear to be using a shared host ask your hosting provider if it is enabled. If it is, then use it and also enable MySQL storage.

[titcrunch 182]

for data database is the best, for the cache that depends of your server and your config of cache

[Gerom119 2]

1. Check if MySQL and Memcached are installed on your server.

2. Provide the setting for Mamcached.

 

Edited April 1, 2019 by Gerom119

[SuperioR 0]

On 3/4/2019 at 7:23 AM, titcrunch said:

for data database is the best, for the cache that depends of your server and your config of cache

True :) 

[qnkov 4]

Thanks to all. I've figure it out for myself.

[flash 0]

Memached

[MrFantastic 0]

Redis and Redis or Mysql and Memcached.

Redis is best in my opinion as it takes a lot of the stress off mysql.  Using mysql and memcached works too.  

You might also want to use elastic search.  

Using Redis / Elastic search - I'm hitting Mysql 10000 Queries per second average.

Edited April 28, 2019 by MrFantastic