Resource guide
Learn more about YugabyteDB with blogs, videos, and more
Find resources for getting started, migrating existing databases, using your database, and architecting for scalability, reliability, and security.
Introducing YugabyteDB
Blogs
Videos
Migrate
Database operations
- Blog: Seven Multi-Region Deployment Best Practices
- Learn how to reduce latencies and improve performance in a multi-region deployment.
- Documentation: Deploy YugabyteDB
- Deploy to the public cloud, a private data center, or Kubernetes.
- Blog: Rapid Data Recovery
- Learn how YugabyteDB performs swift data recovery.
- Documentation: Backup and restore
- Backup, restore, and point-in-time-recovery.
- Documentation: Upgrade YugabyteDB
- Upgrade a deployment.
Develop
- Documentation: Hello world
- Use your favorite programming language to build an application that uses YSQL or YCQL APIs.
- Video: Distributed PostgreSQL Essentials for Developers: Hands-on Course
- Documentation: Build and learn the essential capabilities of YugabyteDB
- Build a scalable and fault-tolerant movie recommendation service.
- Documentation: Best practices
- Tips and tricks to build applications for high performance and availability.
- Documentation: Drivers and ORMs
- Connect applications with your database.
Connections
- Blog: Database Connection Management: Exploring Pools and Performance
- Database connection management with YugabyteDB.
- Blog: Understanding Client Connections and How Connection Pooling Works in YugabyteDB YSQL
- Understand client connections in YugabyteDB, and how connection pooling helps.
Troubleshooting
- Article: Explain Analyze Dist
- YugabyteDB distributed execution plans.
- Documentation: Query Tuning How To
- Query tuning in YugabyteDB.
- Blog: YugabyteDB Memory Tuning for YSQL
- Best practices for tuning memory with a YSQL workload.
Indexes
- Blog: Distributed Indexes for Optimal Query Performance
- Design indexes to get the best query performance from a distributed database.
- Blog: Boost Queries with Index Only Scan
- Learn how Index Only Scan can boost secondary index queries in a distributed SQL database.
- Article: Covering Indexes
- Optimize index creation by covering the right columns.
- Documentation: Secondary Indexes in YugabyteDB
- Explore secondary indexes in YugabyteDB using YSQL.
- Article: Range indexes for LIKE queries in YugabyteDB
- Techniques for performing LIKE queries in YugabyteDB.
Pagination
- Blog: Optimize Pagination in a Distributed Database
- Design queries to return data with pagination while maintaining global ordering.
- Article: Efficient Pagination in YugabyteDB
- Learn about the best indexing pattern for PostgreSQL and YugabyteDB.
- Article: Pagination with an OFFSET is better without OFFSET
- Learn why you shouldn't use OFFSET for pagination.
Hotspots
- Blog: How to Avoid Hotspots
- Article: Scalable Range Indexes To Avoid Hotspots on Indexes (For range queries and Top-n queries)
- Learn how to avoid hotspots on range-based indexes in distributed databases.
Geo-Distribution
- Blog: Engineering Around the Physics of Latency
- Learn about the geo-distributed deployment topologies offered by YugabyteDB.
- Article: Local Reads in Geo-Distributed YugabyteDB
- Perform local reads in geo-distributed YugabyteDB databases.
- Blog: Multi-Region Best Practices
- Techniques to reduce latencies and improve performance in a multi-region deployment.