Did the exact same thing for a client who's ops we managed on AWS. I was pretty against ditching RDS and a load balanced setup for hetzners load balancer and 3 instances (2 web, 1 db) but honestly, it's been pretty smooth sailing. The sites faster, and costs dropped massively, saving the client approx €900/mo for a better service.