What's your data ETL methodology?
If you are replacing all the data, then build new tables, test them, then swap.
If you have a Master-Master replication setup, then break the connection, do the ETL, test, then failover and reestablish the link.
If something else, please elaborate.


More details from me after more from you.