phpMyAdmin给非技术人员一个查阅数据库的窗口

背景

管理数据库的界面工具。

开发团队中一般有非技术背景人员，比如： 产品，功能测试人员；

对他们来说，可能安装数据库管理工具客户端都很麻烦，需要一款在线的网页工具能方便他们查阅数据。

本地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

即可进入：

小结

替代客户端的一个统一管理数据库的工具。 网页版本更清凉。

原创不易，关注诚可贵，转发价更高！转载请注明出处，让我们互通有无，共同进步，欢迎沟通交流。