Which features matter in an RDBMS? Given a choice between a single-node performance, availability and manageability, which two would you choose? Assume you have far more database servers than people to manage them. Availability and manageability trump single-node performance because they enable it. Read capacity is increased by adding more replicas. Write capacity is increased by sharding the data across several servers. But you don't want to add more servers unless they are easy to manage, likely to keep running and affordable.
MySQL embodies this philosophy. Clusters of MySQL database servers are easy to deploy and manage. They scale to support extreme transaction and query processing workloads. MySQL doesn't have the features that optimize single-instance performance. That is good. Those features are complex and expensive. Use more servers rather than bigger servers.
Posts
