© Jonathan Bartlett 2019
Jonathan BartlettBuilding Scalable PHP Web Applications Using the Cloudhttps://doi.org/10.1007/978-1-4842-5212-3_7

7. Database Replication

Jonathan Bartlett
(1)
Tulsa, OK, USA
 
Some things simply cannot be cached. Ad hoc reports, up-to-the-second changes, and sites where access patterns are spread across a large number of unrelated pages are all difficult to optimize using caching. For workloads like this, you can deploy a bigger database server, but eventually even those run into limits.
Therefore, many application architectures include database replication, where there is more than one database server serving out requests.

7.1 Types of Database Replication

There are many types of database replication depending on your needs. ...

Get Building Scalable PHP Web Applications Using the Cloud: A Simple Guide to Programming and Administering Cloud-Based Applications now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.