Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
ghost opened this issue Nov 9, 2023 · 0 comments
Open

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

ghost opened this issue Nov 9, 2023 · 0 comments

Comments

@ghost
Copy link

ghost commented Nov 9, 2023

/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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

0 participants