Cluster de bases de données
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 :
Code:
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' |
sur mes 2 autres nœuds, j'ai l'erreur suivante :
Code:
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 |
je vous en prie, aidez moi a comprendre !!!
