Analytics and Real-time Database Workloads: Combining OLTP and OLAP Systems

Analytics and Real-time Database Workloads: Combining OLTP and OLAP Systems

Watch a 25-minute conference talk from OSA Con 2023 exploring the challenges and solutions of running OLAP (Analytics) and OLTP (Real-time) workloads together in database systems. Learn about the fundamental differences between these workload types, the resource contention issues that arise when running them concurrently, and various strategies to mitigate performance impacts. Dive into ScyllaDB's innovative approach using Workload Prioritization and Workload Characterization features, built on seastar's isolation mechanisms, to enable harmonious coexistence of analytics and real-time processing without interference. Gain valuable insights into optimizing distributed system performance when dealing with mixed workload scenarios.