From the course: Designing Highly Scalable and Highly Available SQL Databases
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Challenge: Services and APIs for a scable user interface
From the course: Designing Highly Scalable and Highly Available SQL Databases
Challenge: Services and APIs for a scable user interface
(lively music) - [Instructor] In this challenge, we're going to look at how we actually get data into our database. Now, the health monitoring app will be sending geolocation data at regular intervals. Let's say every minute. Now, some things we want to consider are the size of the payload. In this case, it'll be about one to two kilobytes. And there may be tens of thousands of app instances actually running and sending data at any point in time. Also, keep in mind that data may arrive out of order. So now that challenge is to describe an architecture for an ingestion system that will scale and get this data into a relational database.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
Human-scale and machine-scale data6m 13s
-
Different data ingestion strategies5m 6s
-
Designing scalable user interfaces6m 45s
-
Message queues to buffer ingested data4m 10s
-
Data modeling for scale: Event sourcing5m 17s
-
Distributing workload: Command Query Response Separation (CQSR)4m 26s
-
Challenge: Services and APIs for a scable user interface46s
-
Solution: Services and APIs for a scable user interface1m 10s
-
-
-