Buddy, what are you asking of the Council on the toaster, it was good but not enough.
Then you will receive vague answers to your question.
It is best to know the good and useful books on your topic. To read and then you can ask a specific question if something is not clear.
1. look here https://ruhighload.com/
2. read the following books.
Ensuring high availability of systems based on MySQL Charles bell
MySQL performance Optimization Baron Schwartz
The maximum MySQL Baron Schwartz
Highly-loaded applications Martin Chapman
I think you will find more good answers and specific steps that need to be done.