While you can do a lot with the Automation API, having to implement this full flow is IMO a bit beyond what Pulumi is intended for. If you are on MySQL, I would use Pulumi to roll out Vitess.io and let the DB people use Vitess to migrate data between servers.