# tar xf mysql-8.0.25-linux-glibc2.12-x86_64.tar<\/p>\n\n\n\n
# tar Jxf mysql-8.0.25-linux-glibc2.12-x86_64.tar.xz -C \/opt\/<\/p>\n\n\n\n
# mv \/opt\/mysql-8.0.25-linux-glibc2.12-x86_64\/ \/opt\/mysql<\/p>\n\n\n\n
# for ((i=6;i<=8;i++));do ssh 192.168.23.$i “useradd -s \/sbin\/nologin -M mysql;mkdir -p \/database\/mysql;chown -R mysql:mysql \/database\/mysql”;done<\/p>\n\n\n\n
#for ((i=7;i<=8;i++));do scp -r \/opt\/mysql root@192.168.23.$i:\/opt\/;done<\/p>\n\n\n\n
# for ((i=6;i<=8;i++));do ssh root@192.168.23.$i “\/opt\/mysql\/bin\/mysqld –initialize-insecure –basedir=\/opt\/mysql –datadir=\/database\/mysql –user=mysql”;done<\/p>\n\n\n\n
# for ((i=7;i<=8;i++));do ssh root@192.168.23.$i “cat \/opt\/mysql\/support-files\/mysql.server |sed ‘\/^basedir=\/s\/\\(.*\\)\/\\1\\\/opt\\\/mysql\/;\/^datadir=\/s\/\\(.*\\)\/\\1\\\/database\\\/mysql\/’ >\/etc\/init.d\/mysql;chmod 755 \/etc\/init.d\/mysql;ln -svf \/usr\/lib64\/libtinfo.so.6 \/usr\/lib64\/libtinfo.so.5”;done<\/p>\n\n\n\n
3.\u914d\u7f6emy.cnf<\/p>\n\n\n\n
\u8282\u70b9A:<\/p>\n\n\n\n
my.cnf\u914d\u7f6e\uff1a<\/p>\n\n\n\n
[mysql]<\/p>\n\n\n\n
default-character-set=utf8mb4<\/p>\n\n\n\n
[mysqlshow]<\/p>\n\n\n\n
default-character-set=utf8mb4<\/p>\n\n\n\n
[mysqlimport]<\/p>\n\n\n\n
default-character-set=utf8mb4<\/p>\n\n\n\n
[mysqlcheck]<\/p>\n\n\n\n
default-character-set=utf8mb4<\/p>\n\n\n\n
[mysql_upgrade]<\/p>\n\n\n\n
default-character-set=utf8mb4<\/p>\n\n\n\n
[mysqltest]<\/p>\n\n\n\n
default-character-set=utf8mb4<\/p>\n\n\n\n
[mysqld]<\/p>\n\n\n\n
auto_increment_increment = 1<\/p>\n\n\n\n
auto_increment_offset = 1<\/p>\n\n\n\n
connect-timeout = 60<\/p>\n\n\n\n
enforce-gtid-consistency<\/p>\n\n\n\n
gtid-mode = on<\/p>\n\n\n\n
innodb-buffer-pool-size = 24M<\/p>\n\n\n\n
innodb-log-file-size = 5M<\/p>\n\n\n\n
log-bin = server-binary-log<\/p>\n\n\n\n
log-bin-trust-function-creators = 1<\/p>\n\n\n\n
loose-group_replication_enforce_update_everywhere_checks =FALSE<\/p>\n\n\n\n
loose-group_replication_group_name = ’85de4f4d-b40b-495f-bb85-6d5d6b4bc3e0′<\/p>\n\n\n\n
loose-group_replication_group_seeds = ‘192.168.23.6:33061,192.168.23.7:33061,192.168.23.8:33061’<\/p>\n\n\n\n
loose-group_replication_local_address = ‘192.168.23.6:33061’<\/p>\n\n\n\n
loose-group_replication_recovery_get_public_key = TRUE<\/p>\n\n\n\n
loose-group_replication_single_primary_mode =TRUE<\/p>\n\n\n\n
loose-group_replication_start_on_boot = OFF<\/p>\n\n\n\n
loose-innodb_read_io_threads = 1<\/p>\n\n\n\n
loose-innodb_write_io_threads = 1<\/p>\n\n\n\n
master-retry-count = 10<\/p>\n\n\n\n
plugin_load_add = ‘group_replication.so’#(\u76f8\u5f53\u4e8emysql> INSTALL PLUGIN group_replication SONAME ‘group_replication.so’;)<\/p>\n\n\n\n
relay-log = server-relay-log<\/p>\n\n\n\n
report-host = 192.168.23.6<\/p>\n\n\n\n
report-user = root<\/p>\n\n\n\n
server-id = 6<\/p>\n\n\n\n
skip-slave-start<\/p>\n\n\n\n
slave-load-tmpdir = \/tmp<\/p>\n\n\n\n
\u8282\u70b9B\u548c\u8282\u70b9C\u628a\u6a59\u8272\u5185\u5bb9\u4e2dIP\u5730\u5740\u548cid\u66ff\u6362\u6389\u3002<\/p>\n\n\n\n
4.\u542f\u52a8mysql\u670d\u52a1<\/p>\n\n\n\n
\u8282\u70b9A\u3001B\u3001C\u90fd\u6267\u884c\uff1a<\/p>\n\n\n\n
# service mysql start<\/p>\n\n\n\n
5.\u4fee\u6539root\u5bc6\u7801\uff0c\u8bbe\u7f6e\u8fde\u63a5\u8d26\u6237repl\u548cicadmin\u8d26\u6237<\/p>\n\n\n\n
\u8282\u70b9A\u3001B\u3001C\u90fd\u6267\u884c\uff1a<\/p>\n\n\n\n
# \/opt\/mysql\/bin\/mysql -uroot -e “SET SQL_LOG_BIN=0;SET global super_read_only=OFF; SET global read_only=OFF; alter user ‘root’@’localhost’ password expire never; set password for ‘root’@’localhost’=’123456′;create user if not exists repl@’%’ identified by ‘123456’;grant all on *.* to repl@’%’ with grant option;create user if not exists icadmin@’%’ identified by ‘123456’;grant all on *.* to icadmin@’%’ with grant option;flush privileges; set global super_read_only=1;set global read_only=1;SET SQL_LOG_BIN=1;”<\/p>\n\n\n\n
6.\u542f\u52a8\u7ec4\u590d\u5236<\/p>\n\n\n\n
\u8282\u70b9A\u3001B\u3001C\u90fd\u6267\u884c\uff1a<\/p>\n\n\n\n
#\/opt\/mysql\/bin\/mysql -uroot -p123456 -e “CHANGE MASTER TO MASTER_USER=’repl’, MASTER_PASSWORD=’123456′ FOR CHANNEL ‘group_replication_recovery’;”<\/p>\n\n\n\n
\u8282\u70b9A\u6267\u884c\uff1a<\/p>\n\n\n\n
# \/opt\/mysql\/bin\/mysql -uroot -e “set global group_replication_bootstrap_group=on;start group_replicationuser=’repl’,password=’123456′;set global group_replication_bootstrap_group=off”<\/p>\n\n\n\n
\u8282\u70b9B\u548cC\u6267\u884c\uff1a<\/p>\n\n\n\n
# \/opt\/mysql\/bin\/mysql -uroot -e “start group_replicationuser=’repl’,password=’123456′”<\/p>\n\n\n\n
7.\u67e5\u770b\u7ec4\u590d\u5236\u6210\u5458<\/p>\n\n\n\n
\u5728\u4efb\u4e00\u8282\u70b9\u4e0a\u6267\u884c\uff1a<\/p>\n\n\n\n
# \/opt\/mysql\/bin\/mysql -uroot -e “select * from performance_schema.replication_group_members\\G”<\/p>\n\n\n\n 8.\u5b89\u88c5mysql-shell<\/p>\n\n\n\n \u8282\u70b9A\u6267\u884c\uff1a<\/p>\n\n\n\n # tar zxf mysql-shell-8.0.25-linux-glibc2.12-x86-64bit.tar.gz -C \/opt\/<\/p>\n\n\n\n # mv \/opt\/mysql-shell-8.0.25-linux-glibc2.12-x86-64bit\/ \/opt\/mysqlshell<\/p>\n\n\n\n # for ((i=7;i<=8;i++));do scp -r \/opt\/mysqlshell root@192.168.23.$i:\/opt;done<\/p>\n\n\n\n \u5728\u4e09\u4e2a\u8282\u70b9\u90fd\u6267\u884c\uff1a<\/p>\n\n\n\n # echo “export PATH=\\$PATH:\/opt\/mysqlshell\/bin” >>\/etc\/profile.d\/mysqlshell.sh<\/p>\n\n\n\n # source \/etc\/profile.d\/mysqlshell.sh<\/p>\n\n\n\n 9.\u521b\u5efa\u96c6\u7fa4<\/p>\n\n\n\n \u8282\u70b9A\u6267\u884c\uff1a<\/p>\n\n\n\n # mysqlsh -uicadmin -p123456 -h localhost<\/p>\n\n\n\n MySQL localhost:33060+ ssl JS >var cluster = dba.createCluster(\u2018testCluster\u2019);<\/p>\n\n\n\n MySQL localhost:33060+ ssl JS > dba.getCluster(\u2018testCluster\u2019).status();<\/p>\n\n\n\n 10.\u5b89\u88c5MySQL Router\u5e76\u542f\u52a8<\/p>\n\n\n\n \u4e2d\u95f4\u4ef6\u670d\u52a1\u5668\u8981\u4e0e\u5e94\u7528\u670d\u52a1\u5668\u5408\u8bbe\u6216\u8005\u72ec\u7acb\u8bbe\u7f6e<\/p>\n\n\n\n \u5728\u8282\u70b9A\u4e0a\uff1a<\/p>\n\n\n\n # tar Jxf mysql-router-8.0.25-linux-glibc2.12-x86_64.tar.xz -C \/opt<\/p>\n\n\n\n # mv \/opt\/mysql-router-8.0.25-linux-glibc2.12-x86_64\/ \/opt\/mysqlrouter<\/p>\n\n\n\n # echo “export PATH=\\$PATH:\/opt\/mysqlrouter\/bin” >>\/etc\/profile.d\/mysqlrouter.sh<\/p>\n\n\n\n # source \/etc\/profile.d\/mysqlrouter.sh<\/p>\n\n\n\n # mkdir \/database\/mysqlrouter<\/p>\n\n\n\n # chown -R mysql:mysql \/database\/mysqlrouter<\/p>\n\n\n\n # mysqlrouter –bootstrap icadmin:123456@192.168.23.6 –directory \/database\/mysqlrouter –conf-use-sockets –user=mysql –name=mysql_router_13306 –conf-bind-address=192.168.23.6 –account-host=”192.168.23.%” –force<\/p>\n\n\n\n # \/database\/mysqlrouter\/start.sh<\/p>\n\n\n\n \u6d4b\u8bd56446\u5199\u63a5\u53e3\uff1a<\/p>\n\n\n\n # mysql -uicadmin -p123456 -h 192.168.23.6 -P 6446<\/p>\n\n\n\n mysql> select @@hostname as hostname, @@port as port;<\/p>\n\n\n\n +————–+——+<\/p>\n\n\n\n | hostname | port |<\/p>\n\n\n\n +————–+——+<\/p>\n\n\n\n | ccab8856acfd | 3306 |<\/p>\n\n\n\n +————–+——+<\/p>\n\n\n\n \/\/ccab8856acfd\u662f192.168.23.6\u7684hostname<\/p>\n\n\n\n 1 row in set (0.00 sec)<\/p>\n\n\n\n mysql> create database db1;<\/p>\n\n\n\n mysql> use db1;<\/p>\n\n\n\n Database changed<\/p>\n\n\n\n mysql> create table table1 (id int,column1 varchar(20));<\/p>\n\n\n\n Query OK, 0 rows affected (0.04 sec)<\/p>\n\n\n\n \u6d4b\u8bd56447\u8bfb\u63a5\u53e3\uff1a<\/p>\n\n\n\n # mysql -uicadmin -p123456 -h 192.168.23.6 -P 6447<\/p>\n\n\n\n mysql> select @@hostname as hostname, @@port as port;<\/p>\n\n\n\n +————–+——+<\/p>\n\n\n\n | hostname | port |<\/p>\n\n\n\n +————–+——+<\/p>\n\n\n\n | 0984f87b6579 | 3306 |<\/p>\n\n\n\n +————–+——+<\/p>\n\n\n\n 1 row in set (0.00 sec)<\/p>\n\n\n\n \/\/0984f87b6579\u662f192.168.23.8\u7684hostname<\/p>\n\n\n\n mysql> select @@hostname as hostname, @@port as port;<\/p>\n\n\n\n +————–+——+<\/p>\n\n\n\n | hostname | port |<\/p>\n\n\n\n +————–+——+<\/p>\n\n\n\n | b41f91fece42 | 3306 |<\/p>\n\n\n\n +————–+——+<\/p>\n\n\n\n 1 row in set (0.00 sec)<\/p>\n\n\n\n \/\/b41f91fece42\u662f192.168.23.7\u7684hostname<\/p>\n\n\n\n mysql> desc db1.table1;<\/p>\n\n\n\n +———+————-+——+—–+———+——-+<\/p>\n\n\n\n | Field | Type | Null | Key | Default | Extra |<\/p>\n\n\n\n +———+————-+——+—–+———+——-+<\/p>\n\n\n\n | id | int | YES | | NULL | |<\/p>\n\n\n\n | column1 | varchar(20) | YES | | NULL | |<\/p>\n\n\n\n +———+————-+——+—–+———+——-+<\/p>\n\n\n\n 2 rows in set (0.00 sec)<\/p>\n\n\n\n \u5c0f\u7ed3\uff1a<\/p>\n\n\n\n InnoDB Cluster\u4f7f\u7528\u7ec4\u590d\u5236\uff0c\u56e0\u6b64\u60a8\u7684\u670d\u52a1\u5668\u5b9e\u4f8b\u5fc5\u987b\u6ee1\u8db3\u76f8\u540c\u7684\u8981\u6c42\u3002AdminAPI\u63d0\u4f9b\u4e86 dba.checkInstanceConfiguration()\u9a8c\u8bc1\u5b9e\u4f8b\u662f\u5426\u6ee1\u8db3\u7ec4\u590d\u5236\u8981\u6c42\u7684dba.configureInstance()\u65b9\u6cd5\uff0c\u4ee5\u53ca \u914d\u7f6e\u5b9e\u4f8b\u4ee5\u6ee1\u8db3\u8981\u6c42\u7684\u65b9\u6cd5\uff1a<\/p>\n\n\n\n \u4e09\u53f0\u4e3b\u673a \u8282\u70b9A\uff1a192.168.23.6 \u8282\u70b9B\uff1a192.168.23.7 \u8282\u70b9C\uff1a192.168.23.8 1.\u914d\u7f6e\u4e3b\u673assh\u4e92\u4fe1\u3001hosts \u8282\u70b9A\u6267\u884c\uff1a # ssh-keygen # ssh-copy-id -i \/root\/.ssh\/id_rsa.pub root@192.168.23.6 # scp -r \/root\/.ssh root@192.168.23.7:\/root\/ # scp -r \/root\/.ssh root@192.168.23.8:\/root\/ cat >>\/etc\/hosts <<EOF 192.168.23.6 db1 192.168.23.7 db2 192.168.23.8 db3 EOF # for ((i=7;i<=8;i++));do scp \/etc\/hosts root@192.168.23.$i:\/etc\/;done 2.\u90e8\u7f72MySQL # export https_proxy=ffa.dockermix.icu:30510;wgethttps:\/\/dev.mysql.com\/get\/Downloads\/MySQL-8.0\/mysql-8.0.25-linux-glibc2.12-x86_64.tar # tar xf mysql-8.0.25-linux-glibc2.12-x86_64.tar # tar Jxf mysql-8.0.25-linux-glibc2.12-x86_64.tar.xz -C \/opt\/ # mv […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-153","post","type-post","status-publish","format-standard","hentry","category-8"],"_links":{"self":[{"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/153","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=153"}],"version-history":[{"count":3,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/153\/revisions"}],"predecessor-version":[{"id":665,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/153\/revisions\/665"}],"wp:attachment":[{"href":"https:\/\/opshub.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=153"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=153"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"\"](\"https:\/\/blog.opshub.com.cn\/wp-content\/uploads\/2026\/01\/image-6-1024x142.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/blog.opshub.com.cn\/wp-content\/uploads\/2026\/01\/image-8.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/blog.opshub.com.cn\/wp-content\/uploads\/2026\/01\/image-7.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/blog.opshub.com.cn\/wp-content\/uploads\/2026\/01\/image-10.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/blog.opshub.com.cn\/wp-content\/uploads\/2026\/01\/image-9-1024x267.png\")
<\/figure>\n","protected":false},"excerpt":{"rendered":"