Start Now

Download our new eBook, Distributed SQL Databases for Dummies, to discover more about distributed SQL and YugabyteDB!

Download for Free

Data Sharding

Q&A: Partitioning vs Sharding, Scaling Behavior, and Visualization Tools for YugabyteDB

Q&A: Partitioning vs Sharding, Scaling Behavior, and Visualization Tools for YugabyteDB

Welcome to the December 2022 edition of the YugabyteDB Tips and Tricks series, where we recap distributed SQL database questions from around the Internet! This month we will focus on the differences between table partitioning and sharding in a distributed SQL deployment, whether or not the scaling limitations in RocksDB has an impact on YugabyteDB, and tools for visualizing the data stored in the Yugabyte database.

Read more

Tablet Splitting, High Availability Behavior, & Sharding vs Partitioning with YugabyteDB

Tablet Splitting, High Availability Behavior, & Sharding vs Partitioning with YugabyteDB

Welcome to the September 2022 edition of the YugabyteDB Tips and Tricks series, where we recap distributed SQL database questions from around the Internet! This month we will focus on recommended values for tablet splitting, behavior around high availability, client behavior when a node goes down, and sharding versus partitioning of a table.

Read more

Distributed SQL: Sharding and Partitioning in YugabyteDB

Distributed SQL: Sharding and Partitioning in YugabyteDB

A distributed SQL database provides a service where you can query the global database without knowing where the rows are. You connect to any node, without having to know the cluster topology. You query your tables, and the database will determine the best access to your data, whether it’s close to your client or geographically distant.

The organization of data, whether co-located or partitioned, is the most important consideration for high performance,

Read more

Distributed SQL Tips and Tricks – Feb 21, 2020

Distributed SQL Tips and Tricks – Feb 21, 2020

Welcome to this week’s tips and tricks blog where we recap some distributed SQL questions from around the Internet. We’ll also review upcoming events, new documentation, and blogs that have been published since the last post. Got questions? Make sure to ask them on our YugabyteDB Slack channel, Forum, GitHub, or Stackoverflow. Ok, let’s dive right in:

When should I use JSON vs JSONB data types?

Read more

Four Data Sharding Strategies We Analyzed in Building a Distributed SQL Database

Four Data Sharding Strategies We Analyzed in Building a Distributed SQL Database

A distributed SQL database needs to automatically partition the data in a table and distribute it across nodes. This is known as data sharding and it can be achieved through different strategies, each with its own tradeoffs. In this post, we will examine various data sharding strategies for a distributed SQL database, analyze the tradeoffs, explain the rationale for which of these strategies YugabyteDB supports and what we picked as the default sharding strategy.

Read more

How Data Sharding Works in a Distributed SQL Database

How Data Sharding Works in a Distributed SQL Database

Editor’s note: This post was updated August 28, 2020 to include new sharding features available starting in YugabyteDB 2.2

Enterprises of all sizes are embracing rapid modernization of user-facing applications as part of their broader digital transformation strategy. The relational database (RDBMS) infrastructure that such applications rely on suddenly needs to support much larger data sizes and transaction volumes. However, a monolithic RDBMS tends to quickly get overloaded in such scenarios.

Read more

Overcoming MongoDB Sharding and Replication Limitations with YugabyteDB

Overcoming MongoDB Sharding and Replication Limitations with YugabyteDB

Although MongoDB has made significant improvements in its sharding and replication architecture since its origins as an Available and Partition-tolerant (AP) database, it still has limitations that make it unsuitable for highly scalable and latency-sensitive applications. In this blog post, the authors explore the reasons why some users have chosen to switch from MongoDB to YugabyteDB, citing distributed ACID transactions and better scalability as key factors.

Read more

Learn More to Accelerate Your Retail Business

Ready to dive deeper into distributed SQL, YugabyteDB, and Yugabyte Cloud?
Learn at Yugabyte University
Learn More
Browse Yugabyte Docs
Read More
Join the Yugabyte Community
Join Now