背景
管理数据库的界面工具。
开发团队中一般有非技术背景人员，比如： 产品，功能测试人员；
对他们来说，可能安装数据库管理工具客户端都很麻烦，需要一款在线的网页工具能方便他们查阅数据。
本地docker安装
单库：
docker run --name myadmin -d -e PMA_HOST=lifcHost -e PMA_PORT=3306 -e PMA_USER=root -e PMA_PASSWORD=Root1234 -p 9001:80 phpmyadmin
多库：
php初始化文件：
<?php
$server_hosts = array(
'1' => array('server_name' => 'lifcHost', 'host' => 'lifcHost', 'port' => 3306, 'user'=>'root', 'password' => 'Root1234'),
'2' => array('server_name' => 'dev', 'host' => '10.10.1.23', 'port' => 30099,'user'=>'root', 'password' => 'Cycube123!'),
'3' => array('server_name' => 'uat', 'host' => '10.10.1.23', 'port' => 30099,'user'=>'root', 'password' => 'Cycube123!')
);
foreach($server_hosts as $key => $sh)
{
$cfg['Servers'][$key]['verbose'] = $sh['server_name'];
$cfg['Servers'][$key]['auth_type'] = 'cookie';
$cfg['Servers'][$key]['host'] = $sh['host'];
$cfg['Servers'][$key]['user'] = $sh['user'];
$cfg['Servers'][$key]['port'] = $sh['port'];
$cfg['Servers'][$key]['password'] = $sh['password'];
$cfg['Servers'][$key]['connect_type'] = 'tcp';
$cfg['Servers'][$key]['compress'] = false;
$cfg['Servers'][$key]['extension'] = 'mysqli';
$cfg['Servers'][$key]['AllowNoPassword'] = false;
}
$cfg['ServerDefault'] = 1;
docker run --name myadmin -p 9001:80 -v d:/test/phpMyAdmin/config/config.user.inc.php:/etc/phpmyadmin/config.user.inc.php -d phpmyadmin
首页需要收入服务器的账号和密码。
k8s安装
---
apiVersion: v1
kind: ConfigMap
metadata:
name: configmap-phpmyadmin
data:
config.user.inc.php: |-
<?php
$server_hosts = array(
'1' => array('server_name' => 'prod', 'host' => 'sh-cdb-l5xxx.com', 'port' => 59153, 'user'=>'cyxxxe_read', 'password' => 'xxxxx'),
'2' => array('server_name' => 'dev', 'host' => '10.10.1.23', 'port' => 30099,'user'=>'root', 'password' => 'xxx123!')
);
foreach($server_hosts as $key => $sh)
{
$cfg['Servers'][$key]['verbose'] = $sh['server_name'];
$cfg['Servers'][$key]['auth_type'] = 'cookie';
$cfg['Servers'][$key]['host'] = $sh['host'];
$cfg['Servers'][$key]['user'] = $sh['user'];
$cfg['Servers'][$key]['port'] = $sh['port'];
$cfg['Servers'][$key]['password'] = $sh['password'];
$cfg['Servers'][$key]['connect_type'] = 'tcp';
$cfg['Servers'][$key]['compress'] = false;
$cfg['Servers'][$key]['extension'] = 'mysqli';
$cfg['Servers'][$key]['AllowNoPassword'] = false;
}
$cfg['ServerDefault'] = 1;
---
apiVersion: apps/v1
kind: Deployment
metadata:
name: phpmyadmin
namespace: tp
labels:
cycube: phpmyadmin
spec:
replicas: 1
revisionHistoryLimit: 10
selector:
matchLabels:
cycube: phpmyadmin
template:
metadata:
labels:
cycube: phpmyadmin
spec:
restartPolicy: Always
schedulerName: default-scheduler
dnsPolicy: ClusterFirst
terminationGracePeriodSeconds: 120
imagePullSecrets:
- name: ali-sh2-cycube-images
containers:
- image: phpmyadmin
name: phpmyadmin
imagePullPolicy: IfNotPresent
volumeMounts:
- name: phpmyadmin-volume
mountPath: /etc/phpmyadmin/config.user.inc.php
subPath: config.user.inc.php
resources:
limits:
cpu: 250m
memory: 512Mi
requests:
cpu: 125m
memory: 256Mi
ports:
- name: http
containerPort: 80
protocol: TCP
livenessProbe:
httpGet:
path: /
port: 80
scheme: HTTP
initialDelaySeconds: 120
periodSeconds: 30
readinessProbe:
httpGet:
path: /
port: 80
scheme: HTTP
initialDelaySeconds: 90
timeoutSeconds: 15
periodSeconds: 30
successThreshold: 1
failureThreshold: 5
volumes:
- name: phpmyadmin-volume
configMap:
name: configmap-phpmyadmin
items:
- key: config.user.inc.php
path: config.user.inc.php
---
apiVersion: v1
kind: Service
metadata:
name: svc-phpmyadmin-n
spec:
ports:
- name: phpmyadmin-port
port: 80
protocol: TCP
targetPort: 80
nodePort: 30401
selector:
cycube: phpmyadmin
sessionAffinity: None
type: NodePort
执行指令：
kubectl apply -f phpadmin.yml -n tp
即可进入：
小结
替代客户端的一个统一管理数据库的工具。 网页版本更清凉。
原创不易，关注诚可贵，转发价更高！转载请注明出处，让我们互通有无，共同进步，欢迎沟通交流。
