5/15/2023 0 Comments Sql inventory managerEven tasks like exporting data to CSV required use of Google products like exports to buckets. Cloud lock-in: Using Spanner locked Lush into the Google Cloud ecosystem.They quickly ran into a couple of problems: Standard SQL and simple insertion and extraction of dataīefore eventually landing on CockroachDB Lush first turned from MySQL to Google Cloud Spanner in their early efforts to modernize their database. ![]() Lush wanted to simplify and modernize their data architecture in order to make it easier to analyze the company’s global performance, comply with local data regulations, and reduce operational complexity. This is the cost of doing business on a global scale, and it has been incredibly tricky to accomplish. As an international retailer that does business all over the globe, Lush is required to domicile some user data in particular countries. ![]() The emergence of data protection laws and data localization regulations adds more challenges. The data needs to be located in the same system to make it easy to interrogate that data. In this disparate MySQL instance architecture there is no easy way to immediately assess the performance of Lush’s products at global scale. The Challenge of Disparate MySQL Instances In particular, the disparate MySQL instances could not talk to each other, which made it difficult to optimize inventory or evaluate the company’s performance on a global scale. While this architecture was an integral part of the company as it grew globally, it created a lot of operational complexity. Prior to their migration to CockroachDB Lush’s database architecture was made up of MySQL instances in 20 of the countries in which the Lush Group operates. If you haven’t already indulged in the fragrant self-care of a Lush bath bomb then you may not know that Lush Fresh Handmade Cosmetics is a global inventor, manufacturer and retailer of fresh handmade cosmetics - known for the quality of their ingredients and the environmental thoughtfulness of their packaging (or lack thereof). Lush Architecture Prior to their Migration to CockroachDB In this blog, we’ll cover what Lush’s inventory management architecture looked like before CockroachDB and what they’re able to accomplish with CockroachDB. And inventory management can create extraordinary opportunities when the right tools are used to deliver real-time data insights. Every day Lush processes hundreds of thousands of transactions in over 950 stores located across 49 different countries.
0 Comments
Leave a Reply. |