Book Image

Implementing Cloud Design Patterns for AWS

Book Image

Implementing Cloud Design Patterns for AWS

Overview of this book

Table of Contents (18 chapters)
Implementing Cloud Design Patterns for AWS
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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 usage. Lastly, we moved into the sharding write pattern, in which we touched in theory on how to utilize cluster software such as MySQL Fabric to create extremely versatile and optimized clusters of databases that can handle many issues.

In the next...