Rancher is not special in this case. You should just follow generaly sql db best practices.
A single mysql container would not be HA and would be a fairly dangerous way to run. You’d be safer running mysql somewhere with a true HA setup. Many of our users utilize AWS RDS for their DB.