{"id":28532,"date":"2023-02-26T22:12:37","date_gmt":"2023-04-25T15:13:51","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%90%ad%e5%bb%bamariadb-galera%e9%9b%86%e7%be%a4%e3%80%82\/"},"modified":"2025-08-12T08:41:44","modified_gmt":"2025-08-12T00:41:44","slug":"%e6%90%ad%e5%bb%bamariadb-galera%e9%9b%86%e7%be%a4%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%90%ad%e5%bb%bamariadb-galera%e9%9b%86%e7%be%a4%e3%80%82\/","title":{"rendered":"\u642d\u5efaMariaDB Galera\u96c6\u7fa4"},"content":{"rendered":"<p>\u4ee5\u4e0b\u662f\u4f7f\u7528Galera Cluster\u53ef\u4ee5\u5f88\u5bb9\u6613\u5730\u642d\u5efa\u591a\u4e2a\u4e3b\u6570\u636e\u5e93\u7684\u6784\u5efa\u5907\u5fd8\u5f55\u3002<\/p>\n<p>\u56e0\u6b64\uff0c\u6211\u5c07\u591a\u500b\u5be6\u4f8b\u639b\u8f09\u5230LB\u4e0b\uff0c\u4e26\u8b93\u6bcf\u500b\u5be6\u4f8b\u540c\u6642\u904b\u884cAP\u670d\u52d9\u5668\u548cDB\u670d\u52d9\u5668\uff0c\u4e26\u5617\u8a66\u5728\u6bcf\u500b\u5be6\u4f8b\u4e0a\u9032\u884c\u66f4\u65b0\u548c\u67e5\u8a62\u3002<\/p>\n<p>\u56e0\u4e3a\u60f3\u5c1d\u8bd5\u5728PostgreSQL\u4e0a\u6784\u5efa\u591a\u4e3b\u6570\u636e\u5e93\u7ed3\u6784\uff0c\u4f46\u611f\u89c9\u592a\u96be\u4e86\uff0c\u6240\u4ee5\u5c1d\u8bd5\u4e86\u770b\u8d77\u6765\u7b80\u5355\u7684MariaDB\u3002<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">OS: CentOS7, \u6700\u5c0f3\u53f0\u3067\u69cb\u7bc9<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">MariaDB: 10.3.8<\/ul>\n<p>\u8fd9\u7bc7\u6587\u7ae0\u975e\u5e38\u6709\u53c2\u8003\u4ef7\u503c\u3002<br \/>\n\u5b9e\u9645\u4e0a\u51e0\u4e4e\u6210\u4e86\u6284\u88ad\u3002<br \/>\nhttp:\/\/www.orangetakam.com\/blog\/archives\/1403<\/p>\n<h2>\u64cd\u4f5c\u7cfb\u7edf\u51c6\u5907\u5b8c\u6210\u3002<\/p>\n<h3>Vagrantfile\u7684\u914d\u7f6e<\/p>\n<pre class=\"post-pre\"><code><span class=\"c1\"># *- mode: ruby -*-<\/span>\r\n<span class=\"c1\"># vi: set ft=ruby :<\/span>\r\n\r\n<span class=\"no\">Vagrant<\/span><span class=\"p\">.<\/span><span class=\"nf\">configure<\/span><span class=\"p\">(<\/span><span class=\"s2\">\"2\"<\/span><span class=\"p\">)<\/span> <span class=\"k\">do<\/span> <span class=\"o\">|<\/span><span class=\"n\">config<\/span><span class=\"o\">|<\/span>\r\n\r\n  <span class=\"n\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">vm<\/span><span class=\"p\">.<\/span><span class=\"nf\">define<\/span> <span class=\"s2\">\"db1\"<\/span> <span class=\"k\">do<\/span> <span class=\"o\">|<\/span><span class=\"n\">node<\/span><span class=\"o\">|<\/span>\r\n    <span class=\"n\">node<\/span><span class=\"p\">.<\/span><span class=\"nf\">vm<\/span><span class=\"p\">.<\/span><span class=\"nf\">provider<\/span> <span class=\"s2\">\"virtualbox\"<\/span> <span class=\"k\">do<\/span> <span class=\"o\">|<\/span><span class=\"n\">vm<\/span><span class=\"o\">|<\/span>\r\n      <span class=\"n\">vm<\/span><span class=\"p\">.<\/span><span class=\"nf\">name<\/span> <span class=\"o\">=<\/span> <span class=\"s2\">\"db1\"<\/span>\r\n      <span class=\"n\">vm<\/span><span class=\"p\">.<\/span><span class=\"nf\">customize<\/span> <span class=\"p\">[<\/span><span class=\"s2\">\"modifyvm\"<\/span><span class=\"p\">,<\/span> <span class=\"ss\">:id<\/span><span class=\"p\">,<\/span> <span class=\"s2\">\"--memory\"<\/span><span class=\"p\">,<\/span> <span class=\"s2\">\"2048\"<\/span><span class=\"p\">]<\/span>\r\n    <span class=\"k\">end<\/span>\r\n    <span class=\"n\">node<\/span><span class=\"p\">.<\/span><span class=\"nf\">vm<\/span><span class=\"p\">.<\/span><span class=\"nf\">box<\/span> <span class=\"o\">=<\/span> <span class=\"s2\">\"centos\/7\"<\/span>\r\n    <span class=\"n\">node<\/span><span class=\"p\">.<\/span><span class=\"nf\">vm<\/span><span class=\"p\">.<\/span><span class=\"nf\">hostname<\/span> <span class=\"o\">=<\/span> <span class=\"s2\">\"db1\"<\/span>\r\n    <span class=\"n\">node<\/span><span class=\"p\">.<\/span><span class=\"nf\">vm<\/span><span class=\"p\">.<\/span><span class=\"nf\">network<\/span> <span class=\"s2\">\"private_network\"<\/span><span class=\"p\">,<\/span> <span class=\"ss\">ip: <\/span><span class=\"s2\">\"192.168.56.10\"<\/span>\r\n  <span class=\"k\">end<\/span>\r\n\r\n  <span class=\"n\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">vm<\/span><span class=\"p\">.<\/span><span class=\"nf\">define<\/span> <span class=\"s2\">\"db2\"<\/span> <span class=\"k\">do<\/span> <span class=\"o\">|<\/span><span class=\"n\">node<\/span><span class=\"o\">|<\/span>\r\n    <span class=\"n\">node<\/span><span class=\"p\">.<\/span><span class=\"nf\">vm<\/span><span class=\"p\">.<\/span><span class=\"nf\">provider<\/span> <span class=\"s2\">\"virtualbox\"<\/span> <span class=\"k\">do<\/span> <span class=\"o\">|<\/span><span class=\"n\">vm<\/span><span class=\"o\">|<\/span>\r\n      <span class=\"n\">vm<\/span><span class=\"p\">.<\/span><span class=\"nf\">name<\/span> <span class=\"o\">=<\/span> <span class=\"s2\">\"db2\"<\/span>\r\n      <span class=\"n\">vm<\/span><span class=\"p\">.<\/span><span class=\"nf\">customize<\/span> <span class=\"p\">[<\/span><span class=\"s2\">\"modifyvm\"<\/span><span class=\"p\">,<\/span> <span class=\"ss\">:id<\/span><span class=\"p\">,<\/span> <span class=\"s2\">\"--memory\"<\/span><span class=\"p\">,<\/span> <span class=\"s2\">\"2048\"<\/span><span class=\"p\">]<\/span>\r\n    <span class=\"k\">end<\/span>\r\n    <span class=\"n\">node<\/span><span class=\"p\">.<\/span><span class=\"nf\">vm<\/span><span class=\"p\">.<\/span><span class=\"nf\">box<\/span> <span class=\"o\">=<\/span> <span class=\"s2\">\"centos\/7\"<\/span>\r\n    <span class=\"n\">node<\/span><span class=\"p\">.<\/span><span class=\"nf\">vm<\/span><span class=\"p\">.<\/span><span class=\"nf\">hostname<\/span> <span class=\"o\">=<\/span> <span class=\"s2\">\"db2\"<\/span>\r\n    <span class=\"n\">node<\/span><span class=\"p\">.<\/span><span class=\"nf\">vm<\/span><span class=\"p\">.<\/span><span class=\"nf\">network<\/span> <span class=\"s2\">\"private_network\"<\/span><span class=\"p\">,<\/span> <span class=\"ss\">ip: <\/span><span class=\"s2\">\"192.168.56.20\"<\/span>\r\n  <span class=\"k\">end<\/span>\r\n\r\n  <span class=\"n\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">vm<\/span><span class=\"p\">.<\/span><span class=\"nf\">define<\/span> <span class=\"s2\">\"db3\"<\/span> <span class=\"k\">do<\/span> <span class=\"o\">|<\/span><span class=\"n\">node<\/span><span class=\"o\">|<\/span>\r\n    <span class=\"n\">node<\/span><span class=\"p\">.<\/span><span class=\"nf\">vm<\/span><span class=\"p\">.<\/span><span class=\"nf\">provider<\/span> <span class=\"s2\">\"virtualbox\"<\/span> <span class=\"k\">do<\/span> <span class=\"o\">|<\/span><span class=\"n\">vm<\/span><span class=\"o\">|<\/span>\r\n      <span class=\"n\">vm<\/span><span class=\"p\">.<\/span><span class=\"nf\">name<\/span> <span class=\"o\">=<\/span> <span class=\"s2\">\"db3\"<\/span>\r\n      <span class=\"n\">vm<\/span><span class=\"p\">.<\/span><span class=\"nf\">customize<\/span> <span class=\"p\">[<\/span><span class=\"s2\">\"modifyvm\"<\/span><span class=\"p\">,<\/span> <span class=\"ss\">:id<\/span><span class=\"p\">,<\/span> <span class=\"s2\">\"--memory\"<\/span><span class=\"p\">,<\/span> <span class=\"s2\">\"2048\"<\/span><span class=\"p\">]<\/span>\r\n    <span class=\"k\">end<\/span>\r\n    <span class=\"n\">node<\/span><span class=\"p\">.<\/span><span class=\"nf\">vm<\/span><span class=\"p\">.<\/span><span class=\"nf\">box<\/span> <span class=\"o\">=<\/span> <span class=\"s2\">\"centos\/7\"<\/span>\r\n    <span class=\"n\">node<\/span><span class=\"p\">.<\/span><span class=\"nf\">vm<\/span><span class=\"p\">.<\/span><span class=\"nf\">hostname<\/span> <span class=\"o\">=<\/span> <span class=\"s2\">\"db3\"<\/span>\r\n    <span class=\"n\">node<\/span><span class=\"p\">.<\/span><span class=\"nf\">vm<\/span><span class=\"p\">.<\/span><span class=\"nf\">network<\/span> <span class=\"s2\">\"private_network\"<\/span><span class=\"p\">,<\/span> <span class=\"ss\">ip: <\/span><span class=\"s2\">\"192.168.56.30\"<\/span>\r\n  <span class=\"k\">end<\/span>\r\n\r\n<span class=\"k\">end<\/span>\r\n<\/code><\/pre>\n<h3>\u64cd\u4f5c\u7cfb\u7edf\u542f\u52a8<\/p>\n<pre class=\"post-pre\"><code>vagrant up db1 db2 db3\r\n<\/code><\/pre>\n<h3>\u7981\u7528SELINUX\u60a8\u9700\u8981\u6309\u7167\u4ee5\u4e0b\u65b9\u5f0f\u7f16\u8f91\/etc\/sysconfig\/selinux\u5e76\u91cd\u65b0\u542f\u52a8\u3002<\/p>\n<pre class=\"post-pre\"><code>SELINUX=disabled\r\nSELINUXTYPE=targeted\r\n<\/code><\/pre>\n<h2>MariaDB\u7684\u5b89\u88c5\u8bf7\u6267\u884c\u4ee5\u4e0b\u4eceDB1\u5230DB3\u7684\u6240\u6709\u5de5\u4f5c\u3002<\/p>\n<h3>\u5220\u9664\u5df2\u6346\u7ed1\u7684MariaDB\u3002<\/p>\n<pre class=\"post-pre\"><code>sudo yum info mariadb-libs.x86_64\r\nsudo yum -y remove mariadb-libs.x86_64\r\n<\/code><\/pre>\n<h3>\u914d\u7f6e\u4ed3\u5e93<\/p>\n<pre class=\"post-pre\"><code>curl -sS https:\/\/downloads.mariadb.com\/MariaDB\/mariadb_repo_setup | sudo bash\r\n<\/code><\/pre>\n<h3>\u5b89\u88c5\u6700\u65b0\u7248\u7684MariaDB\u3002<\/p>\n<pre class=\"post-pre\"><code>sudo yum -y install MariaDB-server MariaDB-client\r\n<\/code><\/pre>\n<h3>MariaDB\u7684\u521d\u59cb\u8a2d\u7f6e<\/p>\n<pre class=\"post-pre\"><code>sudo systemctl disable mariadb\r\nsudo systemctl start mariadb\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>sudo mysql_secure_installation\r\n\r\nNOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB\r\n      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!\r\n\r\nIn order to log into MariaDB to secure it, we'll need the current\r\npassword for the root user.  If you've just installed MariaDB, and\r\nyou haven't set the root password yet, the password will be blank,\r\nso you should just press enter here.\r\n\r\nEnter current password for root (enter for none):\r\nOK, successfully used password, moving on...\r\n\r\nSetting the root password ensures that nobody can log into the MariaDB\r\nroot user without the proper authorisation.\r\n\r\nSet root password? [Y\/n] Y\r\nNew password: Pass@0077\r\nRe-enter new password: Pass@0077\r\nPassword updated successfully!\r\nReloading privilege tables..\r\n ... Success!\r\n\r\n\r\nBy default, a MariaDB installation has an anonymous user, allowing anyone\r\nto log into MariaDB without having to have a user account created for\r\nthem.  This is intended only for testing, and to make the installation\r\ngo a bit smoother.  You should remove them before moving into a\r\nproduction environment.\r\n\r\nRemove anonymous users? [Y\/n] Y\r\n ... Success!\r\n\r\nNormally, root should only be allowed to connect from 'localhost'.  This\r\nensures that someone cannot guess at the root password from the network.\r\n\r\nDisallow root login remotely? [Y\/n] Y\r\n ... Success!\r\n\r\nBy default, MariaDB comes with a database named 'test' that anyone can\r\naccess.  This is also intended only for testing, and should be removed\r\nbefore moving into a production environment.\r\n\r\nRemove test database and access to it? [Y\/n] Y\r\n - Dropping test database...\r\n ... Success!\r\n - Removing privileges on test database...\r\n ... Success!\r\n\r\nReloading the privilege tables will ensure that all changes made so far\r\nwill take effect immediately.\r\n\r\nReload privilege tables now? [Y\/n] Y\r\n ... Success!\r\n\r\nCleaning up...\r\n\r\nAll done!  If you've completed all of the above steps, your MariaDB\r\ninstallation should now be secure.\r\n\r\nThanks for using MariaDB!\r\n<\/code><\/pre>\n<h3>\u505c\u6b62MariaDB\u6211\u8981\u5728\u7a0d\u540e\u4f7f\u7528Galera Cluster\u8fdb\u884c\u542f\u52a8\uff0c\u6240\u4ee5\u8bf7\u5148\u505c\u6b62\u5b83\u3002<\/p>\n<pre class=\"post-pre\"><code>sudo systemctl stop mariadb\r\n<\/code><\/pre>\n<h2>Galera Cluster\u7684\u521d\u59cb\u8bbe\u7f6e\u4f4d\u4e8e\/etc\/my.cnf.d\/server.cnf\u4e2d\u3002<\/p>\n<h3>db1\u7684\u521d\u59cb\u8bbe\u7f6e<\/p>\n<pre class=\"post-pre\"><code>sudo vi \/etc\/my.cnf.d\/server.cnf\r\n\r\nsudo mkdir -p \/var\/log\/mariadb\r\nsudo chown -R mysql:mysql \/var\/log\/mariadb\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>[server]\r\n\r\n[mysqld]\r\ncharacter-set-server=utf8\r\n\r\nlog-output=FILE\r\n\r\n# Error log\r\nlog-error=\"\/var\/log\/mariadb\/mysqld.log\"\r\n\r\n# Query log\r\ngeneral-log=0\r\ngeneral_log_file=\"\/var\/log\/mariadb\/sql.log\"\r\n\r\n# Slow Query log\r\nslow-query-log=1\r\nslow_query_log_file=\"\/var\/log\/mariadb\/slow.log\"\r\nlog_queries_not_using_indexes\r\nlog_slow_admin_statements\r\nlong_query_time=10\r\n\r\n[galera]\r\nwsrep_node_address=192.168.56.10\r\nwsrep_node_name=db1\r\n\r\nwsrep_cluster_address='gcomm:\/\/192.168.56.10,192.168.56.20,192.168.56.30'\r\n\r\nwsrep_cluster_name=DevelopCluster\r\n\r\nwsrep_provider=\/usr\/lib64\/galera\/libgalera_smm.so\r\n\r\nbinlog_format=row\r\n\r\ndefault_storage_engine=InnoDB\r\n\r\ninnodb_autoinc_lock_mode=2\r\n\r\nwsrep_on=ON\r\n\r\nwsrep_sst_method=rsync\r\n\r\nwsrep_slave_threads=2\r\n\r\ninnodb_locks_unsafe_for_binlog=1\r\n\r\n[embedded]\r\n\r\n[mariadb]\r\n\r\n[mariadb-10.3]\r\n<\/code><\/pre>\n<h3>DB2\u7684\u521d\u59cb\u8bbe\u7f6e<\/p>\n<pre class=\"post-pre\"><code>sudo vi \/etc\/my.cnf.d\/server.cnf\r\n\r\nsudo mkdir \/var\/log\/mariadb\r\nsudo chown -R mysql:mysql \/var\/log\/mariadb\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>[server]\r\n\r\n[mysqld]\r\ncharacter-set-server=utf8\r\n\r\nlog-output=FILE\r\n\r\n# Error log\r\nlog-error=\"\/var\/log\/mariadb\/mysqld.log\"\r\n\r\n# Query log\r\ngeneral-log=0\r\ngeneral_log_file=\"\/var\/log\/mariadb\/sql.log\"\r\n\r\n# Slow Query log\r\nslow-query-log=1\r\nslow_query_log_file=\"\/var\/log\/mariadb\/slow.log\"\r\nlog_queries_not_using_indexes\r\nlog_slow_admin_statements\r\nlong_query_time=10\r\n\r\n[galera]\r\nwsrep_node_address=192.168.56.20\r\nwsrep_node_name=db2\r\n\r\nwsrep_cluster_address='gcomm:\/\/192.168.56.10,192.168.56.20,192.168.56.30'\r\n\r\nwsrep_cluster_name=DevelopCluster\r\n\r\nwsrep_provider=\/usr\/lib64\/galera\/libgalera_smm.so\r\n\r\nbinlog_format=row\r\n\r\ndefault_storage_engine=InnoDB\r\n\r\ninnodb_autoinc_lock_mode=2\r\n\r\nwsrep_on=ON\r\n\r\nwsrep_sst_method=rsync\r\n\r\nwsrep_slave_threads=2\r\n\r\ninnodb_locks_unsafe_for_binlog=1\r\n\r\n[embedded]\r\n\r\n[mariadb]\r\n\r\n[mariadb-10.3]\r\n<\/code><\/pre>\n<h3>db3\u7684\u521d\u59cb\u8bbe\u7f6e<\/p>\n<pre class=\"post-pre\"><code>sudo vi \/etc\/my.cnf.d\/server.cnf\r\n\r\nsudo mkdir -p \/var\/log\/mariadb\r\nsudo chown -R mysql:mysql \/var\/log\/mariadb\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>[server]\r\n\r\n[mysqld]\r\ncharacter-set-server=utf8\r\n\r\nlog-output=FILE\r\n\r\n# Error log\r\nlog-error=\"\/var\/log\/mariadb\/mysqld.log\"\r\n\r\n# Query log\r\ngeneral-log=0\r\ngeneral_log_file=\"\/var\/log\/mariadb\/sql.log\"\r\n\r\n\r\n# Slow Query log\r\nslow-query-log=1\r\nslow_query_log_file=\"\/var\/log\/mariadb\/slow.log\"\r\nlog_queries_not_using_indexes\r\nlog_slow_admin_statements\r\nlong_query_time=10\r\n\r\n[galera]\r\nwsrep_node_address=192.168.56.30\r\nwsrep_node_name=db3\r\n\r\nwsrep_cluster_address='gcomm:\/\/192.168.56.10,192.168.56.20,192.168.56.30'\r\n\r\nwsrep_cluster_name=DevelopCluster\r\n\r\nwsrep_provider=\/usr\/lib64\/galera\/libgalera_smm.so\r\n\r\nbinlog_format=row\r\n\r\ndefault_storage_engine=InnoDB\r\n\r\ninnodb_autoinc_lock_mode=2\r\n\r\nwsrep_on=ON\r\n\r\nwsrep_sst_method=rsync\r\n\r\nwsrep_slave_threads=2\r\n\r\ninnodb_locks_unsafe_for_binlog=1\r\n\r\n[embedded]\r\n\r\n[mariadb]\r\n\r\n[mariadb-10.3]\r\n<\/code><\/pre>\n<h2>\u542f\u52a8Galera\u96c6\u7fa4<\/p>\n<h3>\u786e\u8ba4\u542f\u52a8MariaDB Galera Cluster\u4e2d\u7684db1\u8282\u70b9<br \/>\n\u8fd9\u662f\u5bf9db1\u7684\u542f\u52a8\u786e\u8ba4\u3002<br \/>\n\u6b64\u65f6\uff0cdb2\u548cdb3\u5904\u4e8e\u505c\u6b62\u72b6\u6001\u3002<\/p>\n<p>\u5728Galera Cluster\u4e2d\uff0c\u5982\u679c\u521d\u59cb\u914d\u7f6e\u6587\u4ef6\u4e2d\u7684&#8221;wsrep_cluster_address&#8221;\u6240\u63cf\u8ff0\u7684\u8282\u70b9\u6ca1\u6709\u542f\u52a8\uff0c\u5c31\u65e0\u6cd5\u542f\u52a8\u3002\u5f53\u542f\u52a8\u7b2c\u4e00\u4e2a\u8282\u70b9\uff08\u5373\u7b2c\u4e00\u8282\u70b9\uff09\u65f6\uff0c\u5176\u4ed6\u8282\u70b9\u90fd\u5fc5\u987b\u5904\u4e8e\u505c\u6b62\u72b6\u6001\u3002<\/p>\n<p>\u9996\u5148\uff0c\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528galera_new_cluster\u547d\u4ee4\u6765\u542f\u52a8\u7b2c\u4e00\u4e2a\u8282\u70b9\u3002<\/p>\n<pre class=\"post-pre\"><code>sudo galera_new_cluster\r\n<\/code><\/pre>\n<p>\u8bf7\u6267\u884c&#8221;show status like &#8216;wsrep_%&#8217;;&#8221;\uff0c\u4ee5\u786e\u8ba4\u4ee5\u4e0b\u4e8b\u9879\u3002<\/p>\n<p>[\u786e\u8ba4\u4e8b\u9879]<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">wsrep_cluster_status: Primary<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">wsrep_incoming_addresses: \u8a2d\u5b9a\u3057\u305f\u30a2\u30c9\u30ec\u30b9<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">wsrep_local_state_comment: Synced<\/ul>\n<pre class=\"post-pre\"><code>[vagrant@db1 my.cnf.d]$ mysql -u root -p\r\nEnter password:\r\n\r\nMariaDB [(none)]&gt; show status like 'wsrep_%';\r\n+------------------------------+--------------------------------------+\r\n| Variable_name                | Value                                |\r\n+------------------------------+--------------------------------------+\r\n| wsrep_apply_oooe             | 0.000000                             |\r\n| wsrep_apply_oool             | 0.000000                             |\r\n| wsrep_apply_window           | 0.000000                             |\r\n| wsrep_causal_reads           | 0                                    |\r\n| wsrep_cert_deps_distance     | 0.000000                             |\r\n| wsrep_cert_index_size        | 0                                    |\r\n| wsrep_cert_interval          | 0.000000                             |\r\n| wsrep_cluster_conf_id        | 1                                    |\r\n| wsrep_cluster_size           | 1                                    |\r\n| wsrep_cluster_state_uuid     | 5ea4eb1f-8bff-11e8-934d-7aa2eaa06ac1 |\r\n| wsrep_cluster_status         | Primary                              |\r\n| wsrep_commit_oooe            | 0.000000                             |\r\n| wsrep_commit_oool            | 0.000000                             |\r\n| wsrep_commit_window          | 0.000000                             |\r\n| wsrep_connected              | ON                                   |\r\n| wsrep_desync_count           | 0                                    |\r\n| wsrep_evs_delayed            |                                      |\r\n| wsrep_evs_evict_list         |                                      |\r\n| wsrep_evs_repl_latency       | 0\/0\/0\/0\/0                            |\r\n| wsrep_evs_state              | OPERATIONAL                          |\r\n| wsrep_flow_control_paused    | 0.000000                             |\r\n| wsrep_flow_control_paused_ns | 0                                    |\r\n| wsrep_flow_control_recv      | 0                                    |\r\n| wsrep_flow_control_sent      | 0                                    |\r\n| wsrep_gcomm_uuid             | 5ea35535-8bff-11e8-90ef-6b5cfed70296 |\r\n| wsrep_incoming_addresses     | 192.168.56.10:3306                   |\r\n| wsrep_last_committed         | 0                                    |\r\n| wsrep_local_bf_aborts        | 0                                    |\r\n| wsrep_local_cached_downto    | 18446744073709551615                 |\r\n| wsrep_local_cert_failures    | 0                                    |\r\n| wsrep_local_commits          | 0                                    |\r\n| wsrep_local_index            | 0                                    |\r\n| wsrep_local_recv_queue       | 0                                    |\r\n| wsrep_local_recv_queue_avg   | 0.500000                             |\r\n| wsrep_local_recv_queue_max   | 2                                    |\r\n| wsrep_local_recv_queue_min   | 0                                    |\r\n| wsrep_local_replays          | 0                                    |\r\n| wsrep_local_send_queue       | 0                                    |\r\n| wsrep_local_send_queue_avg   | 0.000000                             |\r\n| wsrep_local_send_queue_max   | 1                                    |\r\n| wsrep_local_send_queue_min   | 0                                    |\r\n| wsrep_local_state            | 4                                    |\r\n| wsrep_local_state_comment    | Synced                               |\r\n| wsrep_local_state_uuid       | 5ea4eb1f-8bff-11e8-934d-7aa2eaa06ac1 |\r\n| wsrep_protocol_version       | 8                                    |\r\n| wsrep_provider_name          | Galera                               |\r\n| wsrep_provider_vendor        | Codership Oy &lt;info@codership.com&gt;    |\r\n| wsrep_provider_version       | 25.3.23(r3789)                       |\r\n| wsrep_ready                  | ON                                   |\r\n| wsrep_received               | 2                                    |\r\n| wsrep_received_bytes         | 140                                  |\r\n| wsrep_repl_data_bytes        | 0                                    |\r\n| wsrep_repl_keys              | 0                                    |\r\n| wsrep_repl_keys_bytes        | 0                                    |\r\n| wsrep_repl_other_bytes       | 0                                    |\r\n| wsrep_replicated             | 0                                    |\r\n| wsrep_replicated_bytes       | 0                                    |\r\n| wsrep_thread_count           | 3                                    |\r\n+------------------------------+--------------------------------------+\r\n58 rows in set (0.001 sec)\r\n\r\nMariaDB [(none)]&gt; exit\r\n<\/code><\/pre>\n<h3>\u786e\u8ba4db2\u7684MariaDB Galera Cluster\u662f\u5426\u5df2\u542f\u52a8<br \/>\n\u8bf7\u786e\u8ba4DB2\u7684\u542f\u52a8\u60c5\u51b5\u3002<br \/>\n\u5728\u6b64\u65f6\uff0cDB1\u5df2\u7ecf\u542f\u52a8\uff0cDB3\u5904\u4e8e\u505c\u6b62\u72b6\u6001\u3002<\/p>\n<pre class=\"post-pre\"><code>sudo systemctl start mariadb\r\n<\/code><\/pre>\n<p>\u8bf7\u786e\u8ba4\u60a8\u5df2\u7ecf\u6210\u529f\u52a0\u5165\u4e86\u96c6\u7fa4\u3002<\/p>\n<pre class=\"post-pre\"><code>$ mysql -u root -p\r\nEnter password:\r\nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\r\nYour MariaDB connection id is 11\r\nServer version: 10.3.8-MariaDB MariaDB Server\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)]&gt; show status like 'wsrep_%';\r\n+------------------------------+---------------------------------------+\r\n| Variable_name                | Value                                 |\r\n+------------------------------+---------------------------------------+\r\n| wsrep_apply_oooe             | 0.000000                              |\r\n| wsrep_apply_oool             | 0.000000                              |\r\n| wsrep_apply_window           | 0.000000                              |\r\n| wsrep_causal_reads           | 0                                     |\r\n| wsrep_cert_deps_distance     | 0.000000                              |\r\n| wsrep_cert_index_size        | 0                                     |\r\n| wsrep_cert_interval          | 0.000000                              |\r\n| wsrep_cluster_conf_id        | 2                                     |\r\n| wsrep_cluster_size           | 2                                     |\r\n| wsrep_cluster_state_uuid     | 5ea4eb1f-8bff-11e8-934d-7aa2eaa06ac1  |\r\n| wsrep_cluster_status         | Primary                               |\r\n| wsrep_commit_oooe            | 0.000000                              |\r\n| wsrep_commit_oool            | 0.000000                              |\r\n| wsrep_commit_window          | 0.000000                              |\r\n| wsrep_connected              | ON                                    |\r\n| wsrep_desync_count           | 0                                     |\r\n| wsrep_evs_delayed            |                                       |\r\n| wsrep_evs_evict_list         |                                       |\r\n| wsrep_evs_repl_latency       | 0\/0\/0\/0\/0                             |\r\n| wsrep_evs_state              | OPERATIONAL                           |\r\n| wsrep_flow_control_paused    | 0.000000                              |\r\n| wsrep_flow_control_paused_ns | 0                                     |\r\n| wsrep_flow_control_recv      | 0                                     |\r\n| wsrep_flow_control_sent      | 0                                     |\r\n| wsrep_gcomm_uuid             | 58f28b22-8c03-11e8-b913-db00a1269d15  |\r\n| wsrep_incoming_addresses     | 192.168.56.10:3306,192.168.56.20:3306 |\r\n| wsrep_last_committed         | 0                                     |\r\n| wsrep_local_bf_aborts        | 0                                     |\r\n| wsrep_local_cached_downto    | 18446744073709551615                  |\r\n| wsrep_local_cert_failures    | 0                                     |\r\n| wsrep_local_commits          | 0                                     |\r\n| wsrep_local_index            | 1                                     |\r\n| wsrep_local_recv_queue       | 0                                     |\r\n| wsrep_local_recv_queue_avg   | 0.000000                              |\r\n| wsrep_local_recv_queue_max   | 1                                     |\r\n| wsrep_local_recv_queue_min   | 0                                     |\r\n| wsrep_local_replays          | 0                                     |\r\n| wsrep_local_send_queue       | 0                                     |\r\n| wsrep_local_send_queue_avg   | 0.000000                              |\r\n| wsrep_local_send_queue_max   | 1                                     |\r\n| wsrep_local_send_queue_min   | 0                                     |\r\n| wsrep_local_state            | 4                                     |\r\n| wsrep_local_state_comment    | Synced                                |\r\n| wsrep_local_state_uuid       | 5ea4eb1f-8bff-11e8-934d-7aa2eaa06ac1  |\r\n| wsrep_protocol_version       | 8                                     |\r\n| wsrep_provider_name          | Galera                                |\r\n| wsrep_provider_vendor        | Codership Oy &lt;info@codership.com&gt;     |\r\n| wsrep_provider_version       | 25.3.23(r3789)                        |\r\n| wsrep_ready                  | ON                                    |\r\n| wsrep_received               | 3                                     |\r\n| wsrep_received_bytes         | 216                                   |\r\n| wsrep_repl_data_bytes        | 0                                     |\r\n| wsrep_repl_keys              | 0                                     |\r\n| wsrep_repl_keys_bytes        | 0                                     |\r\n| wsrep_repl_other_bytes       | 0                                     |\r\n| wsrep_replicated             | 0                                     |\r\n| wsrep_replicated_bytes       | 0                                     |\r\n| wsrep_thread_count           | 3                                     |\r\n+------------------------------+---------------------------------------+\r\n58 rows in set (0.001 sec)\r\n\r\nMariaDB [(none)]&gt; exit\r\n<\/code><\/pre>\n<h3>\u786e\u8ba4\u542f\u52a8db3\u4e0a\u7684MariaDB Galera Cluster\u3002<br \/>\n\u8fd9\u662f\u7528\u4e8e\u786e\u8ba4DB3\u662f\u5426\u5df2\u542f\u52a8\u7684\u6b65\u9aa4\u3002<\/p>\n<pre class=\"post-pre\"><code>sudo systemctl start  mariadb\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>mysql -u root -p\r\nEnter password:\r\nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\r\nYour MariaDB connection id is 11\r\nServer version: 10.3.8-MariaDB MariaDB Server\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)]&gt; show status like 'wsrep_%';\r\n+------------------------------+----------------------------------------------------------+\r\n| Variable_name                | Value                                                    |\r\n+------------------------------+----------------------------------------------------------+\r\n| wsrep_apply_oooe             | 0.000000                                                 |\r\n| wsrep_apply_oool             | 0.000000                                                 |\r\n| wsrep_apply_window           | 0.000000                                                 |\r\n| wsrep_causal_reads           | 0                                                        |\r\n| wsrep_cert_deps_distance     | 0.000000                                                 |\r\n| wsrep_cert_index_size        | 0                                                        |\r\n| wsrep_cert_interval          | 0.000000                                                 |\r\n| wsrep_cluster_conf_id        | 3                                                        |\r\n| wsrep_cluster_size           | 3                                                        |\r\n| wsrep_cluster_state_uuid     | 5ea4eb1f-8bff-11e8-934d-7aa2eaa06ac1                     |\r\n| wsrep_cluster_status         | Primary                                                  |\r\n| wsrep_commit_oooe            | 0.000000                                                 |\r\n| wsrep_commit_oool            | 0.000000                                                 |\r\n| wsrep_commit_window          | 0.000000                                                 |\r\n| wsrep_connected              | ON                                                       |\r\n| wsrep_desync_count           | 0                                                        |\r\n| wsrep_evs_delayed            |                                                          |\r\n| wsrep_evs_evict_list         |                                                          |\r\n| wsrep_evs_repl_latency       | 0.000878738\/0.00319743\/0.00973027\/0.003294\/5             |\r\n| wsrep_evs_state              | OPERATIONAL                                              |\r\n| wsrep_flow_control_paused    | 0.000000                                                 |\r\n| wsrep_flow_control_paused_ns | 0                                                        |\r\n| wsrep_flow_control_recv      | 0                                                        |\r\n| wsrep_flow_control_sent      | 0                                                        |\r\n| wsrep_gcomm_uuid             | f93e0362-8c03-11e8-b220-a3600473017a                     |\r\n| wsrep_incoming_addresses     | 192.168.56.10:3306,192.168.56.20:3306,192.168.56.30:3306 |\r\n| wsrep_last_committed         | 0                                                        |\r\n| wsrep_local_bf_aborts        | 0                                                        |\r\n| wsrep_local_cached_downto    | 18446744073709551615                                     |\r\n| wsrep_local_cert_failures    | 0                                                        |\r\n| wsrep_local_commits          | 0                                                        |\r\n| wsrep_local_index            | 2                                                        |\r\n| wsrep_local_recv_queue       | 0                                                        |\r\n| wsrep_local_recv_queue_avg   | 0.000000                                                 |\r\n| wsrep_local_recv_queue_max   | 1                                                        |\r\n| wsrep_local_recv_queue_min   | 0                                                        |\r\n| wsrep_local_replays          | 0                                                        |\r\n| wsrep_local_send_queue       | 0                                                        |\r\n| wsrep_local_send_queue_avg   | 0.000000                                                 |\r\n| wsrep_local_send_queue_max   | 1                                                        |\r\n| wsrep_local_send_queue_min   | 0                                                        |\r\n| wsrep_local_state            | 4                                                        |\r\n| wsrep_local_state_comment    | Synced                                                   |\r\n| wsrep_local_state_uuid       | 5ea4eb1f-8bff-11e8-934d-7aa2eaa06ac1                     |\r\n| wsrep_protocol_version       | 8                                                        |\r\n| wsrep_provider_name          | Galera                                                   |\r\n| wsrep_provider_vendor        | Codership Oy &lt;info@codership.com&gt;                        |\r\n| wsrep_provider_version       | 25.3.23(r3789)                                           |\r\n| wsrep_ready                  | ON                                                       |\r\n| wsrep_received               | 3                                                        |\r\n| wsrep_received_bytes         | 284                                                      |\r\n| wsrep_repl_data_bytes        | 0                                                        |\r\n| wsrep_repl_keys              | 0                                                        |\r\n| wsrep_repl_keys_bytes        | 0                                                        |\r\n| wsrep_repl_other_bytes       | 0                                                        |\r\n| wsrep_replicated             | 0                                                        |\r\n| wsrep_replicated_bytes       | 0                                                        |\r\n| wsrep_thread_count           | 3                                                        |\r\n+------------------------------+----------------------------------------------------------+\r\n58 rows in set (0.001 sec)\r\n\r\nMariaDB [(none)]&gt; exit\r\n<\/code><\/pre>\n<h2>\u786e\u8ba4\u6570\u636e\u540c\u6b65<\/p>\n<ul class=\"post-ul\">db1\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4f5c\u6210<\/ul>\n<pre class=\"post-pre\"><code>[vagrant@db1 ~]$ mysql -u root -p\r\nEnter password:\r\nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\r\nYour MariaDB connection id is 11\r\nServer version: 10.3.8-MariaDB MariaDB Server\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)]&gt; create database dev_nagakuray;\r\nQuery OK, 1 row affected (0.002 sec)\r\n\r\nMariaDB [(none)]&gt; show databases;\r\n+--------------------+\r\n| Database           |\r\n+--------------------+\r\n| dev_nagakuray      |\r\n| information_schema |\r\n| mysql              |\r\n| performance_schema |\r\n+--------------------+\r\n4 rows in set (0.001 sec)\r\n\r\nMariaDB [(none)]&gt; use dev_nagakuray\r\nDatabase changed\r\n\r\nMariaDB [dev_nagakuray]&gt; create table test (id int, name varchar(100));\r\nQuery OK, 0 rows affected (0.008 sec)\r\n\r\nMariaDB [dev_nagakuray]&gt; insert into test (id, name) values (1, 'hogehoge');\r\nQuery OK, 1 row affected (0.003 sec)\r\n\r\nMariaDB [dev_nagakuray]&gt;\r\n<\/code><\/pre>\n<ul class=\"post-ul\">db2\u3067\u78ba\u8a8d<\/ul>\n<pre class=\"post-pre\"><code>[vagrant@db2 ~]$ mysql -u root -p\r\nEnter password:\r\nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\r\nYour MariaDB connection id is 11\r\nServer version: 10.3.8-MariaDB MariaDB Server\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)]&gt; show databases;\r\n+--------------------+\r\n| Database           |\r\n+--------------------+\r\n| dev_nagakuray      |\r\n| information_schema |\r\n| mysql              |\r\n| performance_schema |\r\n+--------------------+\r\n4 rows in set (0.001 sec)\r\n\r\nMariaDB [(none)]&gt; use dev_nagakuray\r\nReading table information for completion of table and column names\r\nYou can turn off this feature to get a quicker startup with -A\r\n\r\nDatabase changed\r\nMariaDB [dev_nagakuray]&gt; select * from test;\r\n+------+----------+\r\n| id   | name     |\r\n+------+----------+\r\n|    1 | hogehoge |\r\n+------+----------+\r\n1 row in set (0.000 sec)\r\n\r\nMariaDB [dev_nagakuray]&gt; insert into test (id, name) values (2, 'fugafuga');\r\nQuery OK, 1 row affected (0.005 sec)\r\n<\/code><\/pre>\n<ul class=\"post-ul\">db3\u3067\u78ba\u8a8d<\/ul>\n<pre class=\"post-pre\"><code>[vagrant@db3 ~]$ mysql -u root -p\r\nEnter password:\r\nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\r\nYour MariaDB connection id is 12\r\nServer version: 10.3.8-MariaDB MariaDB Server\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)]&gt; show databases;\r\n+--------------------+\r\n| Database           |\r\n+--------------------+\r\n| dev_nagakuray      |\r\n| information_schema |\r\n| mysql              |\r\n| performance_schema |\r\n+--------------------+\r\n4 rows in set (0.000 sec)\r\n\r\nMariaDB [(none)]&gt; use dev_nagakuray\r\nReading table information for completion of table and column names\r\nYou can turn off this feature to get a quicker startup with -A\r\n\r\nDatabase changed\r\nMariaDB [dev_nagakuray]&gt; select * from test;\r\n+------+----------+\r\n| id   | name     |\r\n+------+----------+\r\n|    1 | hogehoge |\r\n|    2 | fugafuga |\r\n+------+----------+\r\n2 rows in set (0.000 sec)\r\n\r\nMariaDB [dev_nagakuray]&gt; insert into test (id, name) values (3, 'hanako');\r\nQuery OK, 1 row affected (0.003 sec)\r\n<\/code><\/pre>\n<h2>\u6ce8\u610f\u4e8b\u9879\uff1a\u5173\u4e8eMariaDB Galera Cluster\u7684\u505c\u6b62\u2192\u542f\u52a8\u987a\u5e8f\u3002<\/p>\n<ul class=\"post-ul\">\u8d77\u52d5\u72b6\u614b\u6642\u306edb1<\/ul>\n<pre class=\"post-pre\"><code>sudo cat \/var\/lib\/mysql\/grastate.dat\r\n\r\n# GALERA saved state\r\nversion: 2.1\r\nuuid:    5ea4eb1f-8bff-11e8-934d-7aa2eaa06ac1\r\nseqno:   -1\r\nsafe_to_bootstrap: 0\r\n\r\n<\/code><\/pre>\n<ul class=\"post-ul\">\u8d77\u52d5\u72b6\u614b\u6642\u306edb2<\/ul>\n<pre class=\"post-pre\"><code>sudo cat \/var\/lib\/mysql\/grastate.dat\r\n\r\n# GALERA saved state\r\nversion: 2.1\r\nuuid:    5ea4eb1f-8bff-11e8-934d-7aa2eaa06ac1\r\nseqno:   -1\r\nsafe_to_bootstrap: 0\r\n<\/code><\/pre>\n<ul class=\"post-ul\">\u8d77\u52d5\u72b6\u614b\u6642\u306edb3<\/ul>\n<pre class=\"post-pre\"><code>sudo cat \/var\/lib\/mysql\/grastate.dat\r\n\r\n# GALERA saved state\r\nversion: 2.1\r\nuuid:    5ea4eb1f-8bff-11e8-934d-7aa2eaa06ac1\r\nseqno:   -1\r\nsafe_to_bootstrap: 0\r\n<\/code><\/pre>\n<p>\u5982\u4e0a\u6240\u8ff0\uff0c\u8be5\u6587\u4ef6\u4e2d\u7684\u201csafe_to_bootstrap\u201d\u503c\u4e3a\u201c0\u201d\u3002<\/p>\n<p>\u7136\u540e\uff0c\u6309\u71671\u53f7\u673a\u21922\u53f7\u673a\u21923\u53f7\u673a\u7684\u987a\u5e8f\u505c\u6b62\u3002<\/p>\n<pre class=\"post-pre\"><code>[vagrant@db1 ~]$ sudo systemctl stop mariadb\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>[vagrant@db2 ~]$ sudo systemctl stop mariadb\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>[vagrant@db3 ~]$ sudo systemctl stop mariadb\r\n<\/code><\/pre>\n<p>\u6211\u4eec\u5c06\u68c0\u67e5\u6b64\u65f6\u7684\/var\/lib\/mysql\/grastate.dat\u6587\u4ef6\u3002<\/p>\n<ul class=\"post-ul\">\u505c\u6b62\u72b6\u614b\u6642\u306edb1<\/ul>\n<pre class=\"post-pre\"><code>[vagrant@db1 ~]$ sudo cat \/var\/lib\/mysql\/grastate.dat\r\n# GALERA saved state\r\nversion: 2.1\r\nuuid:    5ea4eb1f-8bff-11e8-934d-7aa2eaa06ac1\r\nseqno:   0\r\nsafe_to_bootstrap: 0\r\n<\/code><\/pre>\n<ul class=\"post-ul\">\u505c\u6b62\u72b6\u614b\u6642\u306edb2<\/ul>\n<pre class=\"post-pre\"><code>[vagrant@db2 ~]$ sudo cat \/var\/lib\/mysql\/grastate.dat\r\n# GALERA saved state\r\nversion: 2.1\r\nuuid:    5ea4eb1f-8bff-11e8-934d-7aa2eaa06ac1\r\nseqno:   0\r\nsafe_to_bootstrap: 0\r\n<\/code><\/pre>\n<ul class=\"post-ul\">\u505c\u6b62\u72b6\u614b\u6642\u306edb3<\/ul>\n<pre class=\"post-pre\"><code>[vagrant@db3 ~]$ sudo cat \/var\/lib\/mysql\/grastate.dat\r\n# GALERA saved state\r\nversion: 2.1\r\nuuid:    5ea4eb1f-8bff-11e8-934d-7aa2eaa06ac1\r\nseqno:   0\r\nsafe_to_bootstrap: 1\r\n<\/code><\/pre>\n<p>\u5728\u8fd9\u4e2a\u65f6\u5019\uff0c\u4ece\u7b2c\u4e00\u53f0\u673a\u5668\u542f\u52a8\u540e\u4f1a\u51fa\u73b0\u4ee5\u4e0b\u9519\u8bef\u3002<\/p>\n<pre class=\"post-pre\"><code> [vagrant@db1 ~]$ sudo galera_new_cluster\r\nJob for mariadb.service failed because the control process exited with error code. See \"systemctl status mariadb.service\" and \"journalctl -xe\" for details.\r\n<\/code><\/pre>\n<p>\u5fc5\u987b\u4ece\u8bbe\u7f6e\u4e3a1\u76843\u53f7\u673a\u5b89\u5168\u542f\u52a8\u3002<\/p>\n<pre class=\"post-pre\"><code>[vagrant@db3 ~]$ sudo galera_new_cluster\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>[vagrant@db1 ~]$ sudo systemctl start mariadb\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>[vagrant@db2 ~]$ sudo systemctl start mariadb\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u4ee5\u4e0b\u662f\u4f7f\u7528Galera Cluster\u53ef\u4ee5\u5f88\u5bb9\u6613\u5730\u642d\u5efa\u591a\u4e2a\u4e3b\u6570\u636e\u5e93\u7684\u6784\u5efa\u5907\u5fd8\u5f55\u3002 \u56e0\u6b64\uff0c\u6211\u5c07\u591a\u500b\u5be6\u4f8b\u639b\u8f09\u5230LB [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[227],"class_list":["post-28532","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-227"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u642d\u5efaMariaDB Galera\u96c6\u7fa4 - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"\u5173\u4e8e\u642d\u5efaMariaDB Galera\u96c6\u7fa4\u7684\u6280\u672f\u6587\u7ae0\" \/>\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\/\u642d\u5efamariadb-galera\u96c6\u7fa4\u3002\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u642d\u5efaMariaDB Galera\u96c6\u7fa4\" \/>\n<meta property=\"og:description\" content=\"\u5173\u4e8e\u642d\u5efaMariaDB Galera\u96c6\u7fa4\u7684\u6280\u672f\u6587\u7ae0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u642d\u5efamariadb-galera\u96c6\u7fa4\u3002\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-25T15:13:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-12T00:41:44+00:00\" \/>\n<meta name=\"author\" content=\"\u79d1, \u9896\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u79d1, \u9896\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 \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\/%e6%90%ad%e5%bb%bamariadb-galera%e9%9b%86%e7%be%a4%e3%80%82\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e6%90%ad%e5%bb%bamariadb-galera%e9%9b%86%e7%be%a4%e3%80%82\/\",\"name\":\"\u642d\u5efaMariaDB Galera\u96c6\u7fa4 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-04-25T15:13:51+00:00\",\"dateModified\":\"2025-08-12T00:41:44+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e\"},\"description\":\"\u5173\u4e8e\u642d\u5efaMariaDB Galera\u96c6\u7fa4\u7684\u6280\u672f\u6587\u7ae0\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e6%90%ad%e5%bb%bamariadb-galera%e9%9b%86%e7%be%a4%e3%80%82\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e6%90%ad%e5%bb%bamariadb-galera%e9%9b%86%e7%be%a4%e3%80%82\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e6%90%ad%e5%bb%bamariadb-galera%e9%9b%86%e7%be%a4%e3%80%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u642d\u5efaMariaDB Galera\u96c6\u7fa4\"}]},{\"@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\/8ca01ba7f7362ad4edb7da206a12f29e\",\"name\":\"\u79d1, \u9896\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g\",\"caption\":\"\u79d1, \u9896\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/keying\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e6%90%ad%e5%bb%bamariadb-galera%e9%9b%86%e7%be%a4%e3%80%82\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u642d\u5efaMariaDB Galera\u96c6\u7fa4 - Blog - Silicon Cloud","description":"\u5173\u4e8e\u642d\u5efaMariaDB Galera\u96c6\u7fa4\u7684\u6280\u672f\u6587\u7ae0","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\/\u642d\u5efamariadb-galera\u96c6\u7fa4\u3002\/","og_locale":"zh_CN","og_type":"article","og_title":"\u642d\u5efaMariaDB Galera\u96c6\u7fa4","og_description":"\u5173\u4e8e\u642d\u5efaMariaDB Galera\u96c6\u7fa4\u7684\u6280\u672f\u6587\u7ae0","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u642d\u5efamariadb-galera\u96c6\u7fa4\u3002\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-04-25T15:13:51+00:00","article_modified_time":"2025-08-12T00:41:44+00:00","author":"\u79d1, \u9896","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u79d1, \u9896","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"1 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%90%ad%e5%bb%bamariadb-galera%e9%9b%86%e7%be%a4%e3%80%82\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%90%ad%e5%bb%bamariadb-galera%e9%9b%86%e7%be%a4%e3%80%82\/","name":"\u642d\u5efaMariaDB Galera\u96c6\u7fa4 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-04-25T15:13:51+00:00","dateModified":"2025-08-12T00:41:44+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e"},"description":"\u5173\u4e8e\u642d\u5efaMariaDB Galera\u96c6\u7fa4\u7684\u6280\u672f\u6587\u7ae0","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%90%ad%e5%bb%bamariadb-galera%e9%9b%86%e7%be%a4%e3%80%82\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e6%90%ad%e5%bb%bamariadb-galera%e9%9b%86%e7%be%a4%e3%80%82\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%90%ad%e5%bb%bamariadb-galera%e9%9b%86%e7%be%a4%e3%80%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u642d\u5efaMariaDB Galera\u96c6\u7fa4"}]},{"@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\/8ca01ba7f7362ad4edb7da206a12f29e","name":"\u79d1, \u9896","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g","caption":"\u79d1, \u9896"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/keying\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%90%ad%e5%bb%bamariadb-galera%e9%9b%86%e7%be%a4%e3%80%82\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/28532","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\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=28532"}],"version-history":[{"count":3,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/28532\/revisions"}],"predecessor-version":[{"id":111343,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/28532\/revisions\/111343"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=28532"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=28532"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=28532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}