Home Migrate Your Databases to Kubernetes and Docker
Post
Cancel

Migrate Your Databases to Kubernetes and Docker

Migrate Your Databases to Kubernetes and Docker

Have you been putting off migrating your database to Docker and Kubernetes like I have? Well wait no longer. It’s simple using this step-by-step tutorial. Today, we’ll move a database that’s on a virtual machine to a container that’s running in kubernetes. Oh yeah, this will also work if it’s a bare metal server too, duh. 🙂

Watch Video

See all the hardware I recommend at https://l.technotim.live/gear

Don’t forget to check out the 🚀Launchpad repo with all of the quick start source files.

mysql_backup.sh

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
#! /bin/bash

BACKUP_DIR="/home"
MYSQL_USER="root"
MYSQL=/usr/bin/mysql
MYSQL_PASSWORD="your my sql password"
MYSQLDUMP=/usr/bin/mysqldump
MYSQL_HOST="mysql"
MYSQL_PORT="3306"

databases=`$MYSQL --user=$MYSQL_USER --host $MYSQL_HOST --port $MYSQL_PORT -p$MYSQL_PASSWORD -e "SHOW DATABASES;" | grep -Ev "(Database|information_schema|performance_schema)"`

for db in $databases; do
  $MYSQLDUMP --host $MYSQL_HOST --port $MYSQL_PORT --force --opt --user=$MYSQL_USER -p$MYSQL_PASSWORD --databases $db | gzip > "$BACKUP_DIR/$db.gz"
done
This post is licensed under CC BY 4.0 by the author.