search

ClusterLabs / resource-agents

Combined repository of OCF agents from the RHCS and Linux-HA projects
GNU General Public License v2.0
489 stars 577 forks source link

How can I create a galera resource with two nodes? #1901

Open ghost opened 8 months ago

ghost commented 8 months ago

/etc/mysql/mariadb.conf.d/50-server.cnf galera configuration on node 1 (nyan1)

[galera]
wsrep_on=ON
wsrep_cluster_address=gcomm://192.168.1.21,192.168.1.22
wsrep_provider=/usr/lib/galera/libgalera_smm.so
binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0
wsrep_cluster_name="galera_cluster"
wsrep_node_address="192.168.1.21"

/etc/mysql/mariadb.conf.d/50-server.cnf galera configuration on node 2 (nyan2)

[galera]
wsrep_on=ON
wsrep_cluster_address=gcomm://192.168.1.21,192.168.1.22
wsrep_provider=/usr/lib/galera/libgalera_smm.so
binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0
wsrep_cluster_name="galera_cluster"
wsrep_node_address="192.168.1.22"

create resource command

root@nyan1:~# pcs resource create GaleraCluster ocf:heartbeat:galera wsrep_cluster_address="gcomm://192.168.1.21,192.168.1.22" \
    cluster_host_map="nyan1:192.168.1.21;nyan2:192.168.1.22" \
    op monitor OCF_CHECK_LEVEL="0" timeout="30s" interval="20s" \
    op monitor role="Master" OCF_CHECK_LEVEL="0" timeout="30s" interval="10s" \
    op monitor role="Slave" OCF_CHECK_LEVEL="0" timeout="30s" interval="30s" \
    promotable promoted-max=2
root@nyan1:~# pcs status
Cluster name: mycluster
Status of pacemakerd: 'Pacemaker is running' (last updated 2023-11-09 10:07:44 -06:00)
Cluster Summary:
  * Stack: corosync
  * Current DC: nyan2 (version 2.1.5-a3f44794f94) - partition with quorum
  * Last updated: Thu Nov  9 10:07:45 2023
  * Last change:  Thu Nov  9 10:07:10 2023 by root via cibadmin on nyan1
  * 2 nodes configured
  * 2 resource instances configured (9 DISABLED)

Node List:
  * Online: [ nyan1 nyan2 ]

Full List of Resources:
  * Clone Set: GaleraCluster-clone [GaleraCluster] (promotable):
    * GaleraCluster (ocf:heartbeat:galera):  FAILED Promoted nyan2
    * Promoted: [ nyan1 ]

Failed Resource Actions:
  * GaleraCluster promote on nyan2 returned 'error' (MySQL server failed to start (pid=38624) (rc=1), please check your installation) at Thu Nov  9 10:07:24 2023 after 6.450s

Daemon Status:
  corosync: active/disabled
  pacemaker: active/disabled
  pcsd: active/enabled