We are looking for a tool to simplify the process of creating auto-refreshing Materialized views to speed up the loading of data for user-facing dashboards that require complex queries involving multi-table joins and aggregations on a MySQL DB. Can RisingWave help in this scenario?
Arunangshu Biswas
Asked on Sep 08, 2023
Yes, RisingWave can simplify the process of creating auto-refreshing Materialized views for user-facing dashboards that require fast loading of data obtained through complex queries on MySQL DB. RisingWave can handle batch queries with high concurrency by incrementally refreshing Materialized views. The pipeline involves connecting MySQL DB to RisingWave's Materialized View through CDC (Change Data Capture) mechanisms like Debezium and Kafka or direct CDC to RisingWave. The Materialized views can be queried by backend servers using Postgres client libraries, and the results are automatically refreshed by RisingWave, allowing the backend server to forward the updated data to the dashboard.