![]() Interactive analytics dashboard requires fast query responses This post will walk you through our journey of considerations, tests, requirements, blockers and so on, as we helped our customer determine which database would ensure an optimal balance of increased performance and reduced cost-with the simplest migration off of Redshift, too. The customer’s data size was not huge, it was around 500GB-which led them to wonder: should they choose PostgreSQL which would likely reduce the migration effort because Redshift is Postgres based? Their question was: would a single Postgres node give suitable performance? Or should they choose a pure analytical store, which might not be required and incur extra migration effort. Regarding the database, Azure offers a variety of database services, so our customer had a few choices. ![]() Migrating Databricks to Azure was straightforward because Databricks is available as a first-party service on Azure via Azure Databricks. To address these issues, they decided to migrate their analytics landscape to Azure. AWS Redshift was not able to offer independent scaling of storage and compute-hence our customer was paying extra cost by being forced to scale up the Redshift nodes to account for growing data volumes. Specifically, the amount of data in our customer’s analytic store was growing faster than the compute required to process that data. And they’d been running into performance bottlenecks and also was incurring unnecessary egress cost. Their setup was deployed on AWS and GCP, across different data centers in different regions. The customer-in the retail space-was using Redshift as the data warehouse and Databricks as their ETL engine. One recent database migration project I worked on is a story that just needs to be told. In my work as an engineer on the Postgres team at Microsoft, I get to meet all sorts of customers going through many challenging projects. Azure documentation links have been updated throughout the post, to point to the new Azure docs. Update in October 2022: Citus has a new home on Azure! The Citus database is now available as a managed service in the cloud as Azure Cosmos DB for PostgreSQL. ![]() This post by Sai Srirampur was originally published on the Azure Database for PostgreSQL Blog on Microsoft TechCommunity. ![]()
0 Comments
Leave a Reply. |