Database Replication Basics

Problem

Your primary database is overwhelmed with analytical queries from the BI tool, slowing down the main customer application. The infrastructure team decides to set up a secondary database just for reads. Write a query that outputs a column explanation with the value: "Read replicas scale read heavy workloads by continuously copying data from a primary database."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution