Caching Mysql database for better performance

I'm using Amazon cloud and I've performance issue since the HDD is not located on my machine. My database is small (~500MB) and I can afford to keep it all in my RAM. I do not want to keep queries in my RAM, i need all the tables the开发者_Go百科re.

How can i do it?

Thanks, Koby

P.S. I'm using ubuntu server...

You could add a caching layer. Memcached might be a good choice for you:

http://memcached.org/

You can load indexes into cache; if you have small ISAM tables that are frequently queried, MySQL will probably load these into cache as well. Here is a good Performance Wiki article on MySQL tuning.