From the course: Designing Highly Scalable and Highly Available SQL Databases
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
High-availability architectures
From the course: Designing Highly Scalable and Highly Available SQL Databases
High-availability architectures
- [Instructor] High-availability architectures can be challenging, but it's gotten easier than it has been in the past. Now, typically when we talk about high availability, what we're really talking about is having multiple servers and having data replicated across multiple servers. Now, today if you're using cloud services to host your database, and I'm thinking particularly in managed services like Google Cloud, SQL, or AWS's RDS service, in those cases, you can start up a database, say a Postgres database or a MySQL database, and literally just check a box on the startup form in the console to indicate you want a high-availability database. And once you check that box, then the managed service takes care of all of the data replication and spinning up the servers and making sure the data is replicated so that if your primary database fails, you can immediately switch over to your fail-safe or your secondary. And 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.