Amazon Lightsail started offering a managed database service a few months ago.
I took a look at it … and tried it out … a while back and wasn’t really happy with it.
Although it had some nice features, I wasn’t given a ‘root’ (or super user) account and (as I sometimes do) was able to completely trash the instance within a few hours of creating it (I tried to manipulate the permissions on the master database user and ended up revoking all of them).
So I was considering creating my own database server using MySQL on a stand alone Amazon Linux instance.
This would give me a stand alone database with the flexibility to do anything I wanted.
My big concern was network security. I wanted to make sure that only my Lightsail instances would be able to communicate with the database server.Continue reading