7b8f9d6147
Edited and revised formatting to improve readability and consistency with other docs in this repo. Change-Id: I8693b85fdbd84e625e774ae0fe4d81dae7d74a57
53 lines
1.4 KiB
Markdown
53 lines
1.4 KiB
Markdown
# 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
|
|
```
|
|
|
|
2. 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 |\
|
|
+--------------------+\
|
|
```
|