WordPress 数据迁移到Kubernetes (k8s)并配置持久化及网站域名修改

云计算 2023-08-10 贤蛋大眼萌 手机阅读

演示环境:http://i4t.cn 会始终保证可访问状态

架构说明

海外Nginx主要是解决域名需要备案的问题，frp为了解决家里Kubernetes集群没有公网IP，应用无法访问的问题。

WordPress镜像已经将Nginx和PHP封装在一起了，所以pod最好是运行2个，防止一个php资源请求处理不过来的问题。相关的插件安装配置最好使用一个Centos镜像用于导入导出

本次相关服务版本

  • Kubernetes 1.24
  • WordPress 6.2
  • Mysql 8

文中使用nfs作为默认sc存储引擎，之间的搭建说过太多次了，这里就是直接使用，不讲sc的创建和nfs的相关 配置

Mysql服务创建

我们先为WordPress创建一个ns命名空间

  1. <span>[</span>
<span>root@k8s</span>
<span>-</span>
<span>01</span>
<span> </span>
<span>~]#</span>
<span> kubectl create ns wordpress</span>

为mysql创建一个pvc存储

这里我已经有sc了，所以我直接创建pvc即可

  1. <span>[</span>
<span>root@k8s</span>
<span>-</span>
<span>01</span>
<span> wordpress</span>
<span>]#</span>
<span> cat mysql</span>
<span>-</span>
<span>pvc</span>
<span>.</span>
<span>yaml</span>
    2. 

  2. <span>apiVersion</span>
<span>:</span>
<span> v1</span>
    3. 

  3. <span>kind</span>
<span>:</span>
<span> </span>
<span>PersistentVolumeClaim</span>
    4. 

  4. <span>metadata</span>
<span>:</span>
    5. 

  5. <span>  name</span>
<span>:</span>
<span> mysql</span>
<span>-</span>
<span>pvc</span>
    6. 

  6. <span>  </span>
<span>namespace</span>
<span>:</span>
<span> wordpress</span>
    7. 

  7. <span>spec</span>
<span>:</span>
    8. 

  8. <span>  accessModes</span>
<span>:</span>
    9. 

  9. <span>    </span>
<span>-</span>
<span> </span>
<span>ReadWriteOnce</span>
    10. 

  10. <span>  resources</span>
<span>:</span>
    11. 

  11. <span>    requests</span>
<span>:</span>
    12. 

  12. <span>      storage</span>
<span>:</span>
<span> </span>
<span>50Gi</span>
    13. 

  13. <span>  storageClassName</span>
<span>:</span>
<span> nfs</span>
<span>-</span>
<span>storage</span>

创建mysql-pvc

  1. <span>[</span>
<span>root@k8s</span>
<span>-</span>
<span>01</span>
<span> wordpress</span>
<span>]#</span>
<span> kubectl apply </span>
<span>-</span>
<span>f mysql</span>
<span>-</span>
<span>pvc</span>
<span>.</span>
<span>yaml</span>
    2. 

  2. <span>persistentvolumeclaim</span>
<span>/</span>
<span>mysql</span>
<span>-</span>
<span>pvc created</span>
    3. 

  3. <span>[</span>
<span>root@k8s</span>
<span>-</span>
<span>01</span>
<span> wordpress</span>
<span>]#</span>
<span> kubectl </span>
<span>get</span>
<span> pvc </span>
<span>-</span>
<span>n wordpress</span>
<span>|</span>
<span>grep mysql</span>
<span>-</span>
<span>pvc</span>
    4. 

  4. <span>mysql</span>
<span>-</span>
<span>pvc   </span>
<span>Bound</span>
<span>    pvc</span>
<span>-</span>
<span>7812e224</span>
<span>-</span>
<span>b4fb</span>
<span>-</span>
<span>4a36</span>
<span>-</span>
<span>be2c</span>
<span>-</span>
<span>0fc36e161ddc</span>
<span>   </span>
<span>50Gi</span>
<span>       RWO            nfs</span>
<span>-</span>
<span>storage    </span>
<span>18s</span>
    5. 

  5. <span>[</span>
<span>root@k8s</span>
<span>-</span>
<span>01</span>
<span> wordpress</span>
<span>]#</span>

首先先创建mysql deployment服务

  1. <span>[</span>
<span>root@k8s</span>
<span>-</span>
<span>01</span>
<span> wordpress</span>
<span>]#</span>
<span> cat mysql</span>
<span>-</span>
<span>deployment</span>
<span>.</span>
<span>yaml</span>
    2. 

  2. <span>apiVersion</span>
<span>:</span>
<span> apps</span>
<span>/</span>
<span>v1</span>
    3. 

  3. <span>kind</span>
<span>:</span>
<span> </span>
<span>Deployment</span>
    4. 

  4. <span>metadata</span>
<span>:</span>
    5. 

  5. <span>  name</span>
<span>:</span>
<span> mysql</span>
    6. 

  6. <span>  </span>
<span>namespace</span>
<span>:</span>
<span> wordpress</span>
    7. 

  7. <span>  labels</span>
<span>:</span>
    8. 

  8. <span>    app</span>
<span>:</span>
<span> mysql</span>
    9. 

  9. <span>spec</span>
<span>:</span>
    10. 

  10. <span>  replicas</span>
<span>:</span>
<span> </span>
<span>1</span>
    11. 

  11. <span>  selector</span>
<span>:</span>
    12. 

  12. <span>    matchLabels</span>
<span>:</span>
    13. 

  13. <span>      app</span>
<span>:</span>
<span> mysql</span>
    14. 

  14. <span>  </span>
<span>template</span>
<span>:</span>
    15. 

  15. <span>    metadata</span>
<span>:</span>
    16. 

  16. <span>      labels</span>
<span>:</span>
    17. 

  17. <span>        app</span>
<span>:</span>
<span> mysql</span>
    18. 

  18. <span>    spec</span>
<span>:</span>
    19. 

  19. <span>      containers</span>
<span>:</span>
    20. 

  20. <span>      </span>
<span>-</span>
<span> name</span>
<span>:</span>
<span> mysql</span>
    21. 

  21. <span>        image</span>
