背景
管理数据库的界面工具。
开发团队中一般有非技术背景人员，比如： 产品，功能测试人员；
对他们来说，可能安装数据库管理工具客户端都很麻烦，需要一款在线的网页工具能方便他们查阅数据。
本地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初始化文件：
| $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 |
即可进入：
小结
替代客户端的一个统一管理数据库的工具。 网页版本更清凉。
