inertz

Mungkin dalam ni ada yang pernah deploy atau testing mysql cluster. Setting sekarang yang tengah simulate macam ni; [root@db1 mysql-cluster]# ndb_mgm -e show Connected to Management Server at: localhost:1186 Cluster Configuration --------------------- [ndbd(NDB)] 2 node(s) id=2 @192.168.0.134 (mysql-8.0.21 ndb-8.0.21, Nodegroup: 0, *) id=3 @192.168.0.135 (mysql-8.0.21 ndb-8.0.21, Nodegroup: 0) [ndb_mgmd(MGM)] 1 node(s) id=1 @192.168.0.133 (mysql-8.0.21 ndb-8.0.21) [mysqld(API)] 2 node(s) id=4 @192.168.0.136 (mysql-8.0.21 ndb-8.0.21) id=5 @192.168.0.137 (mysql-8.0.21 ndb-8.0.21) Soalan. 1. Kalau nak add cluster bagi high performance macam load balancing server mana perlu add, data node[ndbd(NDB)] atau mysql node[mysqld(API)] 2. Antara cluster dengan master/slave replication yg mana lebih baik untuk handle load balancing.

Bukan. Baremetal server.

Rasanya soalan ni mahal, tanya kat expert exchange pun diaorg point ke redhat.