<span>:</span>
<span> mysql</span>
<span>:</span>
<span>8.0</span>
    22. 

  22. <span>        args</span>
<span>:</span>
    23. 

  23. <span>           </span>
<span>-</span>
<span> </span>
<span>--</span>
<span>default_authentication_plugin</span>
<span>=</span>
<span>mysql_native_password</span>
    24. 

  24. <span>           </span>
<span>-</span>
<span> </span>
<span>--</span>
<span>character</span>
<span>-</span>
<span>set</span>
<span>-</span>
<span>server</span>
<span>=</span>
<span>utf8mb4</span>
    25. 

  25. <span>           </span>
<span>-</span>
<span> </span>
<span>--</span>
<span>collation</span>
<span>-</span>
<span>server</span>
<span>=</span>
<span>utf8mb4_unicode_ci</span>
    26. 

  26. <span>        env</span>
<span>:</span>
    27. 

  27. <span>        </span>
<span>-</span>
<span> name</span>
<span>:</span>
<span> MYSQL_ROOT_PASSWORD</span>
    28. 

  28. <span>          value</span>
<span>:</span>
<span> MYSQL_ROOT_PASSWORD      </span>
<span>#mysql密码，自行修改</span>
    29. 

  29. <span>        ports</span>
<span>:</span>
    30. 

  30. <span>        </span>
<span>-</span>
<span> containerPort</span>
<span>:</span>
<span> </span>
<span>3306</span>
    31. 

  31. <span>        volumeMounts</span>
<span>:</span>
    32. 

  32. <span>        </span>
<span>-</span>
<span> mountPath</span>
<span>:</span>
<span> </span>
<span>"/var/lib/mysql"</span>
    33. 

  33. <span>          name</span>
<span>:</span>
<span> mysql</span>
<span>-</span>
<span>data</span>
    34. 

  34. <span>        livenessProbe</span>
<span>:</span>
    35. 

  35. <span>          </span>
<span>exec</span>
<span>:</span>
    36. 

  36. <span>           command</span>
<span>:</span>
    37. 

  37. <span>              </span>
<span>-</span>
<span> sh</span>
    38. 

  38. <span>              </span>
<span>-</span>
<span> </span>
<span>'-c'</span>
    39. 

  39. <span>              </span>
<span>-</span>
<span> </span>
<span>'mysqladmin ping -u root -p${MYSQL_ROOT_PASSWORD}'</span>
    40. 

  40. <span>      volumes</span>
<span>:</span>
    41. 

  41. <span>      </span>
<span>-</span>
<span> name</span>
<span>:</span>
<span> mysql</span>
<span>-</span>
<span>data</span>
    42. 

  42. <span>        persistentVolumeClaim</span>
<span>:</span>
    43. 

  43. <span>          claimName</span>
<span>:</span>
<span> mysql</span>
<span>-</span>
<span>pvc    </span>
<span>#创建mysql-pvc</span>

进入mysql容器，开启connection_control.so插件

如果不开启，后面mysql日志会有大量警告日志

  1. <span>[</span>
<span>root@k8s</span>
<span>-</span>
<span>01</span>
<span> wordpress</span>
<span>]#</span>
<span> kubectl </span>
<span>exec</span>
<span> </span>
<span>-</span>
<span>it </span>
<span>-</span>
<span>n wordpress mysql</span>
<span>-</span>
<span>7fddbb85bb</span>
<span>-</span>
<span>xzcmf bash</span>
    2. 

  2. <span>kubectl </span>
<span>exec</span>
<span> </span>
<span>[</span>
<span>POD</span>
<span>]</span>
<span> </span>
<span>[</span>
<span>COMMAND</span>
<span>]</span>
<span> </span>
<span>is</span>
<span> DEPRECATED </span>
<span>and</span>
<span> will be removed </span>
<span>in</span>
<span> a future version</span>
<span>.</span>
<span> </span>
<span>Use</span>
<span> kubectl </span>
<span>exec</span>
<span> </span>
<span>[</span>
<span>POD</span>
<span>]</span>
<span> </span>
<span>--</span>
<span> </span>
<span>[</span>
<span>COMMAND</span>
<span>]</span>
<span> instead</span>
<span>.</span>
    3. 

  3. <span>bash</span>
<span>-</span>
<span>4.4</span>
<span># mysql -uroot -p</span>
    4. 

    5. 

  5. <span>#下面执行sql语句</span>
    6. 

  6. <span>mysql</span>
<span>></span>
<span> INSTALL PLUGIN CONNECTION_CONTROL SONAME </span>
<span>'connection_control.so'</span>
<span>;</span>
    7. 

  7. <span>Query</span>
<span> OK</span>
<span>,</span>
<span> </span>
<span>0</span>
<span> rows affected </span>
<span>(</span>
<span>0.00</span>
<span> sec</span>
<span>)</span>
    8. 

    9. 

  9. <span>mysql</span>
<span>></span>
<span> INSTALL PLUGIN CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS SONAME </span>
<span>'connection_control.so'</span>
<span>;</span>
    10. 

  10. <span>Query</span>
<span> OK</span>
<span>,</span>
<span> </span>
<span>0</span>
<span> rows affected </span>
<span>(</span>
<span>0.00</span>
<span> sec</span>
<span>)</span>

mysql-svc yaml文件如下

  1. <span>[</span>
<span>root@k8s</span>
<span>-</span>
<span>01</span>
<span> wordpress</span>
<span>]#</span>
<span> cat mysql</span>
<span>-</span>
<span>svc</span>
<span>.</span>
<span>yaml</span>
    2. 

  2. <span>apiVersion</span>
<span>:</span>
<span> v1</span>
    3. 

  3. <span>kind</span>
<span>:</span>
<span> </span>
<span>Service</span>
    4. 

  4. <span>metadata</span>
<span>:</span>
    5. 

  5. <span>  name</span>
<span>:</span>
<span> mysql</span>
    6. 

  6. <span>  </span>
<span>namespace</span>
<span>:</span>
<span> wordpress</span>
    7. 

  7. <span>spec</span>
<span>:</span>
    8. 

  8. <span>  selector</span>
<span>:</span>
    9. 

  9. <span>    app</span>
