Atlas is revolutionizing the restaurant industry by providing an integrated operating system that encompasses everything from online storefronts to customer loyalty programs. With partnerships involving various brands in Singapore, Atlas helps merchants enhance sales and streamline operations through dedicated Cloud SQL for PostgreSQL databases.
Recognizing the unique needs of different restaurant types, Atlas employs isolated databases for each merchant. This approach ensures data separation, consistent performance during peak hours, and the ability to scale and tune each database independently as the company grows.
Challenges of Scaling
Initially utilizing the standard Cloud SQL Enterprise edition, Atlas faced operational challenges as it expanded its merchant base and introduced new features. Managing connection pooling separately became cumbersome, leading to increased maintenance and monitoring demands. Identifying performance issues was time-consuming, especially without dedicated database engineers.
Transition to Enterprise Plus
Upon exploring options for provisioning new database instances, Atlas was introduced to Cloud SQL Enterprise Plus edition, which promised to alleviate many operational burdens. Key features included:
- Managed Connection Pooling: Integrated within Cloud SQL, reducing the need for separate pooling management.
- Query Insights: Enhanced visibility into expensive queries and their sources, enabling targeted performance tuning.
- Data Cache: Maintains consistent read performance as merchant data grows.
- Near-Zero Downtime Scaling: Allows for scaling of instances without service disruption.
Following a successful pilot, Atlas migrated all existing databases to the Enterprise Plus edition.
Impact on Operations
With thousands of restaurant outlets and daily processing of tens of thousands of orders, Atlas now allocates 30% less time to database operations. This efficiency enables faster merchant onboarding and proactive performance management, allowing the company to focus on product development and customer service. As a result, Atlas has experienced significant year-over-year growth.
Future Innovations
Atlas is heavily investing in AI to enhance both internal processes and external offerings. By adopting AI-assisted development workflows, the team can expedite code development and deployment. Additionally, Atlas is developing AI-powered tools to support restaurant operators in making informed decisions.
With a robust infrastructure provided by Cloud SQL and Google Kubernetes Engine, Atlas is positioned to innovate rapidly without infrastructure concerns. The shift to Cloud SQL Enterprise Plus has established a flexible and observable database architecture, enabling Atlas to prioritize merchant needs and growth.
