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/

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
5. © 2023 All Rights Reserved Two Stages of DevOps/SREs at Retailers Stressed Preparing for Stress November & December
6. © 2023 All Rights Reserved Why is it so challenging?
7. © 2023 All Rights Reserved All critical services depend on a transactional database
8. © 2023 All Rights Reserved Time to make your life easier by rethinking your business-critical services with a distributed SQL database.
9. © 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
10. © 2023 All Rights Reserved Trick (or Treat) #1: Architect for Peak Demand
11. © 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
12. © 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
13. © 2023 All Rights Reserved How can a distributed database help? Automatic sharding On-demand scaling Performance at scale
14. © 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
15. © 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
16. © 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
17. © 2023 All Rights Reserved Trick (or Treat) #2: Design for Global Shoppers
18. © 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
19. © 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
20. © 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
21. © 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
22. © 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
23. © 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
24. © 2023 All Rights Reserved Trick (or Treat) #3: Ensure Accurate Inventory Results
25. © 2023 All Rights Reserved What happens when your data isn’t accurate…
26. © 2023 All Rights Reserved What happens when your data isn’t accurate… … you have to send one of these to your customer!
27. © 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
28. © 2023 All Rights Reserved How can a distributed database help? Native, consistent CDC Built-in resilience ACID transactions with strongly consistent data
29. © 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
30. © 2023 All Rights Reserved Trick (or Treat) #4: Mitigate Risks for Business as Normal
31. © 2023 All Rights Reserved
32. © 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
33. © 2023 All Rights Reserved How can a distributed database help? Built-in resilience Very Low RPO/RTO Increase productivity
34. © 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
35. © 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
36. © 2023 All Rights Reserved Closing Thoughts and Next Steps
37. © 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
38. © 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
39. © 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
40. © 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.
41. © 2023 All Rights Reserved Learn More yugabyte.com/retail-ecommerce/ cloud.yugabyte.com
42. © 2023 All Rights Reserved 42 Thank You Join us on Slack: www.yugabyte.com/slack Star us on GitHub: github.com/yugabyte/yugabyte-db