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.
This blog explores YugabyteDB’s ability to propagate client requests to surviving nodes when a node becomes unavailable. The behavior depends on factors such as client connection method, driver used, and connection pooling.
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.
In this post, we shine a spotlight on Admiral’s Co-Founder, James Hartig. Read on to learn more about James’ passion for databases and the first time he heard about YugabyteDB. He also discusses his experience using YugabyteDB Managed (formerly Yugabyte Cloud) to serve 10,000 queries per second across three continents.
Welcome back to our tips and tricks blog series! I have the distinct pleasure of recapping distributed SQL questions from around the Internet for the month of December.
This ongoing series would not be possible without Dorian Hoxha, Franck Pachot, and Frits Hoogland. We also thank our incredible user community for their work with the technology.
Do you have any questions?
…
Welcome back to our tips and tricks blog series! With October officially a wrap, I have the pleasure of recapping some distributed SQL questions from around the Internet. There was no Tips and Tricks edition for September as the Yugabyte team was focused on our 2021 Distributed SQL Summit. If you did not have a chance to check it out, you can view the sessions on-demand.
As always,
…
The Yugabyte community is always active and its members are constantly having interesting conversations and making valuable contributions. We spotlight members of the community to recognize their contributions to making the Yugabyte community a great place.
Warren Wilfred L. Cruz, Data Solutions Architect @ EXIST Software Labs, Inc.
Twitter: https://twitter.com/wawicruz and LinkedIn: https://www.linkedin.com/in/warrencruzpostgrex
If you’re on the Yugabyte community Slack,
…
Welcome back to our bi-weekly tips and tricks blog where I have the pleasure of recapping some distributed SQL questions from around the Internet. I had a month long hiatus this summer, so we are making it up by adding an extra entry into this week’s edition. As always, this blog series would not be possible without all of the behind the scenes work done by Yugabeings such as Dorian Hoxha and Frits Hoogland.
…