{"id":43410,"date":"2023-07-01T07:08:55","date_gmt":"2024-02-01T13:57:10","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8galera-cluster%e8%bf%9b%e8%a1%8c%e6%9e%84%e5%bb%ba%e5%92%8c%e4%bd%bf%e7%94%a8mysqld_exporter%e8%bf%9b%e8%a1%8c%e7%9b%91%e8%a7%86\/"},"modified":"2024-04-30T11:28:07","modified_gmt":"2024-04-30T03:28:07","slug":"%e4%bd%bf%e7%94%a8galera-cluster%e8%bf%9b%e8%a1%8c%e6%9e%84%e5%bb%ba%e5%92%8c%e4%bd%bf%e7%94%a8mysqld_exporter%e8%bf%9b%e8%a1%8c%e7%9b%91%e8%a7%86","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8galera-cluster%e8%bf%9b%e8%a1%8c%e6%9e%84%e5%bb%ba%e5%92%8c%e4%bd%bf%e7%94%a8mysqld_exporter%e8%bf%9b%e8%a1%8c%e7%9b%91%e8%a7%86\/","title":{"rendered":"\u4f7f\u7528Galera Cluster\u8fdb\u884c\u6784\u5efa\u548c\u4f7f\u7528mysqld_exporter\u8fdb\u884c\u76d1\u89c6"},"content":{"rendered":"

\u5173\u4e8e\u8fd9\u7bc7\u6587\u7ae0<\/h1>\n
\"galera1.png\"<\/div>\n

\u4ee5\u7c7b\u4f3c\u7684\u65b9\u5f0f\uff0c\u4f7f\u76d1\u63a7\u7ed3\u679c\u53ef\u4ee5\u5728Grafana\u4e0a\u67e5\u770b\u3002
\n\u867d\u7136\u672a\u63d0\u53ca\uff0c\u4f46\u6570\u636e\u5e93\u548c\u76d1\u63a7\u90fd\u5c06\u4f7f\u7528Docker\u8fdb\u884c\u6784\u5efa\u3002<\/p>\n

\u73af\u5883<\/h1>\n

\u73af\u5883\u5982\u4e0b\uff1a
\n\u64cd\u4f5c\u7cfb\u7edf\uff1a
\n– Ubuntu 20.04
\n\u4e2d\u95f4\u4ef6\uff1a
\n– Docker: 20.10.8
\n– Docker Compose: 1.29.0
\n– mysqld_exporter: 0.13.0
\n\u5bb9\u5668\uff1a
\n– MariaDB: 10.6.2-focal
\n– prom\/prometheus
\n– grafana\/grafana<\/p>\n

\u6570\u636e\u5e93\u8bbe\u7f6e (DB\u8bbe\u7f6e)<\/h1>\n

\u6784\u5efaGalera\u96c6\u7fa4\u3002<\/h2>\n

\u6211\u4eec\u9996\u5148\u8981\u642d\u5efa\u4e09\u4e2aMariaDB\uff0c\u5e76\u8fdb\u884cGaleraCluster\u7684\u914d\u7f6e\u3002<\/p>\n

DB1 could be paraphrased in Chinese as “\u6570\u636e\u5e931” Y\u012b).<\/h3>\n
root@db00:~# mkdir db01\r\nroot@db00:~# cd db01\r\nroot@db00:~\/db01# mkdir log\r\nroot@db00:~\/db01# mkdir mysql\r\nroot@db00:~\/db01# ls\r\nlog  mysql\r\nroot@db00:~\/db01# vi docker-compose.yml\r\n<\/code><\/pre>\n
\u4ee5\u4e0b\u662fDB1\u7684docker-compose.yml\uff1a
\n\u5176\u4ed6\u6570\u636e\u5e93\u4e5f\u4f7f\u7528\u76f8\u540c\u7684docker-compose.yml\uff0c\u4f46\u53ea\u6709DB1\u4e0a\u6709\u4e00\u4e2acommand\u3002\u5728\u542f\u52a8\u65f6\uff0c\u9996\u5148\u542f\u52a8DB1\u5e76\u751f\u6210\u96c6\u7fa4\uff0c\u7136\u540e\u542f\u52a8\u5176\u4ed6\u670d\u52a1\u5668\u5e76\u52a0\u5165\u96c6\u7fa4\u3002<\/p>\n
version<\/span>:<\/span> '<\/span>3.7'<\/span>\r\nservices<\/span>:<\/span>\r\n  db<\/span>:<\/span>\r\n    image<\/span>:<\/span> mariadb:10.6.2-focal<\/span>\r\n    volumes<\/span>:<\/span>\r\n      -<\/span> \"<\/span>.\/db.cnf:\/etc\/mysql\/conf.d\/db.cnf\"<\/span>\r\n      -<\/span> \"<\/span>db-data:\/var\/lib\/mysql\"<\/span>\r\n      -<\/span> \"<\/span>db-log:\/var\/log\/mysql\"<\/span>\r\n    environment<\/span>:<\/span>\r\n      -<\/span> TZ=Asia\/Tokyo<\/span>\r\n      -<\/span> MARIADB_ALLOW_EMPTY_ROOT_PASSWORD=yes<\/span>\r\n    network_mode<\/span>:<\/span> host<\/span>\r\n    #command\u306fDB1\u306e\u307f<\/span>\r\n    command<\/span>:<\/span> [<\/span>\"<\/span>--wsrep-new-cluster\"<\/span>]<\/span>\r\nvolumes<\/span>:<\/span>\r\n  db-data<\/span>:<\/span>\r\n    driver<\/span>:<\/span> local<\/span>\r\n    driver_opts<\/span>:<\/span>\r\n      type<\/span>:<\/span> none<\/span>\r\n      device<\/span>:<\/span> ${PWD}\/mysql<\/span>\r\n      o<\/span>:<\/span> bind<\/span>\r\n  db-log<\/span>:<\/span>\r\n    driver<\/span>:<\/span> local<\/span>\r\n    driver_opts<\/span>:<\/span>\r\n      type<\/span>:<\/span> none<\/span>\r\n      device<\/span>:<\/span> ${PWD}\/log<\/span>\r\n      o<\/span>:<\/span> bind<\/span>\r\n<\/code><\/pre>\n
\u63a5\u4e0b\u6765\uff0c\u5728\u76f8\u540c\u7684\u76ee\u5f55\u4e0b\uff0c\u6211\u4eec\u9700\u8981\u7f16\u5199db.cnf\u6587\u4ef6\uff0c\u5e76\u5c06\u4ee5\u4e0b\u5185\u5bb9\u5199\u5165\u5176\u4e2d\u3002<\/p>\n
[galera<\/span>]\r\nwsrep_on<\/span>                 = ON<\/span>\r\nwsrep_provider<\/span>           = \/usr<\/span>\/lib<\/span>\/galera<\/span>\/libgalera_smm<\/span>.so<\/span>\r\nwsrep_cluster_name<\/span>       = \"MariaDB Galera Cluster\"<\/span>\r\n#\u5404\u30b5\u30fc\u30d0\u306eIP\u30a2\u30c9\u30ec\u30b9\u3092\u8a18\u8f09\r\n<\/span>wsrep_cluster_address<\/span>    = gcomm<\/span>:\/\/192<\/span>.168<\/span>.153<\/span>.5<\/span>,192<\/span>.168<\/span>.153<\/span>.6<\/span>,192<\/span>.168<\/span>.153<\/span>.7<\/span>\r\n#\u81ea\u30b5\u30fc\u30d0\u306eIP\u30a2\u30c9\u30ec\u30b9\u3092\u8a18\u8f09\r\n<\/span>wsrep_node_address<\/span>       = 192<\/span>.168<\/span>.153<\/span>.5<\/span>\r\n#\u4eca\u56de\u306fsst_method\u306fmariabackup\u3092\u5229\u7528\u3059\u308b\r\n<\/span>wsrep_sst_method<\/span>         = \"mariabackup\"<\/span>\r\nwsrep_sst_auth<\/span>           = 'mariabackup:mypassword'<\/span>\r\nwsrep_slave_threads<\/span>      = 4<\/span>\r\n#node_name\u306fhost\u540d\u3068\u540c\u3058\u306b\u3059\u308b\r\n<\/span>wsrep_node_name<\/span>          =\"db01\"<\/span>\r\nwsrep_sst_donor<\/span>          =\"db01,db02,db03\"<\/span>\r\n[mysqld<\/span>]\r\ndefault_storage_engine<\/span>     = InnoDB<\/span>\r\nbinlog_format<\/span>              = ROW<\/span>\r\nlog_bin<\/span>                    = \/var<\/span>\/log<\/span>\/mysql<\/span>\/mysql<\/span>-bin<\/span>\r\ninnodb_autoinc_lock_mode<\/span>   = 2<\/span>\r\ninnodb_locks_unsafe_for_binlog<\/span> = 1<\/span>\r\n<\/code><\/pre>\n
\u5230\u76ee\u524d\u4e3a\u6b62\u5df2\u7ecf\u53d8\u6210\u4e86\u8fd9\u6837\u3002<\/p>\n
root@db00:~\/db01# ls\r\ndb.cnf  docker-compose.yml  log  mysql\r\n<\/code><\/pre>\n
DB2 \u6570\u636e\u5e93<\/h2>\n
\u4ee5\u76f8\u540c\u7684\u65b9\u5f0f\u8fdb\u884c\u8bbe\u7f6e\u3002
\n\u8bf7\u6ce8\u610fdocker-compose.yml\u4e2d\u6ca1\u6709\u547d\u4ee4\uff08command\uff09, \u4ee5\u53cadb.cnf\u4e2d”wsrep_node_address”\u548c”wsrep_node_name”\u662f\u7279\u5b9a\u4e8e\u670d\u52a1\u5668\u7684\u3002<\/p>\n
root@db01:~# mkdir db02\r\nroot@db01:~# cd db02\r\nroot@db01:~\/db02# mkdir log\r\nroot@db01:~\/db02# mkdir mysql\r\nroot@db01:~\/db02# vi docker-compose.yml\r\nroot@db01:~\/db02# vi db.cnf\r\n<\/code><\/pre>\n
version<\/span>:<\/span> '<\/span>3.7'<\/span>\r\nservices<\/span>:<\/span>\r\n  db<\/span>:<\/span>\r\n    image<\/span>:<\/span> mariadb:10.6.2-focal<\/span>\r\n    volumes<\/span>:<\/span>\r\n      -<\/span> \"<\/span>.\/db.cnf:\/etc\/mysql\/conf.d\/db.cnf\"<\/span>\r\n      -<\/span> \"<\/span>db-data:\/var\/lib\/mysql\"<\/span>\r\n      -<\/span> \"<\/span>db-log:\/var\/log\/mysql\"<\/span>\r\n    environment<\/span>:<\/span>\r\n      -<\/span> TZ=Asia\/Tokyo<\/span>\r\n      -<\/span> MARIADB_ALLOW_EMPTY_ROOT_PASSWORD=yes<\/span>\r\n    network_mode<\/span>:<\/span> host<\/span>\r\nvolumes<\/span>:<\/span>\r\n  db-data<\/span>:<\/span>\r\n    driver<\/span>:<\/span> local<\/span>\r\n    driver_opts<\/span>:<\/span>\r\n      type<\/span>:<\/span> none<\/span>\r\n      device<\/span>:<\/span> ${PWD}\/mysql<\/span>\r\n      o<\/span>:<\/span> bind<\/span>\r\n  db-log<\/span>:<\/span>\r\n    driver<\/span>:<\/span> local<\/span>\r\n    driver_opts<\/span>:<\/span>\r\n      type<\/span>:<\/span> none<\/span>\r\n      device<\/span>:<\/span> ${PWD}\/log<\/span>\r\n      o<\/span>:<\/span> bind<\/span>\r\n<\/code><\/pre>\n
[galera<\/span>]\r\nwsrep_on<\/span>                 = ON<\/span>\r\nwsrep_provider<\/span>           = \/usr<\/span>\/lib<\/span>\/galera<\/span>\/libgalera_smm<\/span>.so<\/span>\r\nwsrep_cluster_name<\/span>       = \"MariaDB Galera Cluster\"<\/span>\r\n#\u5404\u30b5\u30fc\u30d0\u306eIP\u30a2\u30c9\u30ec\u30b9\u3092\u8a18\u8f09\r\n<\/span>wsrep_cluster_address<\/span>    = gcomm<\/span>:\/\/192<\/span>.168<\/span>.153<\/span>.5<\/span>,192<\/span>.168<\/span>.153<\/span>.6<\/span>,192<\/span>.168<\/span>.153<\/span>.7<\/span>\r\n#\u81ea\u30b5\u30fc\u30d0\u306eIP\u30a2\u30c9\u30ec\u30b9\u3092\u8a18\u8f09\r\n<\/span>wsrep_node_address<\/span>       = 192<\/span>.168<\/span>.153<\/span>.6<\/span>\r\n#\u4eca\u56de\u306fsst_method\u306fmariabackup\u3092\u5229\u7528\u3059\u308b\r\n<\/span>wsrep_sst_method<\/span>         = \"mariabackup\"<\/span>\r\nwsrep_sst_auth<\/span>           = 'mariabackup:mypassword'<\/span>\r\nwsrep_slave_threads<\/span>      = 4<\/span>\r\n#node_name\u306fhost\u540d\u3068\u540c\u3058\u306b\u3059\u308b\r\n<\/span>wsrep_node_name<\/span>          =\"db02\"<\/span>\r\nwsrep_sst_donor<\/span>          =\"db01,db02,db03\"<\/span>\r\n[mysqld<\/span>]\r\ndefault_storage_engine<\/span>     = InnoDB<\/span>\r\nbinlog_format<\/span>              = ROW<\/span>\r\nlog_bin<\/span>                    = \/var<\/span>\/log<\/span>\/mysql<\/span>\/mysql<\/span>-bin<\/span>\r\ninnodb_autoinc_lock_mode<\/span>   = 2<\/span>\r\ninnodb_locks_unsafe_for_binlog<\/span> = 1<\/span>\r\n<\/code><\/pre>\n
DB3
\nDB3<\/h2>\n
root@db01:~# mkdir db03\r\nroot@db01:~# cd db03\r\nroot@db01:~\/db02# mkdir log\r\nroot@db01:~\/db02# mkdir mysql\r\nroot@db01:~\/db02# vi docker-compose.yml\r\nroot@db01:~\/db02# vi db.cnf\r\n<\/code><\/pre>\n
version<\/span>:<\/span> '<\/span>3.7'<\/span>\r\nservices<\/span>:<\/span>\r\n  db<\/span>:<\/span>\r\n    image<\/span>:<\/span> mariadb:10.6.2-focal<\/span>\r\n    volumes<\/span>:<\/span>\r\n      -<\/span> \"<\/span>.\/db.cnf:\/etc\/mysql\/conf.d\/db.cnf\"<\/span>\r\n      -<\/span> \"<\/span>db-data:\/var\/lib\/mysql\"<\/span>\r\n      -<\/span> \"<\/span>db-log:\/var\/log\/mysql\"<\/span>\r\n    environment<\/span>:<\/span>\r\n      -<\/span> TZ=Asia\/Tokyo<\/span>\r\n      -<\/span> MARIADB_ALLOW_EMPTY_ROOT_PASSWORD=yes<\/span>\r\n    network_mode<\/span>:<\/span> host<\/span>\r\nvolumes<\/span>:<\/span>\r\n  db-data<\/span>:<\/span>\r\n    driver<\/span>:<\/span> local<\/span>\r\n    driver_opts<\/span>:<\/span>\r\n      type<\/span>:<\/span> none<\/span>\r\n      device<\/span>:<\/span> ${PWD}\/mysql<\/span>\r\n      o<\/span>:<\/span> bind<\/span>\r\n  db-log<\/span>:<\/span>\r\n    driver<\/span>:<\/span> local<\/span>\r\n    driver_opts<\/span>:<\/span>\r\n      type<\/span>:<\/span> none<\/span>\r\n      device<\/span>:<\/span> ${PWD}\/log<\/span>\r\n      o<\/span>:<\/span> bind<\/span>\r\n<\/code><\/pre>\n
[galera<\/span>]\r\nwsrep_on<\/span>                 = ON<\/span>\r\nwsrep_provider<\/span>           = \/usr<\/span>\/lib<\/span>\/galera<\/span>\/libgalera_smm<\/span>.so<\/span>\r\nwsrep_cluster_name<\/span>       = \"MariaDB Galera Cluster\"<\/span>\r\n#\u5404\u30b5\u30fc\u30d0\u306eIP\u30a2\u30c9\u30ec\u30b9\u3092\u8a18\u8f09\r\n<\/span>wsrep_cluster_address<\/span>    = gcomm<\/span>:\/\/192<\/span>.168<\/span>.153<\/span>.5<\/span>,192<\/span>.168<\/span>.153<\/span>.6<\/span>,192<\/span>.168<\/span>.153<\/span>.7<\/span>\r\n#\u81ea\u30b5\u30fc\u30d0\u306eIP\u30a2\u30c9\u30ec\u30b9\u3092\u8a18\u8f09\r\n<\/span>wsrep_node_address<\/span>       = 192<\/span>.168<\/span>.153<\/span>.7<\/span>\r\n#\u4eca\u56de\u306fsst_method\u306fmariabackup\u3092\u5229\u7528\u3059\u308b\r\n<\/span>wsrep_sst_method<\/span>         = \"mariabackup\"<\/span>\r\nwsrep_sst_auth<\/span>           = 'mariabackup:mypassword'<\/span>\r\nwsrep_slave_threads<\/span>      = 4<\/span>\r\n#node_name\u306fhost\u540d\u3068\u540c\u3058\u306b\u3059\u308b\r\n<\/span>wsrep_node_name<\/span>          =\"db03\"<\/span>\r\nwsrep_sst_donor<\/span>          =\"db01,db02,db03\"<\/span>\r\n[mysqld<\/span>]\r\ndefault_storage_engine<\/span>     = InnoDB<\/span>\r\nbinlog_format<\/span>              = ROW<\/span>\r\nlog_bin<\/span>                    = \/var<\/span>\/log<\/span>\/mysql<\/span>\/mysql<\/span>-bin<\/span>\r\ninnodb_autoinc_lock_mode<\/span>   = 2<\/span>\r\ninnodb_locks_unsafe_for_binlog<\/span> = 1<\/span>\r\n<\/code><\/pre>\n
\u542f\u52a8\u96c6\u7fa4<\/h2>\n
\u5f00\u59cb\u8fd0\u884cDB1<\/p>\n
root@db00:~\/db01# docker-compose up -d\r\nCreating volume \"db01_db-data\" with local driver\r\nCreating volume \"db01_db-log\" with local driver\r\nCreating db01_db_1 ... done\r\nroot@db00:~\/db01# docker-compose ps\r\n  Name                 Command               State   Ports\r\n----------------------------------------------------------\r\ndb01_db_1   docker-entrypoint.sh --wsr ...   Up\r\n<\/code><\/pre>\n
\u8ba9\u6211\u4eec\u786e\u8ba4\u4e00\u4e0b\u96c6\u7fa4\u662f\u5426\u542f\u52a8\u4e86\u3002<\/p>\n
root@db00:~\/db01# docker-compose exec db mysql -u root -e \"show status like 'wsrep_cluster_%'\"\r\n+----------------------------+--------------------------------------+\r\n| Variable_name              | Value                                |\r\n+----------------------------+--------------------------------------+\r\n| wsrep_cluster_weight       | 1                                    |\r\n| wsrep_cluster_capabilities |                                      |\r\n| wsrep_cluster_conf_id      | 1                                    |\r\n| wsrep_cluster_size         | 1                                    |\r\n| wsrep_cluster_state_uuid   | ffc5854e-21a5-11ec-ac7b-9b4df50357e9 |\r\n| wsrep_cluster_status       | Primary                              |\r\n+----------------------------+--------------------------------------+\r\n<\/code><\/pre>\n
\u5728\u542f\u52a8\u5176\u4ed6\u6570\u636e\u5e93\u4e4b\u524d\uff0c\u8981\u521b\u5efa\u4e00\u4e2a\u7528\u4e8emariabackup\u7684\u7528\u6237\u3002
\n\u5982\u679c\u4e0d\u5148\u521b\u5efa\u7528\u6237\uff0c\u5f53\u542f\u52a8\u6570\u636e\u5e93\u5e76\u6267\u884cSST\u65f6\u4f1a\u5931\u8d25\u3002<\/p>\n
root@db00:~\/db01# docker-compose exec db mysql -u root\r\nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\r\nYour MariaDB connection id is 11\r\nServer version: 10.6.2-MariaDB-1:10.6.2+maria~focal-log mariadb.org binary distribution\r\n\r\nCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nMariaDB [(none)]> CREATE USER 'mariabackup'@'localhost' IDENTIFIED BY 'mypassword';\r\nQuery OK, 0 rows affected (0.004 sec)\r\n\r\nMariaDB [(none)]> GRANT RELOAD, PROCESS, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'mariabackup'@'localhost';\r\nQuery OK, 0 rows affected (0.005 sec)\r\n<\/code><\/pre>\n
\u73b0\u5728\u51c6\u5907\u5de5\u4f5c\u5df2\u5b8c\u6210\uff0c\u53ef\u4ee5\u542f\u52a8\u5176\u4ed6DB\u5bb9\u5668\u4e86\u3002<\/p>\n
root@db01:~\/db02# docker-compose up -d\r\nCreating volume \"db02_db-data\" with local driver\r\nCreating volume \"db02_db-log\" with local driver\r\nCreating db02_db_1 ... done\r\nroot@db01:~\/db02# docker-compose ps\r\n  Name                Command             State   Ports\r\n-------------------------------------------------------\r\ndb02_db_1   docker-entrypoint.sh mysqld   Up\r\nroot@db01:~\/db02# docker-compose exec db mysql -u root -e \"show status like 'wsrep_cluster_%'\"\r\n+----------------------------+--------------------------------------+\r\n| Variable_name              | Value                                |\r\n+----------------------------+--------------------------------------+\r\n| wsrep_cluster_weight       | 2                                    |\r\n| wsrep_cluster_capabilities |                                      |\r\n| wsrep_cluster_conf_id      | 2                                    |\r\n| wsrep_cluster_size         | 2                                    |\r\n| wsrep_cluster_state_uuid   | 276f65ef-21a6-11ec-ab3a-b716b6fe3644 |\r\n| wsrep_cluster_status       | Primary                              |\r\n+----------------------------+--------------------------------------+\r\n<\/code><\/pre>\n
root@db02:~\/db03# docker-compose up -d\r\nCreating volume \"db03_db-data\" with local driver\r\nCreating volume \"db03_db-log\" with local driver\r\nCreating db03_db_1 ... done\r\nroot@db02:~\/db03# docker-compose ps\r\n  Name                Command             State   Ports\r\n-------------------------------------------------------\r\ndb03_db_1   docker-entrypoint.sh mysqld   Up\r\nroot@db02:~\/db03# docker-compose exec db mysql -u root -e \"show status like 'wsrep_cluster_%'\"\r\n+----------------------------+--------------------------------------+\r\n| Variable_name              | Value                                |\r\n+----------------------------+--------------------------------------+\r\n| wsrep_cluster_weight       | 3                                    |\r\n| wsrep_cluster_capabilities |                                      |\r\n| wsrep_cluster_conf_id      | 3                                    |\r\n| wsrep_cluster_size         | 3                                    |\r\n| wsrep_cluster_state_uuid   | 276f65ef-21a6-11ec-ab3a-b716b6fe3644 |\r\n| wsrep_cluster_status       | Primary                              |\r\n+----------------------------+--------------------------------------+\r\n<\/code><\/pre>\n
\u6211\u5011\u6210\u529f\u642d\u5efa\u4e86\u4e00\u500b\u7531\u4e09\u500b\u53f0\u69cb\u6210\u7684Galera Cluster\u3002
\n(Korede de Galera Cluster .)<\/p>\n
\u5c06 mysqld_exporter \u6ce8\u518c\u4e3a\u670d\u52a1<\/h2>\n
\u9996\u5148\u4e0b\u8f7dmysqld_exporter\u3002<\/p>\n
root@db00:~# cd \/var\/tmp\/\r\n##\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\r\nroot@db00:\/var\/tmp# curl -LO https:\/\/github.com\/prometheus\/mysqld_exporter\/releases\/download\/v0.13.0\/mysqld_exporter-0.13.0.linux-amd64.tar.gz\r\n  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current\r\n                                 Dload  Upload   Total   Spent    Left  Speed\r\n100   647  100   647    0     0   2028      0 --:--:-- --:--:-- --:--:--  2028\r\n100 7072k  100 7072k    0     0  3388k      0  0:00:02  0:00:02 --:--:-- 4025k\r\nroot@db00:\/var\/tmp# ls\r\nmysqld_exporter-0.13.0.linux-amd64.tar.gz\r\n##\u89e3\u51cd\r\nroot@db00:\/var\/tmp# tar -zxvf mysqld_exporter-0.13.0.linux-amd64.tar.gz\r\nmysqld_exporter-0.13.0.linux-amd64\/\r\nmysqld_exporter-0.13.0.linux-amd64\/LICENSE\r\nmysqld_exporter-0.13.0.linux-amd64\/NOTICE\r\nmysqld_exporter-0.13.0.linux-amd64\/mysqld_exporter\r\n##\u5b9f\u884c\u30d5\u30a1\u30a4\u30eb\u3092\u9069\u5f53\u306a\u5834\u6240\u306b\u914d\u7f6e\u3059\u308b\r\nroot@db00:\/var\/tmp# mkdir \/var\/lib\/mysqld_exporter\r\nroot@db00:\/var\/tmp# cp mysqld_exporter-0.13.0.linux-amd64\/mysqld_exporter \/var\/lib\/mysqld_exporter\/\r\nroot@db00:\/var\/tmp# ls \/var\/lib\/mysqld_exporter\r\nmysqld_exporter\r\n<\/code><\/pre>\n
\u63a5\u4e0b\u6765\u521b\u5efa\u670d\u52a1\u6587\u4ef6\u3002<\/p>\n
root@db00:\/var\/tmp# vi \/etc\/systemd\/system\/mysqld_exporter.service\r\n\r\n[Unit]\r\nDescription=Mysql Exporter\r\nAfter=network-online.target\r\n[Service]\r\nEnvironmentFile=-\/etc\/default\/mysqld_exporter\r\nWorkingDirectory=\/var\/lib\/mysqld_exporter\r\nExecStart=\/var\/lib\/mysqld_exporter\/mysqld_exporter $OPTIONS\r\nRestart=always\r\nRestartSec=1\r\nType=simple\r\n[Install]\r\nWantedBy = multi-user.target\r\n\r\nroot@db00:\/var\/tmp# vi \/etc\/default\/mysqld_exporter\r\n\r\nDATA_SOURCE_NAME= \"exporter:test@(localhost:3306)\/\"\r\nOPTIONS=\"--collect.engine_innodb_status --collect.global_status\"\r\n<\/code><\/pre>\n
\u5728\u8fd9\u91cc\uff0c\u8fd9\u662f\u6240\u6709DB\u670d\u52a1\u5668\u901a\u7528\u7684\u5de5\u4f5c\u3002
\n\u5728\u542f\u52a8\u670d\u52a1\u4e4b\u524d\uff0c\u9700\u8981\u521b\u5efamysqld_exporter\u7528\u6237\u3002
\n\u7531\u4e8e\u6211\u4eec\u6b63\u5728\u7ec4\u5efa\u96c6\u7fa4\uff0c\u6240\u4ee5\u53ea\u9700\u5728\u67d0\u4e00\u53f0\u4e0a\u521b\u5efa\u5373\u53ef\u4e0e\u6240\u6709\u670d\u52a1\u5668\u5171\u4eab\u3002<\/p>\n
root@db00:~\/db01# ls\r\ndb.cnf  docker-compose.yml  log  mysql\r\nroot@db00:~\/db01# docker-compose exec db mysql -u root -e \"CREATE USER 'exporter'@'127.0.0.1' IDENTIFIED BY 'test' WITH MAX_USER_CONNECTIONS 3;\"\r\nroot@db00:~\/db01# docker-compose exec db mysql -u root -e \"GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'127.0.0.1';\"\r\n<\/code><\/pre>\n
\u7531\u4e8e\u4e8b\u5148\u51c6\u5907\u5de5\u4f5c\u5df2\u7ecf\u5b8c\u6210\uff0c\u73b0\u5728\u53ef\u4ee5\u542f\u52a8\u670d\u52a1\u4e86\u3002<\/p>\n
root@db00:~\/db01# systemctl daemon-reload\r\nroot@db00:~\/db01# systemctl start mysqld_exporter\r\nroot@db00:~\/db01# systemctl status mysqld_exporter\r\n\u25cf mysqld_exporter.service - Mysql Exporter\r\n     Loaded: loaded (\/etc\/systemd\/system\/mysqld_exporter.service; disabled; vendor preset: enabled)\r\n     Active: active (running) since Thu 2021-09-30 21:15:29 JST; 9s ago\r\n   Main PID: 40329 (mysqld_exporter)\r\n      Tasks: 4 (limit: 1072)\r\n     Memory: 1.7M\r\n     CGroup: \/system.slice\/mysqld_exporter.service\r\n             mq40329 \/var\/lib\/mysqld_exporter\/mysqld_exporter --collect.engine_innodb_status --collect.global_status\r\n<\/code><\/pre>\n
\u5728\u5176\u4ed6\u6570\u636e\u5e93\u4e2d\u4e5f\u4ee5\u7c7b\u4f3c\u7684\u65b9\u5f0f\u542f\u52a8\u670d\u52a1\u3002<\/p>\n
\u76d1\u89c6 –<\/h1>\n
\u7684\u706b\u7130throw\u654c\u4eba\u81ea\u7531\u3002<\/h2>\n
\u4f7f\u7528Docker\u6765\u719f\u6089Prometheus
\n\u53c2\u8003\u8fd9\u4e2a\u94fe\u63a5\u3002<\/p>\n
\u5728\u76d1\u89c6\u670d\u52a1\u5668\u4e0a\u521b\u5efadocker-compose.yml\u6587\u4ef6\u548c\u914d\u7f6e\u6587\u4ef6\u3002<\/p>\n
root@prometheus:~# mkdir prometheus\r\nroot@prometheus:~# cd prometheus\/\r\nroot@prometheus:~\/prometheus# vi docker-compose.yml\r\nroot@prometheus:~\/prometheus# vi prometheus.yml\r\n<\/code><\/pre>\n
version<\/span>:<\/span> '<\/span>3.7'<\/span>\r\nservices<\/span>:<\/span>\r\n  prometheus<\/span>:<\/span>\r\n    image<\/span>:<\/span> prom\/prometheus<\/span>\r\n    volumes<\/span>:<\/span>\r\n      -<\/span> .\/prometheus.yml:\/etc\/prometheus\/prometheus.yml<\/span>\r\n    ports<\/span>:<\/span>\r\n      -<\/span> '<\/span>9090:9090'<\/span>\r\n  grafana<\/span>:<\/span>\r\n    image<\/span>:<\/span> grafana\/grafana<\/span>\r\n    ports<\/span>:<\/span>\r\n      -<\/span> \"<\/span>3000:3000\"<\/span>\r\n<\/code><\/pre>\n
global<\/span>:<\/span>\r\n  scrape_interval<\/span>:<\/span>     15s<\/span> # By default, scrape targets every 15 seconds.<\/span>\r\n\r\n  # Attach these labels to any time series or alerts when communicating with<\/span>\r\n  # external systems (federation, remote storage, Alertmanager).<\/span>\r\n  external_labels<\/span>:<\/span>\r\n    monitor<\/span>:<\/span> '<\/span>codelab-monitor'<\/span>\r\n\r\n# A scrape configuration containing exactly one endpoint to scrape:<\/span>\r\n# Here it's Prometheus itself.<\/span>\r\nscrape_configs<\/span>:<\/span>\r\n  # The job name is added as a label `job=<job_name>` to any timeseries scraped from this config.<\/span>\r\n  -<\/span> job_name<\/span>:<\/span> '<\/span>prometheus'<\/span>\r\n\r\n    # Override the global default and scrape targets from this job every 5 seconds.<\/span>\r\n    scrape_interval<\/span>:<\/span> 5s<\/span>\r\n\r\n    static_configs<\/span>:<\/span>\r\n      -<\/span> targets<\/span>:<\/span> [<\/span>'<\/span>localhost:9090'<\/span>]<\/span>\r\n\r\n  -<\/span> job_name<\/span>:<\/span> \"<\/span>db1\"<\/span>\r\n    scrape_interval<\/span>:<\/span> \"<\/span>40s\"<\/span>\r\n    scrape_timeout<\/span>:<\/span> \"<\/span>30s\"<\/span>\r\n    static_configs<\/span>:<\/span>\r\n      -<\/span> targets<\/span>:<\/span> [<\/span>'<\/span>192.168.153.5:9104'<\/span>]<\/span>\r\n\r\n  -<\/span> job_name<\/span>:<\/span> \"<\/span>db2\"<\/span>\r\n    scrape_interval<\/span>:<\/span> \"<\/span>40s\"<\/span>\r\n    scrape_timeout<\/span>:<\/span> \"<\/span>30s\"<\/span>\r\n    static_configs<\/span>:<\/span>\r\n      -<\/span> targets<\/span>:<\/span> [<\/span>'<\/span>192.168.153.6:9104'<\/span>]<\/span>\r\n\r\n  -<\/span> job_name<\/span>:<\/span> \"<\/span>db3\"<\/span>\r\n    scrape_interval<\/span>:<\/span> \"<\/span>40s\"<\/span>\r\n    scrape_timeout<\/span>:<\/span> \"<\/span>30s\"<\/span>\r\n    static_configs<\/span>:<\/span>\r\n      -<\/span> targets<\/span>:<\/span> [<\/span>'<\/span>192.168.153.7:9104'<\/span>]<\/span>\r\n<\/code><\/pre>\n
\u5173\u4e8eprometheus.yml\uff0c\u6211\u6b63\u5728\u5c06\u4ee5\u4e0b\u5185\u5bb9\u6dfb\u52a0\u5230\u5b98\u65b9\u63d0\u4f9b\u7684\u914d\u7f6e\u6587\u4ef6\u4e2d\u3002<\/p>\n
  -<\/span> job_name<\/span>:<\/span> \"<\/span>db1\"<\/span>\r\n    scrape_interval<\/span>:<\/span> \"<\/span>40s\"<\/span>\r\n    scrape_timeout<\/span>:<\/span> \"<\/span>30s\"<\/span>\r\n    static_configs<\/span>:<\/span>\r\n      -<\/span> targets<\/span>:<\/span> [<\/span>'<\/span>192.168.153.5:9104'<\/span>]<\/span>\r\n\r\n  -<\/span> job_name<\/span>:<\/span> \"<\/span>db2\"<\/span>\r\n    scrape_interval<\/span>:<\/span> \"<\/span>40s\"<\/span>\r\n    scrape_timeout<\/span>:<\/span> \"<\/span>30s\"<\/span>\r\n    static_configs<\/span>:<\/span>\r\n      -<\/span> targets<\/span>:<\/span> [<\/span>'<\/span>192.168.153.6:9104'<\/span>]<\/span>\r\n\r\n  -<\/span> job_name<\/span>:<\/span> \"<\/span>db3\"<\/span>\r\n    scrape_interval<\/span>:<\/span> \"<\/span>40s\"<\/span>\r\n    scrape_timeout<\/span>:<\/span> \"<\/span>30s\"<\/span>\r\n    static_configs<\/span>:<\/span>\r\n      -<\/span> targets<\/span>:<\/span> [<\/span>'<\/span>192.168.153.7:9104'<\/span>]<\/span>\r\n<\/code><\/pre>\n
