From the course: Advanced SQL for Data Scientists
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Read replicas
- [Instructor] Now in some cases, data scientists work with systems that may also be used by other people for different reasons. For example, you might want to use an online transaction processing system as a source of data, and you want to grab data continually. Well, you don't want to put too much stress on the OLTP system, which is being used by interactive users. One way to deal with a situation like that is for data scientists to work with database administrators to create something called a read replica. Now, when we think about database servers, it makes sense oftentimes we use just a single server. So for example, if we're in the cloud, we can decide how much memory we need, how much storage we need, and pick a virtual machine, or use a hosted database service and size the instance that we're interested in. And let's think of that as our primary. Now in that scenario, all the reads and all the writes go to the…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.