<span>:</span>
<span> mysql</span>
    10. 

  10. <span>  ports</span>
<span>:</span>
    11. 

  11. <span>    </span>
<span>-</span>
<span> protocol</span>
<span>:</span>
<span> TCP</span>
    12. 

  12. <span>      port</span>
<span>:</span>
<span> </span>
<span>3306</span>
    13. 

  13. <span>      targetPort</span>
<span>:</span>
<span> </span>
<span>3306</span>
    14. 

  14. <span>      nodePort</span>
<span>:</span>
<span> </span>
<span>31306</span>
    15. 

  15. <span>  type</span>
<span>:</span>
<span> </span>
<span>NodePort</span>

创建mysql-svc

  1. <span>[</span>
<span>root@k8s</span>
<span>-</span>
<span>01</span>
<span> wordpress</span>
<span>]#</span>
<span> vim mysql</span>
<span>-</span>
<span>svc</span>
<span>.</span>
<span>yaml</span>
    2. 

  2. <span>[</span>
<span>root@k8s</span>
<span>-</span>
<span>01</span>
<span> wordpress</span>
<span>]#</span>
<span> kubectl apply </span>
<span>-</span>
<span>f mysql</span>
<span>-</span>
<span>svc</span>
<span>.</span>
<span>yaml</span>
    3. 

  3. <span>service</span>
<span>/</span>
<span>mysql created</span>
    4. 

  4. <span>[</span>
<span>root@k8s</span>
<span>-</span>
<span>01</span>
<span> wordpress</span>
<span>]#</span>
    5. 

  5. <span>[</span>
<span>root@k8s</span>
<span>-</span>
<span>01</span>
<span> wordpress</span>
<span>]#</span>
<span> kubectl </span>
<span>get</span>
<span> svc </span>
<span>-</span>
<span>n wordpress </span>
<span>|</span>
<span>grep mysql</span>
    6. 

  6. <span>mysql   </span>
<span>NodePort</span>
<span>   </span>
<span>10.102</span>
<span>.</span>
<span>12.169</span>
<span>   </span>
<span><none></span>
<span>        </span>
<span>3306</span>
<span>:</span>
<span>31306</span>
<span>/</span>
<span>TCP   </span>
<span>6s</span>

创建WordPress服务

接下来运行WordPress容器

为WordPress创建一个pvc

  1. <span>[</span>
<span>root@k8s</span>
<span>-</span>
<span>01</span>
<span> wordpress</span>
<span>]#</span>
<span> cat wp</span>
<span>-</span>
<span>pvc</span>
<span>.</span>
<span>yaml</span>
    2. 

  2. <span>apiVersion</span>
<span>:</span>
<span> v1</span>
    3. 

  3. <span>kind</span>
<span>:</span>
<span> </span>
<span>PersistentVolumeClaim</span>
    4. 

  4. <span>metadata</span>
<span>:</span>
    5. 

  5. <span>  name</span>
<span>:</span>
<span> wp</span>
<span>-</span>
<span>pvc</span>
    6. 

  6. <span>  </span>
<span>namespace</span>
<span>:</span>
<span> wordpress</span>
    7. 

  7. <span>spec</span>
<span>:</span>
    8. 

  8. <span>  accessModes</span>
<span>:</span>
    9. 

  9. <span>    </span>
<span>-</span>
<span> </span>
<span>ReadWriteOnce</span>
    10. 

  10. <span>  resources</span>
<span>:</span>
    11. 

  11. <span>    requests</span>
<span>:</span>
    12. 

  12. <span>      storage</span>
<span>:</span>
<span> </span>
<span>50Gi</span>
    13. 

  13. <span>  storageClassName</span>
<span>:</span>
<span> nfs</span>
<span>-</span>
<span>storage</span>

接下来我们要到数据库中，创建mysql 对应库和用户数据

  1. <span>CREATE DATABASE abcdocker DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci</span>
<span>;</span>
    2. 

  2. <span>create user </span>
<span>'i4t'</span>
<span>@</span>
<span>'%'</span>
<span> identified </span>
<span>by</span>
<span> </span>
<span>'abcdocker'</span>
<span>;</span>
    3. 

  3. <span>grant all privileges on </span>
<span>*.*</span>
<span> to </span>
<span>'i4t'</span>
<span>@</span>
<span>'%'</span>
<span>;</span>
    4. 

    5. 

  5. <span>#这里可以根据需求自行创建</span>
    6. 

  6. <span>#我这里的数据库名称为abcdocker，用户为i4t</span>

因为wordpress是php文件，后面可能会调整php的配置，我们需要为wordpress-deplpoyment创建一个configmap，用于php参数的调整

  1. <span>[</span>
<span>root@k8s</span>
<span>-</span>
<span>01</span>
<span> wordpress</span>
<span>]#</span>
<span> cat wordpress</span>
<span>-</span>
<span>configmap</span>
<span>.</span>
<span>yaml</span>
    2. 

  2. <span>apiVersion</span>
<span>:</span>
<span> v1</span>
    3. 

  3. <span>kind</span>
<span>:</span>
<span> </span>
<span>ConfigMap</span>
    4. 

  4. <span>metadata</span>
<span>:</span>
    5. 

  5. <span>  name</span>
<span>:</span>
<span> wordpress</span>
<span>-</span>
<span>configmap</span>
    6. 

  6. <span>  </span>
<span>namespace</span>
<span>:</span>
<span> wordpress</span>
    7. 

  7. <span>data</span>
<span>:</span>
    8. 

  8. <span>  uploads</span>
<span>.</span>
<span>ini</span>
<span>:</span>
<span> </span>
<span>|</span>
    9. 

  9. <span>    file_uploads </span>
<span>=</span>
<span> </span>
<span>On</span>
    10. 

  10. <span>    memory_limit </span>
<span>128M</span>
    11. 

  11. <span>    upload_max_filesize </span>
<span>64M</span>
    12. 

  12. <span>    post_max_size </span>
<span>64M</span>
    13. 

  13. <span>    max_execution_time </span>
<span>300</span>
    14. 

  14. <span>    max_input_time </span>
<span>300</span>
    15. 

  15. <span>  WORDPRESS_CONFIG_EXTRA</span>
