Operating across two data centers can present challenges such as regional outages affecting distributed quorums and potential data loss from asynchronous replication. This blog explores how YugabyteDB addresses these common issues with specialized deployment patterns that ensure high availability and robust disaster recovery across multiple fault domains.
Disaster recovery is streamlined with YugabyteDB 2.21, introducing industry-first native orchestration features to ensure your data stays safe and readily accessible in today’s volatile cloud environments. This update not only simplifies resilience with the native xCluster DR but also supports database modernization and risk reduction through advanced isolation levels and Kubernetes Operator.
PgBench is widely used for testing database performance, but its default ‘TPC-B like’ workload may not accurately represent true performance. To achieve more realistic load testing, users can employ custom SQL scripts within PgBench. In this demonstration, we’ll show how these adjustments work using YugabyteDB.
Join the free virtual Distributed SQL Summit (DSS) Asia event on April 24th to learn about database modernization and distributed SQL, featuring talks by industry-leading speakers from companies like Airwallex, Helpshift, IMDA, Navi, Singtel, Tagbangers, UL Systems and more, with three tailored talk tracks for everyone. Check out the full schedule and register now to attend!
YugabyteDB’s automatic sharding overcomes PostgreSQL’s partition key limitations by allowing date range queries without modifying table partitioning. Thanks to its global secondary indexes, which don’t require a shared sharding key, YugabyteDB enhances performance by distributing rows across multiple servers. Discover the full advantages and see step-by-step instructions in our latest blog post.
In database management, efficiency and reliability are key. Downtime is costly, affecting both finances and reputation. Strong backup and recovery solutions are vital for reducing data loss and enabling fast recovery. This post shows how to easily restore a 15TB YugabyteDB database from an Amazon S3 backup in under 30 minutes.
Need a database that can accommodate a distributed hybrid deployment model, lower read and write latency, and (most importantly) run the existing PostgreSQL application without an expensive rewrite? See how YugabyteDB was able to meet a logistics company’s performance requirements with no PostgreSQL app changes.
A logistics firm sought to enhance the performance and resilience of their RF system. By implementing a hybrid cloud stretch cluster deployment and strategically positioning data close to users, they successfully lowered latency, aligning with user demands for speed and availability. Explore the detailed approach and outcomes in the following analysis.
Managing large PostgreSQL tables requires partitioning, which can complicate queries. Migrating to YugabyteDB simplifies scaling by automatically sharding and distributing data and minimizing partition reliance. The article includes demos on PostgreSQL’s partitioning limitations and YugabyteDB’s advantages in distributed tables and scalability.
Server racks can be strategically utilized as fault domains to boost resilience and ensure high availability in on-premise YugabyteDB deployments. It remains up despite rack outages by spreading data across multiple racks. Read our blog to learn how to configure and deploy nodes across racks.