We schedule a downtime window during upgrade, but typically see no frontend impact to the core service, SSO for end users. We snapshot the DB for rollback if needed as the migrations are not reversible.
Our actual DB size is pretty small so these are very non-intensive tasks.