<span>:</span>
<span> </span>
<span>|</span>
    16. 

  16. <span>    define</span>
<span>(</span>
<span>'WP_MEMORY_LIMIT'</span>
<span>,</span>
<span> </span>
<span>'64M'</span>
<span>);</span>
    17. 

  17. <span>    </span>
<span>@ini_set</span>
<span>(</span>
<span> </span>
<span>'upload_max_size'</span>
<span>,</span>
<span> </span>
<span>'64M'</span>
<span> </span>
<span>);</span>
    18. 

  18. <span>    </span>
<span>@ini_set</span>
<span>(</span>
<span> </span>
<span>'post_max_size'</span>
<span>,</span>
<span> </span>
<span>'64M'</span>
<span>);</span>
    19. 

  19. <span>    </span>
<span>@ini_set</span>
<span>(</span>
<span> </span>
<span>'max_execution_time'</span>
<span>,</span>
<span> </span>
<span>'300'</span>
<span> </span>
<span>);</span>

WordPress-deployment文件如下

  1. <span>apiVersion</span>
<span>:</span>
<span> apps</span>
<span>/</span>
<span>v1</span>
    2. 

  2. <span>kind</span>
<span>:</span>
<span> </span>
<span>Deployment</span>
    3. 

  3. <span>metadata</span>
<span>:</span>
    4. 

  4. <span>  labels</span>
<span>:</span>
    5. 

  5. <span>    app</span>
<span>:</span>
<span> wordpress</span>
    6. 

  6. <span>  name</span>
<span>:</span>
<span> wordpress</span>
<span>-</span>
<span>deployment</span>
    7. 

  7. <span>  </span>
<span>namespace</span>
<span>:</span>
<span> wordpress</span>
    8. 

  8. <span>spec</span>
<span>:</span>
    9. 

  9. <span>  replicas</span>
<span>:</span>
<span> </span>
<span>1</span>
    10. 

  10. <span>  selector</span>
<span>:</span>
    11. 

  11. <span>    matchLabels</span>
<span>:</span>
    12. 

  12. <span>      app</span>
<span>:</span>
<span> wordpress</span>
    13. 

  13. <span>  </span>
<span>template</span>
<span>:</span>
    14. 

  14. <span>    metadata</span>
<span>:</span>
    15. 

  15. <span>      annotations</span>
<span>:</span>
    16. 

  16. <span>      labels</span>
<span>:</span>
    17. 

  17. <span>        app</span>
<span>:</span>
<span> wordpress</span>
    18. 

  18. <span>    spec</span>
<span>:</span>
    19. 

  19. <span>      containers</span>
<span>:</span>
    20. 

  20. <span>      </span>
<span>-</span>
<span> env</span>
<span>:</span>
    21. 

  21. <span>        </span>
<span>-</span>
<span> name</span>
<span>:</span>
<span> WORDPRESS_DB_HOST</span>
    22. 

  22. <span>          value</span>
<span>:</span>
<span> mysql</span>
    23. 

  23. <span>        </span>
<span>-</span>
<span> name</span>
<span>:</span>
<span> WORDPRESS_DB_NAME</span>
    24. 

  24. <span>          value</span>
<span>:</span>
<span> i4t</span>
    25. 

  25. <span>        </span>
<span>-</span>
<span> name</span>
<span>:</span>
<span> WORDPRESS_DB_USER</span>
    26. 

  26. <span>          value</span>
<span>:</span>
<span> i4t</span>
    27. 

  27. <span>        </span>
<span>-</span>
<span> name</span>
<span>:</span>
<span> WORDPRESS_DB_PASSWORD</span>
    28. 

  28. <span>          value</span>
<span>:</span>
<span> </span>
<span>MTZmYTU0Nz</span>
    29. 

  29. <span>        image</span>
<span>:</span>
<span> wordpress</span>
<span>:</span>
<span>6.2</span>
<span>-</span>
<span>apache</span>
    30. 

  30. <span>        imagePullPolicy</span>
<span>:</span>
<span> </span>
<span>IfNotPresent</span>
    31. 

  31. <span>        name</span>
<span>:</span>
<span> wordpress</span>
    32. 

  32. <span>        ports</span>
<span>:</span>
    33. 

  33. <span>        </span>
<span>-</span>
<span> containerPort</span>
<span>:</span>
<span> </span>
<span>80</span>
    34. 

  34. <span>          name</span>
<span>:</span>
<span> wordpress</span>
    35. 

  35. <span>          protocol</span>
<span>:</span>
<span> TCP</span>
    36. 

  36. <span>        volumeMounts</span>
<span>:</span>
    37. 

  37. <span>        </span>
<span>-</span>
<span> mountPath</span>
<span>:</span>
<span> </span>
<span>/var/</span>
<span>www</span>
<span>/</span>
<span>html</span>
    38. 

  38. <span>          name</span>
<span>:</span>
<span> wordpress</span>
<span>-</span>
<span>persistent</span>
<span>-</span>
<span>storage</span>
    39. 

  39. <span>        </span>
<span>-</span>
<span> mountPath</span>
<span>:</span>
<span> </span>
<span>/usr/</span>
<span>local</span>
<span>/</span>
<span>etc</span>
<span>/</span>
<span>php</span>
<span>/</span>
<span>conf</span>
<span>.</span>
<span>d</span>
<span>/</span>
<span>uploads</span>
<span>.</span>
<span>ini</span>
    40. 

  40. <span>          name</span>
<span>:</span>
<span> wordpress</span>
<span>-</span>
<span>configmap</span>
    41. 

  41. <span>          subPath</span>
<span>:</span>
<span> uploads</span>
<span>.</span>
<span>ini</span>
    42. 

  42. <span>      volumes</span>
<span>:</span>
    43. 

  43. <span>      </span>
<span>-</span>
<span> name</span>
<span>:</span>
<span> wordpress</span>
<span>-</span>
<span>persistent</span>
<span>-</span>
<span>storage</span>
    44. 

  44. <span>        persistentVolumeClaim</span>
<span>:</span>
    45. 

  45. <span>          claimName</span>
<span>:</span>
<span> wp</span>
<span>-</span>
<span>pvc</span>
    46. 

  46. <span>      </span>
