Category: Tutorials

  • MySQL – Calculating Disk Usage Per Database

    MySQL – Calculating Disk Usage Per Database

    The answer usually lies within /var/lib/mysql/[DATABASE]. But the answer can also be found in, you guessed it, information_schema! 😀 Here’s an one-liner for you, that displays database sizes in megabytes (nice long float() included) If gigabytes are more your thing, run the following: Example output: Query on 👾

  • Kubernetes – Kubectl MySQL Client One-Liner

    Kubernetes – Kubectl MySQL Client One-Liner

    Some of my applications, if not all of them, use MySQL in some fashion. The database pod is not exposed outside it’s kube-network service and is only reachable from within it’s namespace… Troubleshooting or random database querying can be a hassle. Here’s a one-liner to help you: The container will disappear when you exit the […]

  • Kubernetes – VIM Customized for YAML Editing

    Kubernetes – VIM Customized for YAML Editing

    I don’t always have access to my customized Visual Studio Code IDE when I quickly need to edit or create some new Kubernetes deployment or ingress for example. Keeping track of tabs, spaces and object position (!!!) is quite tricky in VIM’s default setup. Below are some settings that can lighten the burden and mimic […]

  • RoundCube – Enable Desktop Notifications

    RoundCube – Enable Desktop Notifications

    One feature I really missed, when moving accounts from GMail to self-hosted E-Mail, was the desktop notification feature from the web interface. Luckily, github.com/stremlau/ has solved this for us with a RoundCube Plugin. You will need to have GIT installed on the webserver in order for this tutorial to work. HowTo: Become Root Change directory […]

  • Kubernetes – Useful Shorthands for Kubectl

    Kubernetes – Useful Shorthands for Kubectl

    Useful aliases for kubectl that I use Add these to ~/.zshrc (ZShell) or ~/.bashrc (Bash)