Implementing Cloud Design Patterns for AWS

Summary

In this chapter, we covered a few techniques and patterns for relational databases. In the database replication pattern, we created a MySQL master and client system on EC2 instances to demonstrate one-way replication of data. In the read replica pattern, we further optimized our database access by building on the database replication pattern, by allowing access to the replicated slave instance. We optimized the queries by installing a proxy on the master that decided whether the statements should be executed on the master with write access, or on the slave with read-only access. We then moved on to the In-memory cache pattern, in which we coupled a fast key-value store with our database for read-heavy applications and demonstrated its ...