Sh*t happens and sometimes you need to rebuild your MySQL database. It might be because you need to reconstruct your environment or just duplicate your environment. But here’s some things to remember when you’re rebuilding a MySQL database.
I am pleased to announce that I have started developing a database back-end for the Barcrawl web app and have been making good progress. Since I have deployed Barcrawl using Elastic Beanstalk on Amazon AWS, I am limited to a MySQL database. But that is not a problem since my only previous experience is in MySQL. This database is meant to reduce the application’s dependency on API calls in the Python back-end. This decision comes in order to reduce the impact on the APIs’ request quotas and to help reduce latency in the back-end since the rate of requests to the Google Maps API have to be limited.