For Magento Commerce Cloud Pro plan users, Magento recommends enabling slave connections for the MySQL database and Redis by default, to spread out the load across different nodes.
See the MySQL high-load bottleneck in Magento Commerce Cloud article for details on how to enable slave connection and related questions.