我无法弄清楚如何在Ubuntu Zesty上初始化一个MariaDB Galera集群。 我已经按照文档，但似乎缺less一些东西。 我不能得到第一个节点。
我使用标准包安装：
apt install mariadb-server 我在/etc/mysql/mariadb.conf.d/90-cluster.cnfconfiguration了集群
[mariadb] bind-address = 0.0.0.0 binlog-format = ROW innodb-autoinc-lock-mode = 2 innodb-flush-log-at-trx-commit = 0 wsrep-on = ON wsrep-sst-method = rsync wsrep-cluster-name = "example" wsrep-cluster-address = "gcomm://maria01.example.com,maria02.example.com" wsrep-node-address = "maria01" wsrep-node-name = "maria01.example.com"
注意：我也尝试将wsrep-cluster-address设置为“gcomm：//”
我尝试通过停止服务并从专门的脚本开始来引导：
systemctl stop mariadb galera_new_cluster
然后我连接到实例并检查状态：
show global variables like 'wsrep%'; +---------------------------------+-----------------------------------------+ | wsrep_osu_method | TOI | | wsrep_auto_increment_control | ON | | wsrep_causal_reads | OFF | | wsrep_certify_nonpk | ON | | wsrep_cluster_address | gcomm:// | | wsrep_cluster_name | example | | wsrep_convert_lock_to_trx | OFF | | wsrep_data_home_dir | /var/lib/mysql/ | | wsrep_dbug_option | | | wsrep_debug | OFF | | wsrep_desync | OFF | | wsrep_dirty_reads | OFF | | wsrep_drupal_282555_workaround | OFF | | wsrep_forced_binlog_format | NONE | | wsrep_gtid_domain_id | 0 | | wsrep_gtid_mode | OFF | | wsrep_load_data_splitting | ON | | wsrep_log_conflicts | OFF | | wsrep_max_ws_rows | 0 | | wsrep_max_ws_size | 2147483647 | | wsrep_mysql_replication_bundle | 0 | | wsrep_node_address | maria01 | | wsrep_node_incoming_address | AUTO | | wsrep_node_name | maria01.example.com | | wsrep_notify_cmd | | | wsrep_on | OFF | | wsrep_patch_version | wsrep_25.16 | | wsrep_provider | none | | wsrep_provider_options | pc.bootstrap=1 | | wsrep_recover | OFF | | wsrep_replicate_myisam | OFF | | wsrep_restart_slave | OFF | | wsrep_retry_autocommit | 1 | | wsrep_slave_fk_checks | ON | | wsrep_slave_uk_checks | OFF | | wsrep_slave_threads | 1 | | wsrep_sst_auth | | | wsrep_sst_donor | | | wsrep_sst_donor_rejects_queries | OFF | | wsrep_sst_method | rsync | | wsrep_sst_receive_address | AUTO | | wsrep_start_position | 00000000-0000-0000-0000-000000000000:-1 | | wsrep_sync_wait | 0 | +---------------------------------+-----------------------------------------+ show status like 'wsrep%'; +--------------------------+----------------------+ | wsrep_cluster_conf_id | 18446744073709551615 | | wsrep_cluster_size | 0 | | wsrep_cluster_state_uuid | | | wsrep_cluster_status | Disconnected | | wsrep_connected | OFF | | wsrep_local_bf_aborts | 0 | | wsrep_local_index | 18446744073709551615 | | wsrep_provider_name | | | wsrep_provider_vendor | | | wsrep_provider_version | | | wsrep_ready | ON | | wsrep_thread_count | 0 | +--------------------------+----------------------+
请特别注意wsrep_cluster_size ，它是0，但根据文档运行galera_new_cluster后应该是1。
玛丽亚日志没有太多，但它似乎像群集初始化：
systemd[1]: Starting MariaDB database server... sh[4083]: 2017-05-03 22:11:40 139734663651904 [Note] /usr/sbin/mysqld (mysqld 10.1.22-MariaDB-) starting as process 4203 ... sh[4083]: WSREP: Recovered position 00000000-0000-0000-0000-000000000000:-1 mysqld[4238]: 2017-05-03 22:11:44 140634874606144 [Note] /usr/sbin/mysqld (mysqld 10.1.22-MariaDB-) starting as process 4238 ... systemd[1]: Started MariaDB database server.
看起来你的集群configuration缺less一些东西：
wsrep_provider设置为Galera wsrep库的path wsrep_on应设置为“ON”。 看起来你实际上需要修改大部分configuration来使用下划线而不是破折号。 状态输出中的关键问题是没有wsrep_provider ，并且wsrep_on被设置为off。 您可以在MariaDB页面上看到必需的configuration设置。