How To Achieve Region-Level Fault Tolerance While Using Row-Level Geo-Partitioning?
This edition of the Distributed SQL Tips and Tricks blog looks at how to achieve region-level fault tolerance with row-level geo-partitioning.
June 8, 2023
YugabyteDB
June 2, 2023
What Is the Difference Between ‘Table Partitioning’ and ‘Sharding’ In a Distributed SQL Deployment?
In YugabyteDB you can use sharding and partitioning, so it can be confusing. In this blog post, we explore the differences (and similarities) between them and when each should be used.
May 26, 2023
Will a Partitioned Table in YugabyteDB Also Be Sharded?
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.
May 24, 2023
Differences in Primary Key Usage Between Colocated and Non-Colocated Tables
In this blog post, we will explore the differences between colocated and non-colocated databases/tables and then dive into the syntax implications of primary key usage on colocated and non-colocated tables/databases.
May 18, 2023
Understanding Client Connections and How Connection Pooling Works in YugabyteDB YSQL
In this blog post, we explore client connections in YugabyteDB, their impact on scalability, and the role of connection pooling. We address common questions and provide insights for developers looking to design efficient interactions between their applications and the database.
May 10, 2023
Geo-Distribution in YugabyteDB: Engineering Around the Physics of Latency
This blog examines the geo-distributed deployment topologies offered with YugabyteDB that can future-proof your data infrastructure and support your app’s needs.
May 3, 2023
Seven Multi-Region Deployment Best Practices
Despite advancements in public clouds, region and zone outages still occur once or twice a year. This blog offers best practices to improve performance and reduce latencies in a multi-region deployment.
April 17, 2023
Maximizing Database Performance: The Benefits of Full Compactions and Automated Scheduling
This blog post describes the benefits of full compactions, some of the scenarios where they are used, and how to best schedule them in YugabyteDB.
March 15, 2023
Fuzzy Matching in YugabyteDB
This blog discusses the performance issues with wildcard lookups in YugabyteDB and showcases alternative methods to find specific data in a large dataset, including several varieties of phonetic matching and trigrams. A test plan is provided to demonstrate basic query timings.
March 14, 2023
Prioritizing Security, Stability, and Client Satisfaction: Insight from Fiserv’s VP and Fellow Architect
Dimitri Farafonov, VP and Fellow Architect at Fiserv, recently sat down to discuss his role at this top global fintech and payments company. During the conversation, he discussed the priorities that guide Fiserv’s database selection process, along with the complexities involved in working to achieve low latency, data consistency, and massive bi-directional scalability, which are critical to Fiserv’s operations.