Last post Dec 25, 2019 06:35 AM by mywatermelon
Dec 23, 2019 08:49 AM|mywatermelon|LINK
My project needs to use an in-memory cache database(such as Redis). However, although Microsoft has developed a windows version Redis. It seems it has not updated for a long time that its version is lower than the official one very much.
What's more, the windows system of my server computer is windows server 2012R that can not install a Linux system while windows 10 can. And also, I can't change the windows version to the server computer.
I have heard that the SQL server has developed some features like Redis. However, it needs cost much.
Is there any other choice for me to use a free in-memory cache database in windows server system? Thank you.
Dec 23, 2019 09:40 AM|maherjendoubi|LINK
Dec 23, 2019 03:55 PM|bruce (sqlwork.com)|LINK
Redis is a distributed cache database. Normally you'd install it on its own dedicated servers (not the web site). These new servers could be linux. What led you to believe that Redis was your solution. What features didi you need? If you are a single server
solution (as your post suggested), any simple caching may work. You could also look at using SQLite as a in-memory database.
Dec 24, 2019 02:22 AM|mywatermelon|LINK
Now I will install it on the same server computer but I think the cache database will move to another server computer while the business grows.
I don't want to use something instead of temporary. It is so troublesome to rewrite all when moving the cache database to another server computer.
I use the cache database for the website needs read&write something frequently.
I have heard about SQLite and I always use it as an offline database in the WPF program. However, SQLite lack of multi-user capabilities. It seems SQLite is not a good choice.
Dec 24, 2019 02:27 AM|mywatermelon|LINK
The project will move the cache database to another server computer, I am not sure about whether I should create another ASP.NET core project just for MemoryCache on another server computer.
What's more, there is one more stupid question. I am not sure whether the MemoryCache can completely replace the Redis. If it can, why so many people still using Redis(Does Java/Nodejs/PHP not supports MemoryCache while only Asp.net core supports it?).
Dec 24, 2019 06:59 AM|Rena Ni|LINK
However, although Microsoft has developed a windows version Redis. It seems it has not updated for a long time that its version is lower than the official one very much.
Redis for windows is updated two month ago.I think it is the better free in-memory cache database.You could install it by the following link:
Dec 24, 2019 08:49 AM|mywatermelon|LINK
In the README.md of official Microsoft Windows Redis repository(https://github.com/microsoftarchive/redis/commit/54e8c24657f4bab22f24356bd097706193727f4f)
said that it is no longer being actively maintained.
They suggest using Memurai(https://www.memurai.com/) while I don't know if it is a good choice.
Dec 24, 2019 04:09 PM|bruce (sqlwork.com)|LINK
on premise caching databases solutions are under pressure from cloud solutions. No cloud vender (even Azure) is going to work on a Windows version. Redis is probably the best solution. You could install a linux vm on your windows 2008 r2 server. if you could
possibly upgrade to a later version windows machine (2008 r2 end of life is just a couple weeks away), Redis in docker would be a good choice.
Dec 25, 2019 06:35 AM|mywatermelon|LINK
Oh my god, I can hardly believe it. I always consider that Azure is using a windows system for it belongs to Microsoft and use windows for free.
Well, I think using a Linux VM as you said is a good choice despite I have to learn how to get/set data from a VM. Aha.
Thank you so much.