I started to work at my current company at 2013. In that year I got a maxed-out MacBook Air, which I loved a lot, but it became a bit storm-beaten, I poured some coffee into it (two or three times) – the first one led to a mainboard replacement, but the others were forgotten, and once my son hammered it a bit – few damages on carousel, and a broken charge connector which was repaired.
Last year I got a new 15″ maxed-out Macbook pro, and I really didn’t like it, so I was procrastinating the switchover for a few months after the machine was on my desk – I got the machine around May, and I moved on that around October.
And I bought my old laptop from the company because I liked it.
I use the new machine for three months so I can articulate my opinion about the new MBP series: they’re a glorious piece of shit. The keyboard is awful – the worst one I had for years, my fingertips are hurt a lot – I have to type really strong to get the feedback, and that is painful. The machine is too big for me, it is not convenient to put it into my lap, I have to hold it there, not just put down. The touch bar is useless, but at least it is easy to accidentally touching it, which will lead to funny moments like reloading a webpage which I use, and the apps I am using not getting any advantage from it. For example, I can change my terminals color scheme, or I CAN OPEN A F*CKING MANUAL. That’s just wow. I really needed that, thanks, guys! And as a heavy vim user, I really don’t need a physical escape button for sure. The force click touchpad is useless as well, but at least I had to learn a new way to interact finder, and I just don’t want to talk about USB-c.
So, I decided to move back on my old MacBook Air.
I started to use Percona Monitoring and Management (PMM) recently because it seems promising, and my friends from Percona always recommending it to try out, and frankly, at first sight, I like it.
There are few things which I am not happy about, but mostly I feel OK – but when it comes to the price/value evaluation it becomes better – it is free.
However I found a really disturbing problem, what is bugging me – it needs AWS credentials to discover hosts on RDS. Let me show you.
Continue reading “PMM and IAM Roles”
I am really angry now.
A few weeks ago, when I was finished my MySQL backend checker I lost about two hours of work because I wasn’t commit anything to git, but I overwrote the working file with one of my doodle files – which file had the same name but with camel case. I had a default APFS filesystem (on High Sierra) – which is not case sensitive. This was a real amateur mistake I admit it, but the damage was done, I had to recreate everything (actually the second time I was way faster, it took around an hour.)
Continue reading “OSX and case-sensitive file system”
When doing interviews in the past, I always had hard times to figure out how could I ask about those things which are important to me. Let’s face it when you are in an interview, and you want to know if you are supposed to work in the weekends or not, it is not always to best way to ask about this directly because you’ll have a chance that the company will lie to you about that. So, for example, you can ask instead ‘How responsive are people to emails/Slack over the weekends and after 6pm?’ and then you might have the chance that you’ll have the answer you are looking for.
I know this because I recently read this in this on a page at keyvalues. There are a few really good questions there, so I recommend to check the page – you never know when you’ll need this.
It was a long time ago so I won’t write about the conference (it was good as always), but at least I share the slides of my talk here.
On the other day, I was sitting in front of my console, and tried to get the courage to run ‘terraform destroy’.
I started to think about what shall I do in the future to avoid situations like this, and then I realized the problem is with the ‘default’ section. When you run the ‘aws configure’ command, it will create you a section named ‘default’ in the .aws/credentials and .aws/config files, from that very moment you will use that section as your … well, as your default credentials, and when you add more and more keys, you can select them by using ‘–profile’ switch over and over again.
Continue reading “AWS Profile switching”
This was fun!
I mean, I did not create any new content here for a while, and I have very good reasons about that – but tbh I was lazy, and overwhelmed with stuff to do.
We migrated everything to AWS – so be prepared for some Amazon related posts, I changed MySQL to Aurora and my company itself changed a lot.
In this pause time, I tried to migrate everything to Jekyll, but it wasn’t a success, then I spent the time to migrate everything to Hugo … and now I am on WordPress again. Funny.
In the future, I plan to make the posts here a bit more diverse, not just tech stuff. We’ll see it.
I just created the Budapest MySQL Meetup group. I hope there will be interest for that, the first event is under organising. Check it if you are near Budapest!
Earlier this week we had a discussion with fellow DBAs about our mysql prompts, and at the end of the day it showed up, that a lot of us hit the same problem.
The problem is, that when you set up your mysql prompt then ‘\h’ will be resolved to ‘localhost’ when you connect locally – instead the name of your host as you expect it. It always bugs me, and once I spent a good afternoon figuring out how to workaround this.
Well, the workaround is not a big deal, because you can insert any text into your mysql prompt, and after you realise that you can do it, then it is easy: just put the hostname into your prompt with your chosen provisioning tool and that will do.
Continue reading “My MySQL command prompt”