<span>-</span>
<span> configMap</span>
<span>:</span>
    47. 

  47. <span>          defaultMode</span>
<span>:</span>
<span> </span>
<span>420</span>
    48. 

  48. <span>          name</span>
<span>:</span>
<span> wordpress</span>
<span>-</span>
<span>configmap</span>
    49. 

  49. <span>        name</span>
<span>:</span>
<span> wordpress</span>
<span>-</span>
<span>configmap</span>

请自行修改数据库的DB配置文件，根据需求修改

  1. <span>#相关变量，自行修改</span>
    2. 

  2. <span>        </span>
<span>-</span>
<span> name</span>
<span>:</span>
<span> WORDPRESS_DB_HOST</span>
    3. 

  3. <span>          value</span>
<span>:</span>
<span> mysql</span>
    4. 

  4. <span>        </span>
<span>-</span>
<span> name</span>
<span>:</span>
<span> WORDPRESS_DB_NAME</span>
    5. 

  5. <span>          value</span>
<span>:</span>
<span> i4t</span>
    6. 

  6. <span>        </span>
<span>-</span>
<span> name</span>
<span>:</span>
<span> WORDPRESS_DB_USER</span>
    7. 

  7. <span>          value</span>
<span>:</span>
<span> i4t</span>
    8. 

  8. <span>        </span>
<span>-</span>
<span> name</span>
<span>:</span>
<span> WORDPRESS_DB_PASSWORD</span>
    9. 

  9. <span>          value</span>
<span>:</span>
<span> </span>
<span>MTZmYTU0Nz</span>

svc 文件如下

  1. <span>[</span>
<span>root@k8s</span>
<span>-</span>
<span>01</span>
<span> wordpress</span>
<span>]#</span>
<span> cat wordpress</span>
<span>-</span>
<span>svc</span>
<span>.</span>
<span>yaml</span>
    2. 

  2. <span>apiVersion</span>
<span>:</span>
<span> v1</span>
    3. 

  3. <span>kind</span>
<span>:</span>
<span> </span>
<span>Service</span>
    4. 

  4. <span>metadata</span>
<span>:</span>
    5. 

  5. <span>  name</span>
<span>:</span>
<span> wordpress</span>
<span>-</span>
<span>svc</span>
    6. 

  6. <span>  </span>
<span>namespace</span>
<span>:</span>
<span> wordpress</span>
    7. 

  7. <span>spec</span>
<span>:</span>
    8. 

  8. <span>  selector</span>
<span>:</span>
    9. 

  9. <span>    app</span>
<span>:</span>
<span> wordpress</span>
    10. 

  10. <span>  ports</span>
<span>:</span>
    11. 

  11. <span>    </span>
<span>-</span>
<span> protocol</span>
<span>:</span>
<span> TCP</span>
    12. 

  12. <span>      port</span>
<span>:</span>
<span> </span>
<span>80</span>
    13. 

  13. <span>      targetPort</span>
<span>:</span>
<span> </span>
<span>80</span>
    14. 

  14. <span>      nodePort</span>
<span>:</span>
<span> </span>
<span>31307</span>
    15. 

  15. <span>  type</span>
<span>:</span>
<span> </span>
<span>NodePort</span>

接下来我们检查所有的服务启动状态

  1. <span>[</span>
<span>root@k8s</span>
<span>-</span>
<span>01</span>
<span> wordpress</span>
<span>]#</span>
<span> kubectl </span>
<span>get</span>
<span> pod</span>
<span>,</span>
<span>svc </span>
<span>-</span>
<span>n wordpress</span>
    2. 

  2. <span>NAME                                        READY   STATUS    RESTARTS   AGE</span>
    3. 

  3. <span>pod</span>
<span>/</span>
<span>mysql</span>
<span>-</span>
<span>7fddbb85bb</span>
<span>-</span>
<span>xzcmf                  </span>
<span>1</span>
<span>/</span>
<span>1</span>
<span>     </span>
<span>Running</span>
<span>   </span>
<span>0</span>
<span>          </span>
<span>46m</span>
    4. 

  4. <span>pod</span>
<span>/</span>
<span>wordpress</span>
<span>-</span>
<span>deployment</span>
<span>-</span>
<span>5665566b9b</span>
<span>-</span>
<span>cm82w   </span>
<span>1</span>
<span>/</span>
<span>1</span>
<span>     </span>
<span>Running</span>
<span>   </span>
<span>0</span>
<span>          </span>
<span>4m42s</span>
    5. 

    6. 

  6. <span>NAME                    TYPE       CLUSTER</span>
<span>-</span>
<span>IP      EXTERNAL</span>
<span>-</span>
<span>IP   PORT</span>
<span>(</span>
<span>S</span>
<span>)</span>
<span>          AGE</span>
    7. 

  7. <span>service</span>
<span>/</span>
<span>mysql           </span>
<span>NodePort</span>
<span>   </span>
<span>10.102</span>
<span>.</span>
<span>12.169</span>
<span>   </span>
<span><none></span>
<span>        </span>
<span>3306</span>
<span>:</span>
<span>31306</span>
<span>/</span>
<span>TCP   </span>
<span>19m</span>
    8. 

  8. <span>service</span>
<span>/</span>
<span>wordpress</span>
<span>-</span>
<span>svc   </span>
<span>NodePort</span>
<span>   </span>
<span>10.98</span>
<span>.</span>
<span>207.64</span>
<span>    </span>
<span><none></span>
<span>        </span>
<span>80</span>
<span>:</span>
<span>31307</span>
<span>/</span>
<span>TCP     </span>
<span>68s</span>
    9. 

  9. <span>[</span>
<span>root@k8s</span>
<span>-</span>
<span>01</span>
<span> wordpress</span>
<span>]#</span>
    10. 

  10. <span>[</span>
<span>root@k8s</span>
<span>-</span>
<span>01</span>
<span> wordpress</span>
<span>]#</span>
    11. 

  11. <span>[</span>
<span>root@k8s</span>
<span>-</span>
<span>01</span>
<span> wordpress</span>
<span>]#</span>
<span> curl </span>
<span>10.98</span>
<span>.</span>
<span>207.64</span>
<span> </span>
<span>-</span>
<span>I</span>
    12. 

  12. <span>HTTP</span>
