You'd need to create a new node pool and do a blue/green type of upgrade. This isn't something an Infrastructure-as-code solution will do for you

yes but for database, i think blue/green upgrade won't work since it will cause data inconsistency.