\u542f\u52a8\u3002<\/p>\n
root@prometheus:~\/prometheus# docker-compose up -d\r\noot@prometheus:~\/prometheus# docker-compose ps\r\n         Name                        Command               State                    Ports\r\n-----------------------------------------------------------------------------------------------------------\r\nprometheus_grafana_1      \/run.sh                          Up      0.0.0.0:3000->3000\/tcp,:::3000->3000\/tcp\r\nprometheus_prometheus_1   \/bin\/prometheus --config.f ...   Up      0.0.0.0:9090->9090\/tcp,:::9090->9090\/tcp\r\n<\/code><\/pre>\n
\"pro1.png\"<\/div>\n
\"pro2.png\"<\/div>\n
Grafana\u7684\u8bbe\u7f6e<\/h2>\n
\"image.png\"<\/div>\n
\"image.png\"<\/div>\n
\u53ea\u9700\u8981\u5728\u4eea\u8868\u677f\u4e0a\u8bbe\u7f6e\u60f3\u8981\u76d1\u63a7\u7684\u914d\u7f6e\u5373\u53ef\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5173\u4e8e\u8fd9\u7bc7\u6587\u7ae0 \u4ee5\u7c7b\u4f3c\u7684\u65b9\u5f0f\uff0c\u4f7f\u76d1\u63a7\u7ed3\u679c\u53ef\u4ee5\u5728Grafana\u4e0a\u67e5\u770b\u3002 \u867d\u7136\u672a\u63d0\u53ca\uff0c\u4f46\u6570\u636e\u5e93\u548c\u76d1\u63a7\u90fd\u5c06\u4f7f\u7528Dock […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-43410","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n\u4f7f\u7528Galera Cluster\u8fdb\u884c\u6784\u5efa\u548c\u4f7f\u7528mysqld_exporter\u8fdb\u884c\u76d1\u89c6 - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528galera-cluster\u8fdb\u884c\u6784\u5efa\u548c\u4f7f\u7528mysqld_exporter\u8fdb\u884c\u76d1\u89c6\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u4f7f\u7528Galera Cluster\u8fdb\u884c\u6784\u5efa\u548c\u4f7f\u7528mysqld_exporter\u8fdb\u884c\u76d1\u89c6\" \/>\n<meta property=\"og:description\" content=\"\u5173\u4e8e\u8fd9\u7bc7\u6587\u7ae0 \u4ee5\u7c7b\u4f3c\u7684\u65b9\u5f0f\uff0c\u4f7f\u76d1\u63a7\u7ed3\u679c\u53ef\u4ee5\u5728Grafana\u4e0a\u67e5\u770b\u3002 \u867d\u7136\u672a\u63d0\u53ca\uff0c\u4f46\u6570\u636e\u5e93\u548c\u76d1\u63a7\u90fd\u5c06\u4f7f\u7528Dock […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528galera-cluster\u8fdb\u884c\u6784\u5efa\u548c\u4f7f\u7528mysqld_exporter\u8fdb\u884c\u76d1\u89c6\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-01T13:57:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-30T03:28:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d528937434c4406ccd1b4\/1-0.png\" \/>\n<meta name=\"author\" content=\"\u97f5, \u79d1\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u97f5, \u79d1\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8galera-cluster%e8%bf%9b%e8%a1%8c%e6%9e%84%e5%bb%ba%e5%92%8c%e4%bd%bf%e7%94%a8mysqld_exporter%e8%bf%9b%e8%a1%8c%e7%9b%91%e8%a7%86\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8galera-cluster%e8%bf%9b%e8%a1%8c%e6%9e%84%e5%bb%ba%e5%92%8c%e4%bd%bf%e7%94%a8mysqld_exporter%e8%bf%9b%e8%a1%8c%e7%9b%91%e8%a7%86\/\",\"name\":\"\u4f7f\u7528Galera Cluster\u8fdb\u884c\u6784\u5efa\u548c\u4f7f\u7528mysqld_exporter\u8fdb\u884c\u76d1\u89c6 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2024-02-01T13:57:10+00:00\",\"dateModified\":\"2024-04-30T03:28:07+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8galera-cluster%e8%bf%9b%e8%a1%8c%e6%9e%84%e5%bb%ba%e5%92%8c%e4%bd%bf%e7%94%a8mysqld_exporter%e8%bf%9b%e8%a1%8c%e7%9b%91%e8%a7%86\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8galera-cluster%e8%bf%9b%e8%a1%8c%e6%9e%84%e5%bb%ba%e5%92%8c%e4%bd%bf%e7%94%a8mysqld_exporter%e8%bf%9b%e8%a1%8c%e7%9b%91%e8%a7%86\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8galera-cluster%e8%bf%9b%e8%a1%8c%e6%9e%84%e5%bb%ba%e5%92%8c%e4%bd%bf%e7%94%a8mysqld_exporter%e8%bf%9b%e8%a1%8c%e7%9b%91%e8%a7%86\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u4f7f\u7528Galera Cluster\u8fdb\u884c\u6784\u5efa\u548c\u4f7f\u7528mysqld_exporter\u8fdb\u884c\u76d1\u89c6\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e\",\"name\":\"\u97f5, \u79d1\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g\",\"caption\":\"\u97f5, \u79d1\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunke\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8galera-cluster%e8%bf%9b%e8%a1%8c%e6%9e%84%e5%bb%ba%e5%92%8c%e4%bd%bf%e7%94%a8mysqld_exporter%e8%bf%9b%e8%a1%8c%e7%9b%91%e8%a7%86\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u4f7f\u7528Galera Cluster\u8fdb\u884c\u6784\u5efa\u548c\u4f7f\u7528mysqld_exporter\u8fdb\u884c\u76d1\u89c6 - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528galera-cluster\u8fdb\u884c\u6784\u5efa\u548c\u4f7f\u7528mysqld_exporter\u8fdb\u884c\u76d1\u89c6\/","og_locale":"zh_CN","og_type":"article","og_title":"\u4f7f\u7528Galera Cluster\u8fdb\u884c\u6784\u5efa\u548c\u4f7f\u7528mysqld_exporter\u8fdb\u884c\u76d1\u89c6","og_description":"\u5173\u4e8e\u8fd9\u7bc7\u6587\u7ae0 \u4ee5\u7c7b\u4f3c\u7684\u65b9\u5f0f\uff0c\u4f7f\u76d1\u63a7\u7ed3\u679c\u53ef\u4ee5\u5728Grafana\u4e0a\u67e5\u770b\u3002 \u867d\u7136\u672a\u63d0\u53ca\uff0c\u4f46\u6570\u636e\u5e93\u548c\u76d1\u63a7\u90fd\u5c06\u4f7f\u7528Dock […]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528galera-cluster\u8fdb\u884c\u6784\u5efa\u548c\u4f7f\u7528mysqld_exporter\u8fdb\u884c\u76d1\u89c6\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2024-02-01T13:57:10+00:00","article_modified_time":"2024-04-30T03:28:07+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d528937434c4406ccd1b4\/1-0.png"}],"author":"\u97f5, \u79d1","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u97f5, \u79d1","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"8 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8galera-cluster%e8%bf%9b%e8%a1%8c%e6%9e%84%e5%bb%ba%e5%92%8c%e4%bd%bf%e7%94%a8mysqld_exporter%e8%bf%9b%e8%a1%8c%e7%9b%91%e8%a7%86\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8galera-cluster%e8%bf%9b%e8%a1%8c%e6%9e%84%e5%bb%ba%e5%92%8c%e4%bd%bf%e7%94%a8mysqld_exporter%e8%bf%9b%e8%a1%8c%e7%9b%91%e8%a7%86\/","name":"\u4f7f\u7528Galera Cluster\u8fdb\u884c\u6784\u5efa\u548c\u4f7f\u7528mysqld_exporter\u8fdb\u884c\u76d1\u89c6 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2024-02-01T13:57:10+00:00","dateModified":"2024-04-30T03:28:07+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8galera-cluster%e8%bf%9b%e8%a1%8c%e6%9e%84%e5%bb%ba%e5%92%8c%e4%bd%bf%e7%94%a8mysqld_exporter%e8%bf%9b%e8%a1%8c%e7%9b%91%e8%a7%86\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8galera-cluster%e8%bf%9b%e8%a1%8c%e6%9e%84%e5%bb%ba%e5%92%8c%e4%bd%bf%e7%94%a8mysqld_exporter%e8%bf%9b%e8%a1%8c%e7%9b%91%e8%a7%86\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8galera-cluster%e8%bf%9b%e8%a1%8c%e6%9e%84%e5%bb%ba%e5%92%8c%e4%bd%bf%e7%94%a8mysqld_exporter%e8%bf%9b%e8%a1%8c%e7%9b%91%e8%a7%86\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u4f7f\u7528Galera Cluster\u8fdb\u884c\u6784\u5efa\u548c\u4f7f\u7528mysqld_exporter\u8fdb\u884c\u76d1\u89c6"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e","name":"\u97f5, \u79d1","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g","caption":"\u97f5, \u79d1"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunke\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8galera-cluster%e8%bf%9b%e8%a1%8c%e6%9e%84%e5%bb%ba%e5%92%8c%e4%bd%bf%e7%94%a8mysqld_exporter%e8%bf%9b%e8%a1%8c%e7%9b%91%e8%a7%86\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/43410","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=43410"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/43410\/revisions"}],"predecessor-version":[{"id":91635,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/43410\/revisions\/91635"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=43410"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=43410"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=43410"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}