A company is running a batch analysis every hour on their main transactional DB, running on an RDS MySQL instance, to populate their central Data Warehouse running on Redshift. During the execution of the batch, their transactional applications are very slow. When the batch completes they need to update the top management dashboard with the new data. The dashboard is produced by another system running on-premises that is currently started when a manually-sent email notifies that an update is required. The on-premises system cannot be modified because is managed by another team.
How would you optimize this scenario to solve performance issues and automate the process as much as possible?
cloudinvader
Highly Voted 3 years, 6 months agokaush
3 years, 6 months agochigo17
3 years, 6 months agochigo17
3 years, 6 months agoamministrazione
Most Recent 8 months, 3 weeks agoSkyZeroZx
1 year, 10 months agoSkyZeroZx
1 year, 11 months agohollie
2 years, 4 months agocldy
3 years, 4 months ago01037
3 years, 6 months agocldy
3 years, 6 months agoGorha
3 years, 7 months agoamog
3 years, 7 months agosorok7
3 years, 7 months agoDalianYifang
3 years, 7 months agoDalianYifang
3 years, 7 months agotan9
3 years, 7 months agouser0001
2 years, 12 months ago