Jump to content
You're invited! Join our 4.6 Live Event on ZOOM 6/24 ×

Community

Questions about Memcache depreciation


Recommended Posts

I understand that Memcache will be depreciated in IPS 4.6. But what methods of caching are going to be available instead?  From what I understand, only redis caching is available now. But you can't use redis with a MySQL database. 

I have Cloudflare... will that be enough? 

Advice?  

 

Link to comment
Share on other sites

Posted (edited)
13 hours ago, jwdenzel said:

From what I understand, only redis caching is available now. But you can't use redis with a MySQL database. 

Give Redis a try, works fine and requires little maintenance. Installation is easy on all major Linux distros.
Setup is easy, too.

What do you mean by it won't work with MySQL. Redis is a separate caching/key storage instance, which is being used by your Invision Community software. Instead of saving caching information to MySQL or to a Memcache daemon it is being sent to your Redis server instance.
This will take load off the MySQL Server...

Edited by Thomas P
Link to comment
Share on other sites

On 5/11/2021 at 2:43 AM, Thomas P said:

What do you mean by it won't work with MySQL. Redis is a separate caching/key storage instance, which is being used by your Invision Community software. Instead of saving caching information to MySQL or to a Memcache daemon it is being sent to your Redis server instance.
This will take load off the MySQL Server...

Thanks for this info. I misinterpreted the "Advanced Configurations / Data Caching" page and thought that I could not use Redis with MySQL. But I see that's incorrect. 

I have a dedicated server running MySQL for my website. It's got some good horsepower behind it. Does it makes sense to install Redis on that mysql server? Would I gain any advantage from that even though they are on the same box?

Thanks!

Link to comment
Share on other sites

  • 4 weeks later...
On 5/17/2021 at 4:58 PM, jwdenzel said:

I have a dedicated server running MySQL for my website. It's got some good horsepower behind it. Does it makes sense to install Redis on that mysql server? Would I gain any advantage from that even though they are on the same box?

@Thomas P: Apologies for the tag, but you replied earlier. Any thoughts on my question quoted here? I have 2 physical servers: an Apache server and a separate MySQL database server. Based on that configuration, where should I install redis for caching? Should I place it onto my Apache server so it offloads the MySQL machine?  (Interestingly, the MySQL server is totally dedicated as a db server. I think the Apache server has more load on it)

Thanks in advance. 

Link to comment
Share on other sites

@jwdenzel I don't have a distributed setup atm, we once had webserver and mysql separately where memcached lived on the webserver.
Currently we use Webserver, MySQL (i.e. MariaDB) and Redis on the same (powerful) machine, which works really great.
If your MySQL has a lot to handle offloading the queries to the webserver using Redis on the Apache host would be effective.
But it depends on your setup and your load during peak times. So my recommendation is: Try both variants and do some measurement on the box to monitor CPU, RAM, Swap and response times etc. when Redis is installed and active on your Apache host for a while (e.g. one week) and on a second try when it is active on your MySQL host in the following week.  
Btw. it is common as well to use Redis on the MySQL host as a front-end database between an application and the MySQL DB.
If you want to offload even more and you don't use it yet: Think about using elasticsearch, it removes a lot of data (i.e. search index) from the MySQL DB and search queries run a lot faster and more accurate.

Link to comment
Share on other sites

I upgraded to 4.6 and disabled all server-side caching. Result: the website is incredibly faster. Like, not even kidding you, 50x faster. Memcache must not have been set up wrong. The site is blazing fast now. (I use Cloudflare for CDN caching, but even with that disabled, it's fast)

So will will forego using redis for right now, but I'll implement it in the future if necessary. 

Thanks for all the advice. 

Edited by jwdenzel
Link to comment
Share on other sites

 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...

Important Information

We use technologies, such as cookies, to customise content and advertising, to provide social media features and to analyse traffic to the site. We also share information about your use of our site with our trusted social media, advertising and analytics partners. See more about cookies and our Privacy Policy