porthole/images/mysqlclient-utility
Sergiy Markin 2ddd25489a Fixed swiftclient and updated kubeclient
Added simplejson module for openstack container
command to work with swiftclient

Also bumped all kubectl versions to 1.31.0

Change-Id: I30a160fa8d352f2e0d0c544991159c672b190381
2024-09-19 20:27:25 +00:00
..
Dockerfile.ubuntu_bionic Porthole upgrades 2023-06-23 18:48:26 +00:00
Dockerfile.ubuntu_focal k8s upgrade v1.31.0 2024-08-15 16:47:05 -04:00
Dockerfile.ubuntu_jammy Fixed swiftclient and updated kubeclient 2024-09-19 20:27:25 +00:00
README.md Editorial changes to documentation files 2019-12-16 09:21:19 -06:00

Mysqlclient-utility Container

This utility container allows Operations personnel to access MariaDB pods remotely to perform database functions. Authorized users in UCP Keystone RBAC will able to run queries through the utilscli helper.

Usage

Get into the utility pod using kubectl exec.

        kubectl exec -it <POD_NAME> -n utility /bin/bash

Testing Connectivity to Mariadb (Optional)

  1. Find the mariadb pod and its corresponding IP.
       kubectl get pods --all-namespaces | grep -i mariadb-server | awk '{print $1,$2}' \
       | while read a b ; do kubectl get pod $b -n $a -o wide
       done
  1. Connect to the indicated pod by providing the arguments specified for the CLI as shown below.
       kubectl exec <POD_NAME> -it -n utility -- mysql -h <IP> -u root -p<PASSWORD> \
              -e 'show databases;'

The output should resemble the following.

        >--------------------+\
        | Database           |\
        |--------------------|\
        | cinder             |\
        | glance             |\
        | heat               |\
        | horizon            |\
        | information_schema |\
        | keystone           |\
        | mysql              |\
        | neutron            |\
        | nova               |\
        | nova_api           |\
        | nova_cell0         |\
        | performance_schema |\
        +--------------------+\