apt  install -y apt-transport-https ca-certificates curl gnupg lsb-release software-properties-common

mkdir -p /etc/apt/keyringscurl -fsSL https://mirrors.aliyun.com/docker-ce/linux/ubuntu/gpg | sudo gpg --dearmor -o /etc/apt/keyrings/docker-archive-keyring.gpg

echo "deb [arch=$(dpkg --print-architecture) signed-by=/etc/apt/keyrings/docker-archive-keyring.gpg] https://mirrors.aliyun.com/docker-ce/linux/ubuntu $(lsb_release -cs) stable" | sudo tee /etc/apt/sources.list.d/docker.list > /dev/null

root@jeven01:~# apt updateHit:1 https://mirrors.aliyun.com/ubuntu jammy InReleaseHit:2 https://mirrors.aliyun.com/ubuntu jammy-security InReleaseHit:3 https://mirrors.aliyun.com/ubuntu jammy-updates InReleaseHit:4 https://mirrors.aliyun.com/ubuntu jammy-backports InReleaseHit:5 https://mirrors.aliyun.com/docker-ce/linux/ubuntu jammy InReleaseReading package lists... DoneBuilding dependency tree... DoneReading state information... Done194 packages can be upgraded. Run 'apt list --upgradable' to see them.

apt  install -y docker-ce docker-ce-cli containerd.io docker-buildx-plugin docker-compose-plugin

mkdir -p /etc/docker

sudo  tee /etc/docker/daemon.json > /dev/null <<EOF{    "registry-mirrors": ["https://80c84f5330e14908928ca78944e61dc4.mirror.swr.myhuaweicloud.com"]}EOF

systemctl daemon-reloadsystemctl restart dockersystemctl enable  docker

root@jeven01:~# docker -vDocker version 28.1.1, build 4eba377

root@jeven01:~# docker compose versionDocker Compose version v2.35.1

systemctl status docker

curl --proto '=https' --tlsv1.2 -sSf https://tiup-mirrors.pingcap.com/install.sh | sh

source /root/.bashrc

tiup cluster

vim  /etc/ssh/sshd_config

MaxSessions 20

systemctl restart sshd

mkdir -p /data/tidb/{data,deploy} && cd /data/tidb

 vim topo.yaml

# # Global variables are applied to all deployments and used as the default value of# # the deployments if a specific deployment value is missing.global: user: "tidb" ssh_port: 22 deploy_dir: "/data/tidb/deploy" data_dir: "/data/tidb/data"
# # Monitored variables are applied to all the machines.monitored: node_exporter_port: 9100 blackbox_exporter_port: 9115
server_configs: tidb:   instance.tidb_slow_log_threshold: 300 tikv:   readpool.storage.use-unified-pool: false   readpool.coprocessor.use-unified-pool: true pd:   replication.enable-placement-rules: true   replication.location-labels: ["host"] tiflash:   logger.level: "info"
pd_servers: - host: 192.168.3.88
tidb_servers: - host: 192.168.3.88
tikv_servers: - host: 192.168.3.88   port: 20160   status_port: 20180   config:     server.labels: { host: "logic-host-1" }
 - host: 192.168.3.88   port: 20161   status_port: 20181   config:     server.labels: { host: "logic-host-2" }
 - host: 192.168.3.88   port: 20162   status_port: 20182   config:     server.labels: { host: "logic-host-3" }
tiflash_servers: - host: 192.168.3.88
monitoring_servers: - host: 192.168.3.88
grafana_servers: - host: 192.168.3.88

tiup list tidb 

tiup cluster deploy <cluster-name> <version> ./topo.yaml --user root -p

tiup cluster deploy cluster_tidb v8.5.1  ./topo.yaml --user root -p

tiup cluster start cluster_tidb --init

apt install mysql-server -y 

systemctl start mysqlsystemctl enable  mysql

mysql -h 192.168.3.88  -P 4000 -u root   -pTy7^e5q*4c68j9_-Cx

CREATE USER 'tidb'@'%' IDENTIFIED BY 'tidb';

GRANT ALL PRIVILEGES ON *.* TO 'tidb'@'%';

FLUSH PRIVILEGES;

CREATE DATABASE wordpress  DEFAULT CHARACTER SET utf8mb4  COLLATE utf8mb4_0900_ai_ci;

docker pull  wordpress

mkdir -p /data/wordpress/data && cd /data/wordpress

docker run -d --name my_wordpress --restart always   -v /data/wordpress/data:/var/www/html -e WORDPRESS_DB_HOST=192.168.3.88:4000   -e WORDPRESS_DB_USER=tidb   -e WORDPRESS_DB_PASSWORD="tidb"   -e WORDPRESS_DB_NAME=wordpress   -e WORDPRESS_DB_CHARSET=utf8mb4   -e WORDPRESS_DB_COLLATE=utf8mb4_0900_ai_ci   -p 8167:80   wordpress

vim docker-compose.yaml

version: '3.9'services:    wordpress:        image: wordpress        ports:            - '8167:80'        environment:            - WORDPRESS_DB_COLLATE=utf8mb4_0900_ai_ci            - WORDPRESS_DB_CHARSET=utf8mb4            - WORDPRESS_DB_NAME=wordpress            - WORDPRESS_DB_PASSWORD=tidb            - WORDPRESS_DB_USER=tidb            - WORDPRESS_DB_HOST=192.168.3.88:4000        volumes:            - '/data/wordpress/data:/var/www/html'        restart: always        container_name: my_wordpress

docker compose up -d

vim  data/wp-config.php

/** Database charset to use in creating database tables. */define('DB_CHARSET', 'utf8mb4');
/** The database collate type. Don't change this if in doubt. */define('DB_COLLATE', 'utf8mb4_0900_ai_ci');

docker compose restart

root@jeven01:/data/wordpress# docker psCONTAINER ID   IMAGE       COMMAND                  CREATED          STATUS          PORTS                                     NAMESe09d2cad6b58   wordpress   "docker-entrypoint.s…"   16 minutes ago   Up 30 seconds   0.0.0.0:8167->80/tcp, [::]:8167->80/tcp   my_wordpress

// 启用调试模式define('WP_DEBUG', true);// 将调试信息记录到日志文件define('WP_DEBUG_LOG', true);// 不在前端显示调试信息define('WP_DEBUG_DISPLAY', false);

root@jeven01:/data/wordpress# tail  data/wp-content/debug.logOR wp_posts.post_status = 'private')))
           ORDER BY wp_posts.post_date DESC           LIMIT 0, 20 made by WP_Posts_List_Table->prepare_items, wp_edit_posts_query, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts[28-May-2025 13:47:29 UTC] WordPress database error function SQL_CALC_FOUND_ROWS has only noop implementation in tidb now, use tidb_enable_noop_functions to enable these functions for query SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID           FROM wp_posts           WHERE 1=1  AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish'))
           ORDER BY wp_posts.post_date DESC           LIMIT 0, 20 made by WP_Posts_List_Table->prepare_items, wp_edit_posts_query, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

function SQL_CALC_FOUND_ROWS has only noop implementation in tidb now, use tidb_enable_noop_functions to enable these functions