How to copy file with SCP from one server to other without password

Sometimes we will need to automate file copying between our servers. For example, our shell script might need to copy the backup from time to time and we don’t want to provide the password in the clean text format. So what we can do about this?

Continue reading “How to copy file with SCP from one server to other without password”

Multiple MySQL instances on one server

When you enter the field of multiple MySQL instances on one physical server you might run into the trouble. Lack of documentation, cryptic bugs, and insane settings is something you need to get used to. I almost quit a few times in the process and only my habit of trying unusual things when everything logical failed kept me up to the solution.

Continue reading “Multiple MySQL instances on one server”

Invalid characters in JSON

Recently I run into problems trying to save JSON into MySQL database. Even though MySQL supports JSON type for some time now, there are still plenty of gotchas while you work with it. The situation is pretty critical with special characters. This time we are going to be short and on the topic of invalid JSON characters.

Continue reading “Invalid characters in JSON”