Talk in English - US at ZgPHP meetup 2017/03 (#67)
View Slides: https://drive.google.com/file/d/0B317gKEmeDtbS3VWWm9FZGVDaUE/view?usp=sharing
Short URL: https://joind.in/talk/770c6 (QR-Code (opens in new window))
If you ever had to maintain and setup test environments of your production app, you know how much pain in the neck it can be. Manual DB imports are heavy and automatic ones can easily be prone to security issues. In the talk I will describe approach we've been using for auto updated large databases on dynamic test environments for testing your web apps.
Test database that is decoupled from the production one and actually is a clone of it, can easily get outdated and further testing on it can make your development process harder. With simple approach we've designed, we can have fresh databases imported every night and UI for modifying what database our app is using for testing purposes. I will explain how we used different tools in order to split, process, purge, seed and prepare large DB dumps for import through the night - completely automatically so we don't have to worry about them at all