CODEWITHSUNDEEP
phpmysqldatabasecaching
phirschybar
phirschybar

Reputation: 8579

Is Caching Via Database Inefficient For Production Sites?

I need to move a bunch of background processes for a production website onto another server, to help spread out the CPU and RAM usage. One obstacle I have is that a few of these background processes generate (and store in a file-based cache) HTML views and other data which the site front-end relies upon. So, I will need to switch to a more centralized caching system so that my servers can share the cached data.

I am considering just using the (MySQL) database for this however I am concerned that this will dramatically increase the DB hits. Is this efficient? What are some alternatives?

Upvotes: 1

Views: 42

Answers (1)

woot
woot

Reputation: 7616

I would move this to a distributed task queue implementation, like gearman for async tasks, and memcached for your caching and other transient data needs.

Upvotes: 1

Related Questions