December 2022 Summaries

There are several reasons why companies can benefit from using YugabyteDB Managed REST APIs, including automating the deployment and management of databases, reducing the time needed to bring up applications from hours to minutes, and providing a seamless experience for developers. The APIs offer features such as easy onboarding with account and project IDs, well-structured documentation, consistent API endpoints, versioning, fault-tolerant design, scalability, and security measures like API keys and auditing. Additionally, the APIs are designed to be easy to debug and provide support through a Slack community or email. Companies can benefit from using these APIs as they are kept simple, resourceful, secure, scalable, and maintainable, increasing developer efficiency and making it easy to build applications.

I worked on a Change Data Capture (CDC) project at YugabyteDB Managed, abstracting the process to make it more user-friendly. I was excited about the opportunity to contribute meaningfully during my 4-month internship and was impressed by the wealth of knowledge of the interviewers throughout the hiring process. The CDC project aimed to provide users with a simple way to specify database tables they wanted to subscribe to, as well as the destination for their stream, allowing them to focus on other tasks. I implemented functionality to create and delete streams, reconfigure and redeploy the CDC Virtual Machine in case of failures, and supported Kafka Sinks as an endsource, making it extendible to more sources in the future. During my internship, I had a great experience interacting with coworkers in person again, participating in internal Hackathons, and exploring the west coast of the United States.

As part of the People at Yugabyte series, Kripa Sreenivasan, a lead software development engineer, shares her experience working at Yugabyte. She joins a start-up after 10 years in larger organizations and finds it challenging yet impactful, with opportunities to solve exciting problems and learn new skills. Kripa attributes her positive experience to the company culture that values trust, relationships, and outcomes, which is built through transparency and a strong sense of community. The leadership's commitment to their core values is evident, and the team is communicative, hardworking, and respectful. Kripa has learned the importance of considering multiple factors when evaluating and testing new features, and she appreciates the company's focus on employee wellbeing, offering scheduled wellness days off and unlimited vacation. She encourages others to interview with Yugabyte, highlighting the excitement and passion employees have for their product and work culture.

In this article, the author explores four ways to handle automatic ID generation in Sequelize for PostgreSQL and YugabyteDB: Auto-incrementing (SERIAL data type), Sequence-caching, Client-Side Sequencing, and UUID-generation. The author discusses the pros and cons of each approach, including latency costs, memory constraints, and performance benefits. The article concludes that the choice of ID generation method depends on the specific requirements of the application, such as infrequent writes, low-latency writes, or distributed deployments.

YugabyteDB 2.16 is now generally available, offering enhancements and features previously previewed in past releases. This new release focuses on helping businesses grow with fast, reliable access to accurate data, allowing developers and IT operators to meet high customer expectations and accelerate productivity. YugabyteDB 2.16 brings several key updates, including Packed Column Storage Format for accelerated bulk data loading, improved security options such as Google Cloud KMS and Azure Key Vault, enhanced Change Data Capture (CDC) capabilities with better usability and hardening, simplified Kubernetes universes, differentiators like Enhanced xCluster Replication, and accelerated backup and restore with up to 5x higher throughput. Additionally, YugabyteDB 2.16 introduces custom hooks during pre- or post-provisioning and upgrades, a new Node.js smart driver for YSQL, and other features that simplify load balancing and improve overall performance.

YugabyteDB 2.17 introduces major updates to its backup and restore capabilities, enabling faster and more efficient data protection for business-critical applications. The new "Backup 2.0" architecture improves the performance of backups and restores by up to 5x, reducing recovery times and increasing the frequency of backups. Additionally, incremental backups are introduced, allowing organizations to create smaller, more frequent backups that reduce the amount of data transferred across the network. These features empower developers to modernize their databases and improve productivity, while also providing a host of new benefits unmatched in legacy and many modern databases.

You can now experience the latest innovations in YugabyteDB Managed, a fully managed service for YugabyteDB, the industry-leading open source distributed SQL database. This advanced DBaaS allows you to easily setup and connect to an infinitely scalable, resilient, Cassandra and PostgreSQL-compatible database with minimal operational overheads. It gives you access to a broad set of automation and self-service capabilities, reducing operational costs and accelerating time-to-market for cloud native applications. The new features include self-service geo-partitioned clusters, low-latency reads from read replicas, and an enhanced Terraform provider for infrastructure-as-code deployment. Additionally, YugabyteDB Managed offers a free trial with premium features, the Quantum Leap program for startups to turbocharge their enterprise, and a $10,000 credit for eligible companies.

YugabyteDB 2.17 introduces several key enhancements to its xCluster replication feature, designed to improve disaster recovery (BCDR) strategies for organizations that rely on high availability databases. The new features include atomicity and ordering guarantees, APIs for disaster recovery workflows, better handling of schema changes across clusters, and automatic pause and resume of replication on schema modifications. These improvements aim to simplify xCluster usage, enhance data integrity, and protect mission-critical data from region-level failures, making it easier for organizations to meet their BCDR requirements. With these enhancements, YugabyteDB 2.17 provides a more robust and reliable solution for businesses that require high availability and disaster recovery capabilities.

I have been part of a remote-first, geographically-distributed workforce at Yugabyte since March 2022. The company's core values of Trust, Relationships, and Outcomes are crucial in such an environment. I associate with these values by being transparent in my interactions, taking responsibility for my work, and celebrating the impact of others. Through regular team activities, mentorship, and recognition of individual achievements, Yugabyte has fostered a strong sense of community and trust among its distributed teams. This culture allows me to grow both personally and professionally, as I've learned the importance of small teams, clear goals, and trusting my colleagues. Outside work, I enjoy spending time with my family and exploring the world with my 3-year-old son.

YugabyteDB 2.17 introduces several major innovations to support enterprise-grade distributed SQL database applications, including enhanced protection for critical data through xCluster replication, 5x faster backup and restore, and incremental backups that protect critical data 20x more frequently. The new release also enhances YugabyteDB Managed with simplified operations and advanced automation, meeting dynamic compliance requirements, improving customer experience, and delivering cloud native Infrastructure-as-Code via enhanced Terraform provider. Additionally, YugabyteDB 2.17 accelerates developer productivity with expanded security choices, streamlined management and planning through enhanced observability, automated maintenance tasks, and simplified load balancing.

Guy Chiarello, Chief Operating Officer at Fiserv, a leading global fintech company, believes that innovation in the financial services sector is crucial for continued growth and competitiveness. He emphasizes the importance of leveraging technology trends such as artificial intelligence (AI) to gain a significant advantage in the market. Chiarello also highlights the need for real-time processing capabilities, continuous availability, and simplified data management in various industries including banking and payments. Fiserv's partnership with YugabyteDB is seen as an opportunity to drive innovation in transactional processing, providing a cloud-native solution that simplifies data management and enhances performance. The partnership aims to address key challenges such as fraud detection, security, and scalability, while also improving the overall user experience through real-time insights and automation features.

To optimize pagination for distributed data while maintaining ordering, an application-level sharding layout can be used to avoid hotspots on range-based indexes. By creating multiple shards and using the PRIMARY KEY of the table without additional indexes, it's possible to retrieve only the rows needed from each shard and perform an efficient k-way merge on the already sorted streams using the Merge Append operator. This approach allows for paginated results while maintaining the DESC ordering of the event_ts column, making it a suitable solution for getting paginated results from a table with range-sharded data.