MySQL 8 Administrator???s Guide

Business type and flexibility

This is the first point that needs to kept in mind while we perform the scaling. Business type or business behavior is the core part; if the business is an e-commerce, we already know e-commerce businesses have a number of functionalities and very critical data about clients, such as product details, monopoly of the business for offers and discounts. The main thing is customer details and payment information such as credit card details, debit card details, and customer feedback.

In this case, while we are doing scaling in MySQL 8, all parameters need to kept in mind, such as database back up, security, roles/privileges of the database and backward compatibility of the scaling. While doing scaling by clustering ...