<span>/</span>
<span>1.1</span>
<span> </span>
<span>302</span>
<span> </span>
<span>Found</span>
    13. 

  13. <span>Date</span>
<span>:</span>
<span> </span>
<span>Wed</span>
<span>,</span>
<span> </span>
<span>09</span>
<span> </span>
<span>Aug</span>
<span> </span>
<span>2023</span>
<span> </span>
<span>08</span>
<span>:</span>
<span>00</span>
<span>:</span>
<span>13</span>
<span> GMT</span>
    14. 

  14. <span>Server</span>
<span>:</span>
<span> </span>
<span>Apache</span>
<span>/</span>
<span>2.4</span>
<span>.</span>
<span>56</span>
<span> </span>
<span>(</span>
<span>Debian</span>
<span>)</span>
    15. 

  15. <span>X</span>
<span>-</span>
<span>Powered</span>
<span>-</span>
<span>By</span>
<span>:</span>
<span> PHP</span>
<span>/</span>
<span>8.0</span>
<span>.</span>
<span>29</span>
    16. 

  16. <span>Expires</span>
<span>:</span>
<span> </span>
<span>Wed</span>
<span>,</span>
<span> </span>
<span>11</span>
<span> </span>
<span>Jan</span>
<span> </span>
<span>1984</span>
<span> </span>
<span>05</span>
<span>:</span>
<span>00</span>
<span>:</span>
<span>00</span>
<span> GMT</span>
    17. 

  17. <span>Cache</span>
<span>-</span>
<span>Control</span>
<span>:</span>
<span> </span>
<span>no</span>
<span>-</span>
<span>cache</span>
<span>,</span>
<span> must</span>
<span>-</span>
<span>revalidate</span>
<span>,</span>
<span> max</span>
<span>-</span>
<span>age</span>
<span>=</span>
<span>0</span>
    18. 

  18. <span>X</span>
<span>-</span>
<span>Redirect</span>
<span>-</span>
<span>By</span>
<span>:</span>
<span> </span>
<span>WordPress</span>
    19. 

  19. <span>Location</span>
<span>:</span>
<span> http</span>
<span>:</span>
<span>//10.98.207.64/wp-admin/install.php</span>
    20. 

  20. <span>Content</span>
<span>-</span>
<span>Type</span>
<span>:</span>
<span> text</span>
<span>/</span>
<span>html</span>
<span>;</span>
<span> charset</span>
<span>=</span>
<span>UTF</span>
<span>-</span>
<span>8</span>

使用nodeport访问测试

我这里直接访问nodeport ip:端口测试

启动Centos容器

因为默认的WordPress容器没有vim,我们的站点目录都是挂载进去的。如果后期修改php文件比较麻烦，所以我们安装一个Centos client挂载wp-pvc，后续可以直接在Centos容器修改

  1. <span>[</span>
<span>root@k8s</span>
<span>-</span>
<span>01</span>
<span> wordpress</span>
<span>]#</span>
<span> cat centos</span>
<span>.</span>
<span>yaml</span>
    2. 

  2. <span>apiVersion</span>
<span>:</span>
<span> apps</span>
<span>/</span>
<span>v1</span>
    3. 

  3. <span>kind</span>
<span>:</span>
<span> </span>
<span>Deployment</span>
    4. 

  4. <span>metadata</span>
<span>:</span>
    5. 

  5. <span>  labels</span>
<span>:</span>
    6. 

  6. <span>    app</span>
<span>:</span>
<span> centos</span>
    7. 

  7. <span>  name</span>
<span>:</span>
<span> centos</span>
<span>-</span>
<span>client</span>
    8. 

  8. <span>  </span>
<span>namespace</span>
<span>:</span>
<span> wordpress</span>
    9. 

  9. <span>spec</span>
<span>:</span>
    10. 

  10. <span>  replicas</span>
<span>:</span>
<span> </span>
<span>1</span>
    11. 

  11. <span>  selector</span>
<span>:</span>
    12. 

  12. <span>    matchLabels</span>
<span>:</span>
    13. 

  13. <span>      app</span>
<span>:</span>
<span> centos</span>
    14. 

  14. <span>  </span>
<span>template</span>
<span>:</span>
    15. 

  15. <span>    metadata</span>
<span>:</span>
    16. 

  16. <span>      labels</span>
<span>:</span>
    17. 

  17. <span>        app</span>
<span>:</span>
<span> centos</span>
    18. 

  18. <span>    spec</span>
<span>:</span>
    19. 

  19. <span>      containers</span>
<span>:</span>
    20. 

  20. <span>        </span>
<span>-</span>
<span> args</span>
<span>:</span>
    21. 

  21. <span>            </span>
<span>-</span>
<span> </span>
<span>while</span>
<span> </span>
<span>true</span>
<span>;</span>
<span> </span>
<span>do</span>
<span> sleep </span>
<span>30</span>
<span>;</span>
<span> </span>
<span>done</span>
<span>;</span>
    22. 

  22. <span>          command</span>
<span>:</span>
    23. 

  23. <span>            </span>
<span>-</span>
<span> </span>
<span>/bin/</span>
<span>bash</span>
    24. 

  24. <span>            </span>
<span>-</span>
<span> </span>
<span>'-c'</span>
    25. 

  25. <span>            </span>
<span>-</span>
<span> </span>
<span>'--'</span>
    26. 

  26. <span>          image</span>
<span>:</span>
<span> centos</span>
<span>:</span>
<span>centos7</span>
<span>.</span>
<span>9.2009</span>
    27. 

  27. <span>          imagePullPolicy</span>
<span>:</span>
<span> </span>
<span>IfNotPresent</span>
    28. 

  28. <span>          name</span>
<span>:</span>
<span> centos</span>
    29. 

  29. <span>          securityContext</span>
<span>:</span>
    30. 

  30. <span>            privileged</span>
<span>:</span>
<span> </span>
<span>true</span>
    31. 

  31. <span>          volumeMounts</span>
<span>:</span>
    32. 

  32. <span>          </span>
