data-engineer-pro video for at ZenithMart Corp , both the customer and order databases are frequently under heavy usage, making it challenging to run analytical
At ZenithMart Corp , both the customer and order databases are frequently under heavy usage, making it challenging to run analytical workloads without affecting operational performance. These databases run in a MySQL cluster , and nightly backups are created using mysqldump . You need to perform analytics with minimal disruption to your production systems. What approach should you take?