MySQL remote cache

Question

We have a website whose database is on a separate machine. Both the application server and the database server are relatively underused, but the network link between them is the bottleneck. The MySQL server itself performs plenty of caching, but queries must still cross the network and back. If the site was slashdotted, that connection is where the limit would be hit.

Is there any (safe) way of using the MySQL client on the application server to cache data, saving on round trips across the network?

(for the purposes of this question it doesn't matter what software the web server is running. yes it has caching mechanisms of its own, but they're separate from the database cache)

EEAA · Answer 1 · 2011-10-05T15:19:49.720

2

This is where something like Memcached comes into play. It's not overly complex to get running, but it's not going to be a drop-in solution for you either.

To explicitly answer your question, no I know of no way to get the mysql client libraries to cache query results.

edited Oct 05 '11 at 15:19

answered Oct 05 '11 at 12:53

EEAA

109,363
18
175
245

Like I said, there are always other caching mechanisms further up the application. I was specifically asking if MySQL could be cached in the client. – Marcus Downing Oct 05 '11 at 14:03
@MarcusDowning - I edited my answer to explicitly answer your question. – EEAA Oct 05 '11 at 15:20

score 2 · Accepted Answer · answered Jun 07 '12 at 00:25

2

No. There is no standalone MySQL cache (yet).

Since your web server is underused, you can install a database on the web server run database replication.

You will need to modify your application to do reads and writes from different server or you could try alpha release of mysql proxy

answered Jun 07 '12 at 00:25

Rianto Wahyudi

493
3
11

Interesting possibility. The need has passed since I asked the question a year ago, but I'll remember it for the future. – Marcus Downing Jun 07 '12 at 08:11

MySQL remote cache

2 Answers2