Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Take the Stress out of Retail Peak Traffic Events

Take the Stress out of Retail Peak Traffic Events

In the fiercely competitive world of eCommerce, ensuring a seamless and high-performing website is vital. Any hiccup, slowdown, or downtime doesn't just cause a loss of revenues. Well, it does, but it also inflicts long-term brand damage, impacting even stock prices for publicly-traded companies

Join our exclusive webinar to discover the six critical moments that pose a threat to your eCommerce site's performance and reputation. With over 26 million active eCommerce sites worldwide and projected global sales of $5.8 trillion by 2023, the stakes have never been higher.

Learn from real-life examples and explore strategies to fortify your site during:

- New Product Launches
- Exclusive Events
- Natural Disasters
- Influencer/Celebrity Endorsements
- Black Friday/Cyber Monday
- General Unpredictable Events

Take the first step in protecting your brand, revenue, and customers’ satisfaction levels. Join us and ensure your site remains resilient and available during peak demand.

Event URL - https://www.linkedin.com/events/unmaskingblackfridaydatabasefri7122342741358845952/about/

AMEY BANARSE

January 30, 2024
Tweet

More Decks by AMEY BANARSE

Other Decks in Technology

Transcript

  1. © 2023 All Rights Reserved Take the Stress out of

    Retail Peak Traffic Events Unmasking Black Friday Database Frights October 31, 2023
  2. © 2023 All Rights Reserved YugabyteDB Speakers Amey Banarse VP,

    Global Field Engineering Michael Haag Director, Product Marketing
  3. © 2023 All Rights Reserved Constant Change New normal since

    2020 Global Competition Cross-category comparisons Data First Mentality Data = Differentiation State of the retail industry today
  4. © 2023 All Rights Reserved Two Stages of DevOps/SREs at

    Retailers Stressed Preparing for Stress November & December
  5. © 2023 All Rights Reserved Time to make your life

    easier by rethinking your business-critical services with a distributed SQL database.
  6. © 2023 All Rights Reserved Four e-commerce scenarios that don’t

    need to be stressful anymore React to Peak Demand Support Global Shoppers Deliver Accurate Inventory Survive the Unexpected
  7. © 2023 All Rights Reserved Peak Events Place Huge Burdens

    on DevOps/SRE Teams • Unpredictable traffic • Huge deviation from the “norm” that can be hard to test and model • Uncertainty around changes or new services • Limited team availability during major holidays • Must lock environment way in advance
  8. © 2023 All Rights Reserved Challenges retailers may face with

    existing database Manual sharding is hard and time consuming Single system requires complex vertical scaling Multiple DBs to deliver high throughput
  9. © 2023 All Rights Reserved How can a distributed database

    help? Automatic sharding On-demand scaling Performance at scale
  10. © 2023 All Rights Reserved How do you architect for

    scale? 14 Option 1: Scale up (migrate to larger machines) Option 2: Manually shard PostgreSQL Option 3: Add caches / read replicas to PostgreSQL • Limits scalability • Disruptive • Not easy to scale back down when demand shrinks • Operationally challenging (requires in-house experts) • Fragile • Application burden • Does not solve write scalability • App becomes complex (primary & replica endpoints) • Cache coherence, operationally hard Option 4: Scale out (and in) automatically (Distributed SQL) • Operationally simple (database handles the scaling) • Transparent to applications • Scale out and scale back in as needed
  11. © 2023 All Rights Reserved Real-World Example: Top 5 Global

    Retailer Extensive Product Catalog • System of record for all products sold online and across thousands of physical stores • Over 100M items, including products from external merchants & partners Key Requirements • High throughput, support multiple TBs in a few hours from Kafka and refresh entire catalog nightly while handling transactional updates • Low latency with 90:10 reads to writes • Multi-region with strong consistency, transactions & secondary indexes • Easily scale during peak seasons with guaranteed resilience • Non-disruptive Day 2 operations (scale up / down, replacing nodes, …) • Platform agnostic for on-prem data center and public cloud Azure IaaS Past Challenges Several issues with previous Apache Cassandra database: • Data not consistent in global product catalog • Needed scale and flexibility • Needed Multi-region deployments with strong consistency & data accuracy Top 5 Global Retailer
  12. © 2023 All Rights Reserved Real-World Example: Top 5 Global

    Retailer Results achieved with YugabyteDB • Handling holiday peak traffic since 2020 season • Scaled cluster seamlessly to >150 nodes of YugabyteDB during peak traffic events in 2022 (Black Friday, Cyber Monday, …) • Linear scale: >250K Business Transactions/sec; 1.25M DB IOPS; 3+ billions of product mappings • Low Latencies: P99 Reads latencies within 3-5 ms; Read optimizations with low latency access using Preferred Leaders • Multi-region, transactional writes ~75ms; Deployed in RF3 across 3 Azure Regions: US-East, US-West and US-Central; Extensive Product Catalog • System of record for all products sold online and across thousands of physical stores • Over 100M items, including products from external merchants & partners Top 5 Global Retailer
  13. © 2023 All Rights Reserved Cross-border shopping is becoming increasingly

    popular 54% of US digital shoppers bought from foreign sites $1T Cross-border e-Commerce in 2020
  14. © 2023 All Rights Reserved Challenges you may face with

    existing database Single writer means high latency Complex deployment configurations Hard to meet data residency requirements
  15. © 2023 All Rights Reserved How can a distributed database

    help? Single, unified database for global customer reach Deployment flexibility Geo-distribution for compliance and performant user experience
  16. © 2023 All Rights Reserved Example Global deployment spanning US,

    EU & APJ Regions • Single YB cluster providing Strong Consistency across multi-region • Scalable and highly available operational data tier • Business continuity, able to withstand Region failure with RPO=0 and low RTO < 10s • Geo-partitioning, Data Locality & Compliance 21
  17. © 2023 All Rights Reserved Flexible deployment options in a

    single database Primary Use Case Performance Notes Stretched Cluster (Synchronous Replication) Active-Active-Active config with Zone-level or region-level resilience RPO=0 and RTO=3-10s; low latency reads & high throughput xCluster Asynchronous Replication Active-Active or Active-Passive for disaster recovery solution Very low read and write latency, high throughput in each cluster Read Replicas Fast reads for globally distributed customers Low latency, high-throughput reads Row-level Geo-Partitioning Satisfy data residency, compliance and regulatory requirements Data pinned to specific geographic locations and high performance in region
  18. © 2023 All Rights Reserved Key Initiative Utilize YugabyteDB's capabilities

    for improved targeting and user experiences for Visitor Relationship Management platform. Admiral Transforms Visitor Relationship Management with YugabyteDB Managed Challenges • ClickHouse (existing database) lacked horizontal scalability to support growing customer base • Manage database sprawl across multiple databases • Higher TCO due to higher maintenance and infrastructure costs. YugabyteDB Managed Business Impact • Lower TCO with reduced maintenance and infrastructure costs • Eliminate database sprawl and complexity with simplified infrastructure • Scale horizontally to meet growing needs
  19. © 2023 All Rights Reserved What happens when your data

    isn’t accurate… … you have to send one of these to your customer!
  20. © 2023 All Rights Reserved Challenges you may face with

    existing database Only supports eventual consistency Failures lead to downtime or data loss Complex app logic slows innovation and UX
  21. © 2023 All Rights Reserved How can a distributed database

    help? Native, consistent CDC Built-in resilience ACID transactions with strongly consistent data
  22. © 2023 All Rights Reserved “Partnering with Yugabyte helps us

    focus on our customers instead of worrying if our systems can keep pace with our rapidly growing business.” Ram Ravichandran, CTO and co-founder Key Initiative Narvar was challenged with AWS databases becoming expensive at scale, while customers and data privacy regulations demanded a multi-cloud solution. Narvar Achieve 4x Lower TCO Challenges Struggled to control costs of AWS DynamoDB • Unable to satisfy multi-cloud requirements • Need to scale on demand during peak seasons • GDPR compliance required multi-region solution YugabyteDB Business Impact Narvar switched to YugabyteDB and achieve 4x lower TCO, simplified ops and met key performance goals: • 10k+ reads per second • <3ms read latency • <10ms write latency 29
  23. © 2023 All Rights Reserved Challenges you may face with

    existing database Expensive, bolted-on resilience Poor RTO & RPO hurts customer experience Decrease in DBA and app team efficiency
  24. © 2023 All Rights Reserved How can a distributed database

    help? Built-in resilience Very Low RPO/RTO Increase productivity
  25. © 2023 All Rights Reserved US-East US-West US-Central Global Retailer’s

    Multi-Region Deployment Shrugs Off Major Storm • 27 Nodes across 3 Azure Regions: US-East, US-West Seattle and US-Central • Strong consistency between all the Regions • System of Record for Product Catalog of 100+ million items with Billions of mappings, serving over 250K ops/sec
  26. © 2023 All Rights Reserved US-East US-West US-South-Texas Global Retailer’s

    Multi-Region Deployment Shrugs Off Major Storm • 27 Nodes across 3 Azure Regions: US-East, US-West Seattle and US-Central • Strong consistency between all the Regions • System of Record for Product Catalog of 100+ million items with Billions of mappings, serving over 250K ops/sec • Service remained resilient and available through Texas cloud / power outage • No Data loss, RPO = 0 , RTO <10 secs
  27. © 2023 All Rights Reserved Four e-commerce scenarios that don’t

    need to be stressful anymore React to Peak Demand Support Global Shoppers Deliver Accurate Inventory Survive the Unexpected
  28. © 2023 All Rights Reserved Simplified DBaaS for all Use

    Cases Orchestration Engine API User Interface Universes & Infrastructure User Interaction DevOps API CI/CD Automation • Cluster Provisioning, Scaling - Horizontal & Vertical on any IaaS • Automated Day 2 Operations ◦ Rolling Upgrades ◦ Security Key Rotations ◦ Backups & Recovery ◦ Point in Time Restore • Enterprise Integrations ◦ Observability ◦ Metrics & Monitoring
  29. © 2023 All Rights Reserved With YugabyteDB, you can architect

    for zero downtime Multi-Region xCluster: Async replication between two YB clusters in different regions US-West US-Central US-East Multi-Region Stretch: Sync replication across regions within a cluster • Assume nodes and zones will fail often • A database should offer continuous availability without heavy lift • Users should have zero impact St Louis Kansas City
  30. © 2023 All Rights Reserved A distributed, transactional database with

    built-in resilience, seamless scalability, and more, with Postgres-compatible and CQL-inspired APIs We’ve eliminated SQL and NoSQL limitations while simplifying the application architecture for building next-generation services and for embracing database modernization.
  31. © 2023 All Rights Reserved 42 Thank You Join us

    on Slack: www.yugabyte.com/slack Star us on GitHub: github.com/yugabyte/yugabyte-db