How Shopmonkey built scalable, geo-aware auto shop management software on CockroachDB

Description

Shopmonkey was founded in 2016 to help automotive care retailers run their end-to-end business. Their platform enables shops to streamline operations and gain deeper insights into their business and customers from repairs to billing to inventory management. With over 6,000 current customers and 700 new locations being added every month, they needed to find a way to scale their infrastructure so they could accommodate new business. In addition, they needed to ensure they were delivering an ideal customer experience by providing a platform that delivered low latency access regardless of the shop’s location. Watch the full video to see how Shopmonkey built scalable, geo-aware auto shop management software on CockroachDB and learn: ✔️ What challenges they faced using MongoDB, PostgreSQL and ElasticSearch to run their platform along with multiple different ORM frameworks, dozens of microservices, and Kafka in a single AWS region, and why this led them to CockroachDB. ✔️ How CockroachDB allowed them to guarantee always-on availability, scale out to multiple regions as needed, adhere to sensitive distance and latency requirements, and simplify their architecture. ✔️ How CockroachDB's Regional By Row database locality feature allows Shopmonkey to store data as close as possible to the physical location of their customer’s shop. ✔️ How the Cockroach Labs team helped Shopmonkey rebuild and tune their platform. Want to learn more? You can read the full case study at https://cockroa.ch/3wg01sq 00:00 What does Shopmonkey's auto shop management software do? 00:30 Scaling challenges before CockroachDB 00:58 What Shopmonkey needed from a database 01:14 The multi-region capabilities of CockroachDB 01:42 Tips for getting the best CockroachDB experience Additional Resources ✔️ REGIONAL BY ROW- Database homing in CockroachDB: https://www.cockroachlabs.com/blog/data-homing-in-cockroachdb/ ✔️ Change data capture (CDC) in CockroachDB: https://www.cockroachlabs.com/docs/stable/change-data-capture-overview _____Follow Cockroach Labs_____ ✔️ Website: https://cockroachlabs.com/ ✔️ Twitter (X): https://twitter.com/CockroachDB ✔️ Linkedin: https://www.linkedin.com/company/cockroach-labs ✔️ Facebook: https://www.facebook.com/cockroachlabs ✔️ Instagram: instagram.com/cockroachdb ✔️ Threads: https://www.threads.net/@cockroachdb #systemdesign #database #autoshop