OSX and case-sensitive file system

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”

Culture Queries

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.

 

AWS Profile switching

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”

I guess I am back again

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.

 

 

Posted in me

My MySQL command prompt

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”

The way I like to compile my Go programs – Makefile

I was on the quest of searching the Holy Grail of Go programming, and I found something, which I doubt that it is, but close enough – for the first sight.

I have several problems with GO, first, that I write my code on an OSX box, and I’ll run the programs on Linux hosts, so I have to solve the cross compilation; my second problem with Go, that I don’t really like the “There is a GO project folder, and all the GO projects are relying on” approach. It makes using GitHub painful.

Continue reading “The way I like to compile my Go programs – Makefile”

MySQL/docker performance report update

Saturday I was in my favorite grocery store, standing in the line, browsing the net on my phone. I read Vadim Tkachenko‘s blog post about Measuring Percona Server Docker CPU/network overhead and his findings were opposite than mine – he didn’t found any measurable difference. Reading his post, he did found huge impact in networking which I didn’t check, so I was re-run my checks again, but now with paying attention to network configuration.

Continue reading “MySQL/docker performance report update”