A 25 page whitepaper published by Oracle describing a set of best practices for MySQL deployments to accommodate scenarios from small to very large acccording to the following criteria:
- concurrent read users
- concurrent write users
- database sizes for 4 types of use cases (sessions, eCommerce, analytics, content management)
Downloading the paper requires registration, but it’s worth reading and thinking about the suggested architectures (even if in a few spots it pushes for the commercials tools offered by Oracle).
Original title and link: MySQL Reference Architectures for Massively Scalable Web Infrastructure ( ©myNoSQL)