salut, je voudrais implémenter la haute disponibilité via un cluster de base de données mariadb. je suis le tutoriel suivant :
https://www.malekal.com/galera-insta...sur-debian-10/
je me trouve confronté aux erreurs suivantes :
--au niveau du serveur maître, j'ai l'erreur suivante :
sur mes 2 autres nœuds, j'ai l'erreur suivante :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11 2022-03-17 11:21:33 0 [Note] WSREP: handshake failed, my group: 'mariadb1', peer group: 'mariadb3' 2022-03-17 11:21:34 0 [Note] WSREP: handshake failed, my group: 'mariadb1', peer group: 'mariadb2' 2022-03-17 11:21:34 0 [Note] WSREP: handshake failed, my group: 'mariadb1', peer group: 'mariadb3' 2022-03-17 11:21:35 0 [Note] WSREP: handshake failed, my group: 'mariadb1', peer group: 'mariadb2' 2022-03-17 11:21:36 0 [Note] WSREP: handshake failed, my group: 'mariadb1', peer group: 'mariadb3' 2022-03-17 11:21:37 0 [Note] WSREP: handshake failed, my group: 'mariadb1', peer group: 'mariadb3' 2022-03-17 11:21:39 0 [Note] WSREP: handshake failed, my group: 'mariadb1', peer group: 'mariadb3' 2022-03-17 11:21:40 0 [Note] WSREP: handshake failed, my group: 'mariadb1', peer group: 'mariadb3' 2022-03-17 11:21:42 0 [Note] WSREP: handshake failed, my group: 'mariadb1', peer group: 'mariadb3' 2022-03-17 11:21:43 0 [Note] WSREP: handshake failed, my group: 'mariadb1', peer group: 'mariadb3'
je vous en prie, aidez moi a comprendre !!!
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10 2022-03-17 11:21:35 0 [Warning] WSREP: handshake with c7ab9373 tcp://192.168.80.136:4567 failed: 'invalid group' 2022-03-17 11:21:36 0 [Note] WSREP: view((empty)) 2022-03-17 11:21:36 0 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary view: 110 (Connection timed out) at gcomm/src/pc.cpp:connect():160 2022-03-17 11:21:36 0 [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():208: Failed to open backend connection: -110 (Connection timed out) 2022-03-17 11:21:36 0 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open():1457: Failed to open channel 'mariadb2' at 'gcomm://192.168.80.136,192.168.80.137,192.168.80.145': -110 (Connection timed out) 2022-03-17 11:21:36 0 [ERROR] WSREP: gcs connect failed: Connection timed out 2022-03-17 11:21:36 0 [ERROR] WSREP: wsrep::connect(gcomm://192.168.80.136,192.168.80.137,192.168.80.145) failed: 7 2022-03-17 11:21:36 0 [ERROR] Aborting
Partager