Salam, Mintak tolong sesiapa yang tahu atau biasa dengan HA dengan masalah ni. Aku tengah buat simulation NFS storage dengan HA. Setup ni mengandungi 3 biji cluster. Bila enable stonith untuk create disk fencing error yang keluar berkaitan registration key. *Error ni mungkin boleh dapat solution kat redhat punya portal, tapi kena subscribe la pulak. Harap ada sesiapa boleh bagi idea. Mar 13 16:01:48 [10579] cluster1.inertz.org stonith-ng: warning: log_action: fence_scsi[11255] stderr: [ 2020-03-13 16:01:48,951 ERROR: Cannot get registration keys ] Mar 13 16:01:48 [10579] cluster1.inertz.org stonith-ng: warning: log_action: fence_scsi[11255] stderr: [ ] Mar 13 16:01:48 [10579] cluster1.inertz.org stonith-ng: warning: log_action: fence_scsi[11255] stderr: [ 2020-03-13 16:01:48,951 ERROR: Please use '-h' for usage ] Mar 13 16:01:48 [10579] cluster1.inertz.org stonith-ng: warning: log_action: fence_scsi[11255] stderr: [ ] Error lain; Mar 13 16:01:46 [10583] cluster1.inertz.org crmd: error: tengine_stonith_notify: Unfencing of cluster1.inertz.org by <anyone> failed: No route to host (-113) Mar 13 16:01:47 [10583] cluster1.inertz.org crmd: error: tengine_stonith_notify: Unfencing of cluster3.inertz.org by <anyone> failed: No route to host (-113) Mar 13 16:01:47 [10583] cluster1.inertz.org crmd: error: tengine_stonith_notify: Unfencing of cluster2.inertz.org by <anyone> failed: No route to host (-113) Server boleh ping; [root@cluster1 ~]# ping cluster1.inertz.org PING cluster1.inertz.org (192.168.0.20) 56(84) bytes of data. 64 bytes from cluster1.inertz.org (192.168.0.20): icmp_seq=1 ttl=64 time=0.062 ms 64 bytes from cluster1.inertz.org (192.168.0.20): icmp_seq=2 ttl=64 time=0.051 ms 64 bytes from cluster1.inertz.org (192.168.0.20): icmp_seq=3 ttl=64 time=0.048 ms 64 bytes from cluster1.inertz.org (192.168.0.20): icmp_seq=4 ttl=64 time=0.048 ms ^C --- cluster1.inertz.org ping statistics --- 4 packets transmitted, 4 received, 0% packet loss, time 2999ms rtt min/avg/max/mdev = 0.048/0.052/0.062/0.007 ms [root@cluster1 ~]# ping cluster2.inertz.org PING cluster2.inertz.org (192.168.0.21) 56(84) bytes of data. 64 bytes from cluster2.inertz.org (192.168.0.21): icmp_seq=1 ttl=64 time=0.319 ms 64 bytes from cluster2.inertz.org (192.168.0.21): icmp_seq=2 ttl=64 time=0.384 ms 64 bytes from cluster2.inertz.org (192.168.0.21): icmp_seq=3 ttl=64 time=0.462 ms 64 bytes from cluster2.inertz.org (192.168.0.21): icmp_seq=4 ttl=64 time=0.455 ms ^C --- cluster2.inertz.org ping statistics --- 4 packets transmitted, 4 received, 0% packet loss, time 2999ms rtt min/avg/max/mdev = 0.319/0.405/0.462/0.058 ms [root@cluster1 ~]# ping cluster3.inertz.org PING cluster3.inertz.org (192.168.0.22) 56(84) bytes of data. 64 bytes from cluster3.inertz.org (192.168.0.22): icmp_seq=1 ttl=64 time=0.331 ms 64 bytes from cluster3.inertz.org (192.168.0.22): icmp_seq=2 ttl=64 time=0.327 ms 64 bytes from cluster3.inertz.org (192.168.0.22): icmp_seq=3 ttl=64 time=0.412 ms 64 bytes from cluster3.inertz.org (192.168.0.22): icmp_seq=4 ttl=64 time=0.441 ms ^C --- cluster3.inertz.org ping statistics --- 4 packets transmitted, 4 received, 0% packet loss, time 3000ms rtt min/avg/max/mdev = 0.327/0.377/0.441/0.055 ms Pcs status bila enable stonith; [root@cluster1 ~]# pcs status Cluster name: nfs-cluster Stack: corosync Current DC: cluster3.inertz.org (version 1.1.20-5.el7_7.2-3c4c782f70) - partition with quorum Last updated: Fri Mar 13 16:02:02 2020 Last change: Fri Mar 13 16:01:35 2020 by root via cibadmin on cluster1.inertz.org 3 nodes configured 1 resource configured Online: [ cluster1.inertz.org cluster2.inertz.org cluster3.inertz.org ] Full list of resources: storage (stonith:fence_scsi): Stopped Failed Fencing Actions: * unfencing of cluster1.inertz.org failed: delegate=, client=crmd.9609, origin=cluster3.inertz.org, last-failed='Fri Mar 13 16:01:48 2020' * unfencing of cluster2.inertz.org failed: delegate=, client=crmd.9609, origin=cluster3.inertz.org, last-failed='Fri Mar 13 16:01:48 2020' * unfencing of cluster3.inertz.org failed: delegate=, client=crmd.9609, origin=cluster3.inertz.org, last-failed='Fri Mar 13 16:01:48 2020' Daemon Status: corosync: active/enabled pacemaker: active/enabled pcsd: active/enabled Disable stonith; [root@cluster1 ~]# pcs property set stonith-enabled=false Pcs status; [root@cluster1 ~]# pcs status Cluster name: nfs-cluster Stack: corosync Current DC: cluster3.inertz.org (version 1.1.20-5.el7_7.2-3c4c782f70) - partition with quorum Last updated: Fri Mar 13 16:03:41 2020 Last change: Fri Mar 13 16:03:37 2020 by root via cibadmin on cluster1.inertz.org 3 nodes configured 1 resource configured Online: [ cluster1.inertz.org cluster2.inertz.org cluster3.inertz.org ] Full list of resources: storage (stonith:fence_scsi): Started cluster1.inertz.org Failed Fencing Actions: * unfencing of cluster1.inertz.org failed: delegate=, client=crmd.9609, origin=cluster3.inertz.org, last-failed='Fri Mar 13 16:01:48 2020' * unfencing of cluster2.inertz.org failed: delegate=, client=crmd.9609, origin=cluster3.inertz.org, last-failed='Fri Mar 13 16:01:48 2020' * unfencing of cluster3.inertz.org failed: delegate=, client=crmd.9609, origin=cluster3.inertz.org, last-failed='Fri Mar 13 16:01:48 2020' Daemon Status: corosync: active/enabled pacemaker: active/enabled pcsd: active/enabled Command yang aku guna untuk disk fencing; [root@cluster1 ~]# pcs stonith create storage fence_scsi pcmk_host_list="cluster1.inertz.org cluster2.inertz.org cluster3.inertz.org" pcmk_monitor_action="metadata" pcmk_reboot_action="off" devices="/dev/disk/by-id/wwn-0x50014ee25f9b7c3b" meta provides="unfencing"

Salam kenal...