Minikube: Persistent Storage

Run the command:

sudo minikube start --vm-driver none

Make sure that the name of the claim matches the claimName in the pod file:

cd ~/dynamic
cat ./mysql-volume.yaml

While still in the dynamic directory Create the volume:

sudo kubectl apply -f  ./mysql-volume.yaml

Verify that the volume target name in the mysql-pod.yaml matches the claim name from the previous step

cd ~/dynamic
cat ./mysql-pod.yaml

Run the command:

sudo kubectl apply -f ~/dynamic/mysql-pod.yaml

Ensure the container is started (it might take a couple of minutes to show (READY):

sudo kubectl get po

We'll need the IP of the container, so let's run that same command, but with an extra option:

sudo kubectl get po -o wide

Make a note of that IP, because we'll need it in a minute.

This will install the latest version of the database client:

sudo apt install -y mysql-client

Before we can log into the database though, we'll need the root password. Look for it in the pod YAML using this:

cat ~/dynamic/mysql-pod.yaml

Look beneath the line that says MYSQL_ROOT_PASSWORD.

Now, with that password and the IP from a minute ago, let's log in:

mysql -h <IP_ADDRESS> -u root -p<MYSQL_ROOT_PASSWORD>

From the mysql command prompt get a list of the default databases:

show databases;

Create a new database, to ensure things are working correctly:

create database example;

Show the databases again to see if our new one is there:

show databases;

Now exit MySQL:

exit