<span>-</span>
<span> mountPath</span>
<span>:</span>
<span> </span>
<span>/</span>
<span>data</span>
    33. 

  33. <span>            name</span>
<span>:</span>
<span> wordpress</span>
<span>-</span>
<span>persistent</span>
<span>-</span>
<span>storage</span>
    34. 

  34. <span>      volumes</span>
<span>:</span>
    35. 

  35. <span>      </span>
<span>-</span>
<span> name</span>
<span>:</span>
<span> wordpress</span>
<span>-</span>
<span>persistent</span>
<span>-</span>
<span>storage</span>
    36. 

  36. <span>        persistentVolumeClaim</span>
<span>:</span>
    37. 

  37. <span>          claimName</span>
<span>:</span>
<span> wp</span>
<span>-</span>
<span>pvc</span>

迁移Mysql

我们从原来的服务器备份好Mysql数据，然后到新的服务器中导入进去

导入前可以drop database [业务库],把之前WordPress数据删除掉

  1. <span>#k8s节点安装mysql命令</span>
    2. 

  2. <span>[</span>
<span>root@k8s</span>
<span>-</span>
<span>01</span>
<span> tmp</span>
<span>]#</span>
<span> yum install </span>
<span>-</span>
<span>y mysql</span>
    3. 

    4. 

  4. <span>#找到sql文件</span>
    5. 

  5. <span>[</span>
<span>root@k8s</span>
<span>-</span>
<span>01</span>
<span> tmp</span>
<span>]#</span>
<span> ls</span>
    6. 

  6. <span>i4t_20230809_163531</span>
<span>.</span>
<span>sql  systemd</span>
<span>-</span>
<span>private</span>
<span>-</span>
<span>ecb644fe53cf473385f7a9ba14bea147</span>
<span>-</span>
<span>chronyd</span>
<span>.</span>
<span>service</span>
<span>-</span>
<span>ylF0Of  test</span>
<span>.</span>
<span>sh  vmware</span>
<span>-</span>
<span>root_733</span>
<span>-</span>
<span>4248680474</span>
    7. 

    8. 

  8. <span>#查看mysql svc ip</span>
    9. 

  9. <span>[</span>
<span>root@k8s</span>
<span>-</span>
<span>01</span>
<span> tmp</span>
<span>]#</span>
<span> kubectl </span>
<span>get</span>
<span> svc </span>
<span>-</span>
<span>n wordpress</span>
    10. 

  10. <span>NAME            TYPE       CLUSTER</span>
<span>-</span>
<span>IP      EXTERNAL</span>
<span>-</span>
<span>IP   PORT</span>
<span>(</span>
<span>S</span>
<span>)</span>
<span>          AGE</span>
    11. 

  11. <span>mysql           </span>
<span>NodePort</span>
<span>   </span>
<span>10.102</span>
<span>.</span>
<span>12.169</span>
<span>   </span>
<span><none></span>
<span>        </span>
<span>3306</span>
<span>:</span>
<span>31306</span>
<span>/</span>
<span>TCP   </span>
<span>129m</span>
    12. 

  12. <span>wordpress</span>
<span>-</span>
<span>svc   </span>
<span>NodePort</span>
<span>   </span>
<span>10.98</span>
<span>.</span>
<span>207.64</span>
<span>    </span>
<span><none></span>
<span>        </span>
<span>80</span>
<span>:</span>
<span>31307</span>
<span>/</span>
<span>TCP     </span>
<span>111m</span>
    13. 

    14. 

  14. <span>#登陆到mysql中</span>
    15. 

  15. <span>[</span>
<span>root@k8s</span>
<span>-</span>
<span>01</span>
<span> tmp</span>
<span>]#</span>
<span> mysql </span>
<span>-</span>
<span>uroot </span>
<span>-</span>
<span>p </span>
<span>-</span>
<span>h </span>
<span>10.102</span>
<span>.</span>
<span>12.169</span>
<span> </span>
<span>-</span>
<span>P3306</span>
    16. 

  16. <span>Enter</span>
<span> password</span>
<span>:</span>
    17. 

  17. <span>Welcome</span>
<span> to the </span>
<span>MariaDB</span>
<span> monitor</span>
<span>.</span>
<span>  </span>
<span>Commands</span>
<span> </span>
<span>end</span>
<span> </span>
<span>with</span>
<span> </span>
<span>;</span>
<span> </span>
<span>or</span>
<span> g</span>
<span>.</span>
    18. 

  18. <span>Your</span>
<span> </span>
<span>MySQL</span>
<span> connection id </span>
<span>is</span>
<span> </span>
<span>1044</span>
    19. 

  19. <span>Server</span>
<span> version</span>
<span>:</span>
<span> </span>
<span>8.0</span>
<span>.</span>
<span>34</span>
<span> </span>
<span>MySQL</span>
<span> </span>
<span>Community</span>
<span> </span>
<span>Server</span>
<span> </span>
<span>-</span>
<span> GPL</span>
    20. 

    21. 

  21. <span>Copyright</span>
<span> </span>
<span>(</span>
<span>c</span>
<span>)</span>
<span> </span>
<span>2000</span>
<span>,</span>
<span> </span>
<span>2018</span>
<span>,</span>
<span> </span>
<span>Oracle</span>
<span>,</span>
<span> </span>
<span>MariaDB</span>
<span> </span>
<span>Corporation</span>
<span> </span>
<span>Ab</span>
<span> </span>
<span>and</span>
<span> others</span>
<span>.</span>
    22. 

    23. 

  23. <span>Type</span>
<span> </span>
<span>'help;'</span>
<span> </span>
<span>or</span>
<span> </span>
<span>'h'</span>
<span> </span>
<span>for</span>
<span> help</span>
<span>.</span>
<span> </span>
<span>Type</span>
<span> </span>
<span>'c'</span>
<span> to clear the current input statement</span>
<span>.</span>
    24. 

    25. 

  25. <span>MySQL</span>
<span> </span>
<span>[(</span>
<span>none</span>
<span>)]></span>
<span> </span>
<span>use</span>
<span> i4t</span>
<span>;</span>
    26. 

  26. <span>Database</span>
<span> changed</span>
    27. 

  27. <span>MySQL</span>
