We should do a more thorough analysis of the current situation and some testing before recommending you a strategy. I suggest you consider a small consulting engagement for this. https://learn.percona.com/contact-me in case you are interested.
1 Like