MySQL Workbench is a very handy administration tool for the MySQL database server. Unfortunately, it has been removed from mainline Ubuntu repositories as of Ubuntu 19.
MySQL Workbench is a very handy administration tool for the MySQL database server. Unfortunately, it has been removed from mainline Ubuntu repositories as of Ubuntu 19.
My current project makes use of the MySQL database, which runs in a Docker container.
At a certain moment connecting to the database became excruciatingly slow, taking tens of seconds to establish a single connection. After that everything would work as expected.
The application opens a connection some hundred times, so the startup time had become really unacceptable.
I’ve spent a lot of time hunting that down, and then even more time looking for a solution as I failed to find any on StackOverflow. But finally I’ve solved this.
It’s been about a year since I’ve switched to developing this website (built with Yii 2/PHP/MySQL) using Docker. After just one try I realised that Docker is the best thing happened to development. Well, after Vim, of course.
So I’ve decided to write a brief tutorial on setting up a dockerised development environment, in the hope it could be helpful for those who never tried Docker or experience difficulties getting started.