In YugabyteDB, you can manage the number of shards (tablets) using flags like ysql_num_tablets for total control or ysql_num_shards_per_tserver for control per tserver. Dynamic auto-splitting is also supported for automatic adjustments as data grows.
YugabyteDB supports two methods of sharding data: by hash and by range. Discover which strategy is correct to use in which situation.
When considering replication options between YugabyteDB clusters, you have two options—xCluster async replication or setting up Kafka. Learn the when and how and why to both choices.
Discover how the LIKE operator enables pattern matching with wildcards and indexing for specific access patterns, focusing on scenarios where the wildcard is at the beginning or end of the pattern. The examples and demonstrations are performed on YugabyteDB, a PostgreSQL-compatible database with variations in storage implementation.
In YugabyteDB, every table and index is sharded across the cluster, with partitioning at the query level (YSQL) and sharding at the storage level (DocDB), enabling unique configuration concepts like row-level geo-partitioning.
DBAs often need to generate SQL statements using SQL queries and then execute them. PostgreSQL has many features that can help. Let’s walk through an example using YugabyteDB, which is Postgres-compatible and provides the same SQL language and catalog views.
Setting the number of shards/tablets in your YugabyteDB cluster is dependent on your table size and activity, and while it is hard to gauge the exact number, here are some high-level suggestions.
YugabyteDB’s compatibility with Postgres and Cassandra allows seamless integration with popular third-party tools and integrations, such as visualization tools like pgAdmin, DBeaver, and ArcType, as well as Kafka, Spark, Flyway, and drivers and ORMS, due to the decision to reuse the Postgres query layer (YSQL) and recreate Cassandra using C++ (YCQL).
YugabyteDB’s implementation of DocDB, based on RocksDB, has made significant improvements to ensure node density and scalability, allowing hundreds of tablets per tserver without limiting the amount of data per node.
We are excited to announce that YugabyteDB 2.1.2 is GA! You can read the official release notes here. This release shipped with over 30 new enhancements and fixes.
Before we dive in, we wanted to let you know that the Yugabyte team has been working from home in order to do our part with social distancing and to help with containment efforts. We have also transitioned to online meetings with our customers,
…