Geek asks and answers

Using ElastiCache with RDS to Improve Read / Write Performance

I am using RDS on amazon with the MySQL interface. My application runs on EC2 nodes and reads / updates the database, but the amount of read and write is too large and reduces performance. In most cases, the number of connections exceeds the limit. I was considering using Elasticache to improve performance, but I did not find resources on the Internet how to tune the database to use it effectively. Is this the best way to improve read / write performance? Any suggestions?

+5
source share
3 answers

You can't just turn memcache on. You need to write code that interacts with memcache, so the database query results will be cached in memcache. Take a look at this user guide - I think this will give you an idea of ​​how memcache is used:

http://www.memcachier.com/documentation/memcache-user-guide/

+6
source

, . , . , - , , , - (, , ). RDS, , , , EC2, , - www.xeround.com www.enterprisedb.com.

0

You can use elastic as a second level cache for your rds db. If you use java, you can use the hibernate-memcached library. But you still need to configure how and what to cache in the second-level cache, depending on your data.

Alternatively, you could use read replica in RDS less to get split read traffic.

(What type of instance are you using, have you seen that they have different I / O capabilities?)

0
source

More articles:


All Articles