MySQL gave me so many nightmares in my life. I had to achieve 100 TPS with 3 TB opensource database. Trust me, many of us doesn't know what needs to know for performance tunning. It will take me highest 3 days to complete your task but it took me 10 years to learn them.
In short future, you will also need a replication procedure for data safety. I think with my set of skill I will be able to provide you proper solution.