Automated Production to Development Refresh for your Cloud Databases
Blog post from Tessell
In data-rich environments, the need for testing environments that closely mirror production datasets is crucial for accurate testing and quality assurance. Tessell addresses this need by offering a solution for seamless data refreshing across environments, using a Source → clone model where a live database is snapshotted regularly, and a separate virtual machine clone is updated according to a defined schedule. This process involves setting service level agreements (SLAs) for snapshot retention and using Tessell's API for programmatic automation. The cloning process supports features like database renaming, multi-instance support, and manual or scheduled refreshes to adapt to various operational needs. Tessell also provides pre- and post-refresh scripting capabilities, allowing users to execute scripts during the refresh process to manage database settings or users. The platform is designed to be user-friendly and offers both a user interface and API for triggering on-demand refreshes, ensuring flexibility and ease of use for managing data environments.