And how I will prevent it from ever happening again No customer data was harmed in this accident. The staging database was recovered within 20 minutes by Amazon RDS Snapshots and was only used internally. Today I made a mistake. It resulted in dropping every table from the staging database. On the bright side, it wasn’t production data. Feature 1: config:cache If you run in your Laravel application, it will generate a file that contains every configuration in your folder. The goal is to speed Laravel’s bootstrapping process by caching the settings in a ready-to-go state. php artisan config:cache bootstrap/cache/config.php config/*.php Feature 2: RefreshDatabase Laravel 5.5 ships with a new trait called and an excellent migrate command called . The trait will migrate only once and then use transactions to speed up the test suite, but it will drop all existing tables before starting. Of course, it is meant to use with or a local database. RefreshDatabase migrate:fresh sqlite :memory: The conflict Your local environment is set to use a staging database that is shared with every developer. The reason you do this is because you want to test the performance of a feature and the staging database have some pretty good data set to test this. But since you want to test performance, you obviously want to the and the . cache routes config You’re happy with the result. It’s time to move on to the next feature. As a TDD lover, you write a new test and run it to see where it breaks. It fails. Great, let’s implement it now. Somebody in the room yells — Guys, what happened to the staging database? Your test suite didn’t load your value from your . It wasn’t necessary because had all the settings necessary. Sadly, not the correct settings. :memory: phpunit.xml bootstrap/cache/config.php You go into Amazon console and restore a snapshot 5 minutes in the past. In 15~20 minutes staging environment is working again with no permanent damage. The aftermath After learning how to blow up an unintended database, let’s learn how to protect it. 1- 101: Drop permission Don’t be lazy. Setup a new database user for your projects that doesn’t have permission on the staging environment. DROP 2- Test Settings Whitelist The trait is the perfect place to check whether a specific setting is expected or not. It’s shared across test suites and it is executed just before setting up the database. CreatesApplication This will make sure that if you do screw up, unexpected environments will not be affected. 3- [Bonus] Making debugging easier Your environments are protected. Everything is set. This is not gonna happen again. But next time you cache your settings and forget it, your tests will tell you that you have the wrong settings. You’ll probably look at the file puzzled at how that is even possible. To make it clear and easy for the future-you, 3 more lines of code could save some debugging time. phpunit.xml 4- Conclusion The next day I reported on my stand-up meeting that I had tested our database backup system. They are working marvelously. On the bright side, I also reported that I’m not going to be testing it again unexpectedly. Anyway, be careful with production-state commands. Caching config and routing during development stage usually leads to unexpected behavior. It’s possible to lose some time trying to understand why that 404 Page Not Found is happening when you didn’t clear the route cache. The Config Cache was an interesting discovery.

Amazon

Discovery

Too Long; Didn't Read

In your car, at home, or at work — Bosch technology shapes many areas of life.

How I destroyed the staging database

Too Long; Didn't Read

Companies Mentioned

Marco Aurélio Deleu

About Author

TOPICS

THIS ARTICLE WAS FEATURED IN...

How I destroyed the staging database

Too Long; Didn't Read

Companies Mentioned

Marco Aurélio Deleu

About Author

TOPICS

THIS ARTICLE WAS FEATURED IN...

RELATED STORIES