Stop Throwing Hardware at Problems: Optimise Databases First
As a database specialist at DNX, I’ve seen this countless times: When performance issues arise, many businesses default to scaling up hardware. But what if the real solution lies in database optimisation? A recent customer engagement reminded me that the best solution often lies not in bigger servers but in smarter code. Let me walk […]
Data Archiving utilising Managed Workflows for Apache Airflow
We assisted a Fintech client to minimize its storage cost by archiving its data from RDS (MySQL) to S3 using an automated batch process, where all data from a specific time range should be exported to S3. Once the data is stored on S3 the historical data can be analyzed using AWS Athena and Databricks. […]