WordPress 從 GKE 搬家到 DigitalOcean

GCP WordPress

在一開始想說要研究 K8S 又剛好要寫個 Blog,
因此把機器放在 GKE 所以就用了官方提供的範例腳本把 WordPress 架設完成,
但是因為 GKE 需要用到負載平衡這部分一個月大概需要 10 美金到 20 美金,
不過我這邊沒有這麼大的流量就想說省點錢,
就開始搬家計畫拉!

首先要搬家就要先備份資料,
因為對於 K8S 的不熟,
一開始還直接到機器把掛載的資料夾拉出來 XD,
想想真的滿蠢的 …
在這邊教大家用比較簡單的方法備份機器

  1. 首先先使用指令 kubectl get all 找到你的 Service,這邊範例是 wordpress-0000000000-AAAAA

    clarence$ kubectl get all
    NAME READY STATUS RESTARTS AGE
    pod/mysql-0000000000-AAAAA 1/1 Running 0 6d
    pod/wordpress-0000000000-AAAAA 1/1 Running 0 6d
    NAME TYPE CLUSTER-IP EXTERNAL-IP PORT(S) AGE
    service/kubernetes ClusterIP 10.0.0.0 <none> 443/TCP 1y
    service/mysql ClusterIP 10.0.0.0 <none> 3306/TCP 1y
    service/wordpress LoadBalancer 10.0.0.0 35.197.0.0 80:31737/TCP 1y
    NAME DESIRED CURRENT UP-TO-DATE AVAILABLE AGE
    deployment.apps/mysql 1 1 1 1 1y
    deployment.apps/wordpress 1 1 1 1 1y
    NAME DESIRED CURRENT READY AGE
    replicaset.apps/mysql-0000000000 1 1 1 1y
    replicaset.apps/wordpress-0000000000 1 1 1 1y
    view raw bash-1.sh hosted with ❤ by GitHub

  2. WordPress 備份資料到本地

    kubectl cp wordpress-0000000000-AAAAA:/var/www/html/ Downloads/var/www/html/
    view raw bash-2.sh hosted with ❤ by GitHub

  3. 把 mysql 做一個反向連線到本地

    kubectl port-forward service/mysql 3306:3306
    view raw bash-3.sh hosted with ❤ by GitHub


    PS: 版主在這邊遇到一個 mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109) 的問題,詳細可以看一下 https://serverfault.com/questions/912162/mysqldump-throws-unknown-table-column-statistics-in-information-schema-1109
  4. 使用 mysqldump 把資料庫整個備份到本地

    mysqldump --column-statistics=0 -h 127.0.0.1 -uroot -p -A --default-character-set=utf8 > mysql.sql
    view raw bash-4.sh hosted with ❤ by GitHub


    到這邊備份就已經結束拉 ~
  5. 再來把新機器安裝好把需要安裝的東西裝進去

    clarence@ubuntu:~$ sudo apt update
    clarence@ubuntu:~$ sudo apt install nginx
    clarence@ubuntu:~$ sudo apt install mysql-server
    clarence@ubuntu:~$ sudo mysql_secure_installation
    clarence@ubuntu:~$ sudo apt install php-fpm php-mysql php-curl php-gd php-intl php-mbstring php-soap php-xml php-xmlrpc php-zip
    view raw bash-5.sh hosted with ❤ by GitHub

  6. 把 Nginx 設定好

    clarence@ubuntu:~$ sudo vim /etc/nginx/sites-available/blog.com.tw
    clarence@ubuntu:~$ sudo ln -s /etc/nginx/sites-available/blog.com.tw /etc/nginx/sites-enabled/
    clarence@ubuntu:~$ sudo nginx -t
    clarence@ubuntu:~$ sudo systemctl reload nginx
    clarence@ubuntu:~$ sudo chown -R www-data:www-data /var/www/wordpress
    view raw bash-6.sh hosted with ❤ by GitHub

  7. 修改一下 WordPress 的 DB 設定

    clarence@ubuntu:~$ vim wp-config.php
    /** MySQL hostname */
    define('DB_HOST', '127.0.0.1:3306');
    view raw bash-7.sh hosted with ❤ by GitHub

  8. 把 Mysql 資料庫推回去,順便檢查一下是否有這個資料庫

    clarence@ubuntu:~/Download$ sudo mysql < mysql.sql
    [sudo] password for clarence:
    clarence@ubuntu:~/Download$ sudo mysql
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 1
    Server version: 5.7.25-0ubuntu0.18.04.2 (Ubuntu)
    Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    mysql> SHOW DATABASES;
    +---------------------+
    | Database |
    +---------------------+
    | information_schema |
    | #mysql50 |
    | mysql |
    | performance_schema |
    | sys |
    | wordpress |
    +---------------------+
    6 rows in set (0.00 sec)
    mysql> exit
    Bye
    view raw bash-8.sh hosted with ❤ by GitHub


    PS: 版主在這邊遇到一個 Mysql 升級的問題,所以需要把資料庫更新一下,大家可以嘗試一下,詳細的問題如:https://stackoverflow.com/questions/43846950/column-count-of-mysql-user-is-wrong-expected-42-found-44-the-table-is-probabl

基本上這樣應該就搞定拉 ~ 我當時在做的時候花了我快一天的時間,可見對 K8S 有多不熟 XD
以上經驗分享給大家 ~