Jump to content

inertz

Members
  • Content Count

    6
  • Joined

  • Last visited

  • Days Won

    2

Posts posted by inertz


  1. 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.

     

     


  2. 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"

     

×
×
  • Create New...