<span> </span>
<span>[</span>
<span>i4t</span>
<span>]></span>
<span> show  tables</span>
<span>;</span>
    28. 

  28. <span>Empty</span>
<span> </span>
<span>set</span>
<span> </span>
<span>(</span>
<span>0.00</span>
<span> sec</span>
<span>)</span>
    29. 

    30. 

  30. <span>#写入数据</span>
    31. 

  31. <span>MySQL</span>
<span> </span>
<span>[</span>
<span>i4t</span>
<span>]></span>
<span> source </span>
<span>/</span>
<span>tmp</span>
<span>/</span>
<span>i4t_20230809_163531</span>
<span>.</span>
<span>sql</span>
<span>;</span>

写入完毕后

  1. <span>MySQL</span>
<span> </span>
<span>[</span>
<span>i4t</span>
<span>]></span>
<span> show tables</span>
<span>;</span>
    2. 

  2. <span>            </span>
<span>...</span>
    3. 

  3. <span>|</span>
<span> abc1_watu_master             </span>
<span>|</span>
    4. 

  4. <span>|</span>
<span> abc1_watu_question           </span>
<span>|</span>
    5. 

  5. <span>|</span>
<span> abc1_watu_takings            </span>
<span>|</span>
    6. 

  6. <span>|</span>
<span> abc1_wpmailsmtp_debug_events </span>
<span>|</span>
    7. 

  7. <span>|</span>
<span> abc1_wpmailsmtp_tasks_meta   </span>
<span>|</span>
    8. 

  8. <span>|</span>
<span> abc1_yarpp_related_cache     </span>
<span>|</span>
    9. 

  9. <span>|</span>
<span> abc1_zrz_card                </span>
<span>|</span>
    10. 

  10. <span>|</span>
<span> abc1_zrz_directmessage       </span>
<span>|</span>
    11. 

  11. <span>|</span>
<span> abc1_zrz_invitation          </span>
<span>|</span>
    12. 

  12. <span>|</span>
<span> abc1_zrz_message             </span>
<span>|</span>
    13. 

  13. <span>|</span>
<span> abc1_zrz_order               </span>
<span>|</span>
    14. 

  14. <span>+-----------------------------+</span>
    15. 

  15. <span>49</span>
<span> rows </span>
<span>in</span>
<span> </span>
<span>set</span>
<span> </span>
<span>(</span>
<span>0.00</span>
<span> sec</span>
<span>)</span>

修改域名，需要及时修改域名，否则系统会跳转为正式环境

  • 旧域名https://i4t.com
  • 新域名http://i4t.cn
  1. <span>UPDATE wp_options SET option_value </span>
<span>=</span>
<span> replace</span>
<span>(</span>
<span>option_value</span>
<span>,</span>
<span> </span>
<span>'https://i4t.com'</span>
<span>,</span>
<span> </span>
<span>'http://i4t.cn'</span>
<span>)</span>
<span> WHERE option_name </span>
<span>=</span>
<span> </span>
<span>'home'</span>
<span> OR option_name </span>
<span>=</span>
<span> </span>
<span>'siteurl'</span>
<span>;</span>
    2. 

  2. <span>UPDATE wp_posts SET guid </span>
<span>=</span>
<span> replace</span>
<span>(</span>
<span>guid</span>
<span>,</span>
<span> </span>
<span>'https://i4t.com'</span>
<span>,</span>
<span>'http:// .newurl'</span>
<span>);</span>
    3. 

  3. <span>UPDATE wp_posts SET post_content </span>
<span>=</span>
<span> replace</span>
<span>(</span>
<span>post_content</span>
<span>,</span>
<span> </span>
<span>'https://i4t.com'</span>
<span>,</span>
<span> </span>
<span>'http://i4t.cn'</span>
<span>);</span>
    4. 

  4. <span>UPDATE wp_postmeta SET meta_value </span>
<span>=</span>
<span> replace</span>
<span>(</span>
<span>meta_value</span>
<span>,</span>
<span>'https://i4t.com'</span>
<span>,</span>
<span>'http://i4t.cn'</span>
<span>);</span>
    5. 

  5. <span>UPDATE wp_usermeta SET meta_value </span>
<span>=</span>
<span> replace</span>
<span>(</span>
<span>meta_value</span>
<span>,</span>
<span> </span>
<span>'https://i4t.com'</span>
<span>,</span>
<span> </span>
<span>'http://i4t.cn'</span>
<span>);</span>
    6. 

  6. <span>UPDATE wp_comments SET comment_content </span>
<span>=</span>
<span> REPLACE </span>
<span>(</span>
<span>comment_content</span>
<span>,</span>
<span> </span>
<span>'https://i4t.com'</span>
<span>,</span>
<span> </span>
<span>'http://i4t.cn'</span>
<span>);</span>
    7. 

  7. <span>UPDATE wp_comments SET comment_author_url </span>
<span>=</span>
<span> REPLACE </span>
<span>(</span>
<span>comment_author_url</span>
<span>,</span>
<span> </span>
<span>'https://i4t.com'</span>
<span>,</span>
<span>'http://i4t.cn'</span>
<span>);</span>

迁移主题及静态文件

主题静态文件、插件、附件实际上都在我们wp-content目录下，直接将这个目录打包，然后替换到容器上就可以了。

  1. <span>#拷贝名称为web_i4t.com_20230809_013207.tar.gz 附件</span>
    2. 

  2. <span>kubectl cp web_i4t</span>
<span>.</span>
<span>com_20230809_013207</span>
<span>.</span>
<span>tar</span>
<span>.</span>
<span>gz </span>
<span>-</span>
<span>n wordpress centos</span>
<span>-</span>
<span>client</span>
<span>-</span>
<span>75f686d587</span>
<span>-</span>
<span>lv2b2</span>
<span>:</span>
<span>/data/</span>
    3. 

  3. <span>kubectl </span>
<span>exec</span>
<span> </span>
<span>-</span>
<span>it </span>
<span>-</span>
<span>n wordpress centos</span>
<span>-</span>
<span>client</span>
<span>-</span>
<span>75f686d587</span>
<span>-</span>
<span>lv2b2 bash</span>

最终迁移访问效果图