Saturday, November 7, 2020

Installed MySQL 8 On My Local Machine

 The title of the post says it all.

Once I got my VM up and running and installed nginx, php and php-fpm, it was time to get a database installed.

Back in my old Julep days, we'd used MySQL 5.5 for both our development and production environments. Around the time that the parent company decided to run the "garbage collector" on the Seattle office we'd been staring down the barrel of a forced upgrade to the 5.7 version. 

That by itself was going to be a pretty heavy lift for our team and we could only gaze longingly at the tantalizing beauty of MySQL 8.

Well, out with the old and in with the new, I say. Also, I'm ridiculously happy about our new President Elect Biden. Out with the old and in with the new indeed.

Now, I've already spun up an RDS instance with MySQL 8, but that was easy as all the 'complex' parts are handled for you by the AWS console UI. The most complicated part of that operation was setting up a bastion host and getting all the 'networking' configured so that I could run a client on my local machine and connect to the DB running in side AWS.

Installing it locally was, I feared, an entirely different beast. The last time I'd installed it manually myself was back in . . . 2012? 2011? That had been . . . interesting.

Anyhow, the tools and documentation available on the internet now are vastly better than 8 years ago (and I have a wee bit more on the job experience too I suppose) so it wasn't a problem at all. Not even an inconvenience. Basically I just did what this blog post said to do and BAM, MySQL 8 running on my local.


No comments:

Post a Comment