背景

管理数据库的界面工具。

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

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

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

即可进入：

小结

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

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

巴特西

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

背景

本地docker安装

k8s安装

小结

最新文章

热门文章