Photo by Glenn Carstens-Peters on Unsplash

Command Comparison

Since TSV import is troublesome for both MySQL and PostgreSQL, it is best to create your own script to convert TSV to SQL.

PostgreSQL/MySQL information_schema

Since information_schema is a SQL standard, the same SQL can be used in either case.

Setup Default Connection

In PostgreSQL this is set by environment variable

export PGDATABASE = DB name
export PGHOST = host
export PGPORT = port number
export PGUSER = username
export PGPASSWORD = password

The password can also be set with ~/.pgpass

In MySQL we can set all in ~/.my.cnf

[client]
database = DB name
user = username
password = password

Introduction

If you really forget all the options, just type journalctlto see all the saved logs, if a long line is truncated, you can scroll to the right by pressing the arrow keys

Let’s start

root@test:/home/ozyrys# journalctl -e
root@test:/home/ozyrys# journalctl -ex
root@test:/home/ozyrys# journalctl -f
root@test:/home/ozyrys# journalctl -u sshd

You can specify the full path of the executable file as in.

root@test:/home/ozyrys# journalctl /usr/sbin/sshd
root@test:/home/ozyrys# journalctl -n 100
root@test:/home/ozyrys# journalctl -b

Photo by israel palacio on Unsplash

Introduction

In this short post I will show you how we can easily expose Jmx in Kubernetes. If we want to temporarily debug our application with JMX the easiest way is forward JMX port from Kubernetes pod to your local PC with kubectl port-forward.

Let’s start

-Dcom.sun.management.jmxremote
-Dcom.sun.management.jmxremote.authenticate=false
-Dcom.sun.management.jmxremote.ssl=false
-Dcom.sun.management.jmxremote.local.only=false
-Dcom.sun.management.jmxremote.port=5000
-Dcom.sun.management.jmxremote.rmi.port=5000 …
Photo by Panos Sakalakis on Unsplash

Introduction

I will show you how to quickly change the proxy of the browser and the LAN to connect to using the command line.

You need administrator privileges to execute the command .

Preparation

Check Interface Name

netsh interface show interface

Virtual settings

  • Proxy: 10.21.21.100:8080
  • Ip Address: 10.21.21.10
  • Mask: 255.255.0.0
  • Gateway: 10.21.21.1
  • DNS: 10.21.21.200
  • Proxy: 172.10.1.100:9090
  • Ip Address: 172.10.0.10
  • Mask: 255.255.0.0
  • Gateway: 172.10.0.1
  • DNS: 172.10.0.200

Switch to Settings01

Switch to Settings02

Photo by Pablo Arroyo on Unsplash

What do we want to achieve?

Easily manage Docker with systemd

Let’s start

Create file /etc/systemd/system/docker-compose@.service The name of this file is important, so basically don’t change it.

Nothing happens with this alone. This is like a service template for Docker-compose

🚨 When you put the file, be sure docker-compose.yml to put it in!

As you can…

Photo by Anne Nygård on Unsplash

Case

If we consider OpenShift Origin under Proxy, so make a note of the addictive points.

Prerequisites

  • oc version 1.3.1
  • host OS is Centos7

Docker proxy settings

Create the /etc/systemd/system/docker.service.d/http-proxy.conf file with content below:

[Service]
Environment="HTTP_PROXY=http://proxy.com:3128" "HTTPS_PROXY=http://proxy.com:3128" "NO_PROXY=localhost,127.0.0.1,test.io"

You can see the description method in the Docker document, but one point to note. You cannot…

Photo by Roman Synkevych on Unsplash

What is GitHub Actions?

Easily automate all software workflows with world-class CI / CD. You can build, test, and deploy code directly from GitHub to get code review, branch management, and problem triage to work the way you want.

Practical examples

  • Environmental variables (Global)
  • Environmental variables (In step)
  • Multiple command simplification
  • Specify subfolder
  • Action trigger condition…

Maciej

DevOps Consultant. I’m strongly focused on automation, security, and reliability.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store