Mysql cluster

De wikierchache
Saltar a: navegación, buscar

Antes de actualizar (sun cluster 3.1)

mysql_cluster_showrev

mysql_cluster_cluster_status

mysql_cluster_cluster_show

mysql_cluster_cldevice_list_-v

mysql_cluster_scstat

Después de actualizar (sun cluster 3.2)

mysql_cluster_distribución_cabina_discos

mysql_cluster_notas

Sun hwsetup fig01.gif

Hardware server admin (dat) sun fire R220

root@admin2 # uname -a SunOS admin2 5.10 Generic_127127-11 sun4u sparc SUNW,Ultra-60

root@admin2 # prtdiag System Configuration: Sun Microsystems sun4u Sun Enterprise 220R (2 X UltraSPARC-II 450MHz) System clock frequency: 113 MHz Memory size: 2048 Megabytes

========================= CPUs =========================
                   Run   Ecache   CPU    CPU
Brd  CPU   Module   MHz     MB    Impl.   Mask
---  ---  -------  -----  ------  ------  ----
 0     0     0      450     4.0   US-II    1.0
 0     2     2      450     4.0   US-II    1.0


========================= IO Cards =========================
    Bus   Freq
Brd  Type  MHz   Slot        Name                          Model
---  ----  ----  ----------  ----------------------------  --------------------
 0   PCI    33     On-Board  network-SUNW,hme                                 
 0   PCI    33     On-Board  scsi-glm/disk (block)         Symbios,53C875     
 0   PCI    33     On-Board  scsi-glm/disk (block)         Symbios,53C875     
 0   PCI    33        PCI 2  pci-pci1011,25.4/pci108e,100+ pci-bridge         
 0   PCI    33        PCI 2  SUNW,qfe-pci108e,1001         SUNW,pci-qfe       
 0   PCI    33        PCI 2  SUNW,qfe-pci108e,1001         SUNW,pci-qfe       
 0   PCI    33        PCI 2  SUNW,qfe-pci108e,1001         SUNW,pci-qfe       
 0   PCI    33        PCI 2  SUNW,qfe-pci108e,1001         SUNW,pci-qfe       
No failures found in System
===========================

System Configuration: Sun Microsystems sun4u Memory size: 2048 Megabytes System Peripherals (Software Nodes):

SUNW,Ultra-60

   scsi_vhci, instance #0
   packages (driver not attached)
       terminal-emulator (driver not attached)
       deblocker (driver not attached)
       obp-tftp (driver not attached)
       disk-label (driver not attached)
       SUNW,builtin-drivers (driver not attached)
       sun-keyboard (driver not attached)
       ufs-file-system (driver not attached)
   chosen (driver not attached)
   openprom (driver not attached)
       client-services (driver not attached)
   options, instance #0
   aliases (driver not attached)
   memory (driver not attached)
   virtual-memory (driver not attached)
   pci, instance #0
       ebus, instance #0
           auxio (driver not attached)
           power (driver not attached)
           SUNW,pll (driver not attached)
           sc (driver not attached)
           se, instance #0
           su, instance #0
           su, instance #1
           ecpp, instance #0 (driver not attached)
           fdthree (driver not attached)
           eeprom (driver not attached)
           flashprom (driver not attached)
       network, instance #0
       scsi, instance #0
           disk (driver not attached)
           tape (driver not attached)
           sd, instance #2
           sd, instance #0
           sd, instance #6
       scsi, instance #1
           disk (driver not attached)
           tape (driver not attached)
       pci, instance #0
           pci108e,1000 (driver not attached)
           SUNW,qfe, instance #0
           pci108e,1000 (driver not attached)
           SUNW,qfe, instance #1
           pci108e,1000 (driver not attached)
           SUNW,qfe, instance #2
           pci108e,1000 (driver not attached)
           SUNW,qfe, instance #3
   pci, instance #1
   counter-timer (driver not attached)
   SUNW,UltraSPARC-II (driver not attached)
   SUNW,UltraSPARC-II (driver not attached)
   os-io (driver not attached)
   iscsi, instance #0
   pseudo, instance #0

AVAILABLE DISK SELECTIONS:

      0. c0t0d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
         /pci@1f,4000/scsi@3/sd@0,0
      1. c0t1d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
         /pci@1f,4000/scsi@3/sd@1,0

Hardware nodo 1 Sun Fire R440

root@nodo21 # uname -a SunOS nodo21 5.10 Generic_127127-11 sun4u sparc SUNW,Ultra-80

root@nodo21 # prtdiag System Configuration: Sun Microsystems sun4u Sun Enterprise 420R (4 X UltraSPARC-II 450MHz) System clock frequency: 113 MHz Memory size: 4096 Megabytes

========================= CPUs =========================
                   Run   Ecache   CPU    CPU
Brd  CPU   Module   MHz     MB    Impl.   Mask
---  ---  -------  -----  ------  ------  ----
 0     0     0      450     4.0   US-II    10.0
 0     1     1      450     4.0   US-II    10.0
 0     2     2      450     4.0   US-II    10.0
 0     3     3      450     4.0   US-II    10.0


========================= IO Cards =========================
    Bus   Freq
Brd  Type  MHz   Slot        Name                          Model
---  ----  ----  ----------  ----------------------------  --------------------
 0   PCI    33     On-Board  network-SUNW,hme                                 
 0   PCI    33     On-Board  scsi-glm/disk (block)         Symbios,53C875     
 0   PCI    33     On-Board  scsi-glm/disk (block)         Symbios,53C875     
 0   PCI    33         PCI   scsi-glm/disk (block)         Symbios,53C875     
 0   PCI    33         PCI   scsi-glm/disk (block)         Symbios,53C875     
 0   PCI    33     PCI 1 66  pci-pci1011,25.4/pci108e,100+ pci-bridge         
 0   PCI    33     PCI 1 66  SUNW,qfe-pci108e,1001         SUNW,pci-qfe       
 0   PCI    33     PCI 1 66  SUNW,qfe-pci108e,1001         SUNW,pci-qfe       
 0   PCI    33     PCI 1 66  SUNW,qfe-pci108e,1001         SUNW,pci-qfe       
 0   PCI    33     PCI 1 66  SUNW,qfe-pci108e,1001         SUNW,pci-qfe       
No failures found in System
===========================


System Configuration: Sun Microsystems sun4u Memory size: 4096 Megabytes System Peripherals (Software Nodes):

SUNW,Ultra-80

   scsi_vhci, instance #0
   packages (driver not attached)
       terminal-emulator (driver not attached)
       deblocker (driver not attached)
       obp-tftp (driver not attached)
       disk-label (driver not attached)
       SUNW,builtin-drivers (driver not attached)
       sun-keyboard (driver not attached)
       ufs-file-system (driver not attached)
   chosen (driver not attached)
   openprom (driver not attached)
       client-services (driver not attached)
   options, instance #0
   aliases (driver not attached)
   memory (driver not attached)
   virtual-memory (driver not attached)
   pci, instance #0
       ebus, instance #0
           auxio (driver not attached)
           power, instance #0
           SUNW,pll (driver not attached)
           sc (driver not attached)
           se, instance #0
           su, instance #0
           su, instance #1
           ecpp, instance #0
           fdthree (driver not attached)
           eeprom (driver not attached)
           flashprom (driver not attached)
       network, instance #0
       scsi, instance #0
           disk (driver not attached)
           tape (driver not attached)
           sd, instance #4
           sd, instance #0
           sd, instance #15
       scsi, instance #1
           disk (driver not attached)
           tape (driver not attached)
       scsi, instance #2
           disk (driver not attached)
           tape (driver not attached)
           sd, instance #22
           sd, instance #27
           sd, instance #30
           sd, instance #33
           sd, instance #36
           sd, instance #40
           sd, instance #46
           sd, instance #48
           sd, instance #51
           sd, instance #53
           sd, instance #55
           sd, instance #56
           ses, instance #61
           ses, instance #63
       scsi, instance #3
           disk (driver not attached)
           tape (driver not attached)
           sd, instance #10
           sd, instance #13
           sd, instance #16
           sd, instance #18
           sd, instance #21
           sd, instance #23
           sd, instance #29
           sd, instance #35
           sd, instance #39
           ses, instance #60
           ses, instance #62
   pci, instance #1
       pci, instance #0
           pci108e,1000 (driver not attached)
           SUNW,qfe, instance #0
           pci108e,1000 (driver not attached)
           SUNW,qfe, instance #1
           pci108e,1000 (driver not attached)
           SUNW,qfe, instance #2
           pci108e,1000 (driver not attached)
           SUNW,qfe, instance #3
   counter-timer (driver not attached)
   SUNW,UltraSPARC-II (driver not attached)
   SUNW,UltraSPARC-II (driver not attached)
   SUNW,UltraSPARC-II (driver not attached)
   SUNW,UltraSPARC-II (driver not attached)
   os-io (driver not attached)
   iscsi, instance #0
   pseudo, instance #0

Hardware nodo 2 Sun fire R440

root@nodo22 # uname -a SunOS nodo22 5.10 Generic_127127-11 sun4u sparc SUNW,Ultra-80

root@nodo22 # prtdiag System Configuration: Sun Microsystems sun4u Sun Enterprise 420R (2 X UltraSPARC-II 450MHz) System clock frequency: 113 MHz Memory size: 2048 Megabytes

========================= CPUs =========================
                   Run   Ecache   CPU    CPU
Brd  CPU   Module   MHz     MB    Impl.   Mask  
---  ---  -------  -----  ------  ------  ----
 0     1     1      450     4.0   US-II    10.0
 0     2     2      450     4.0   US-II    10.0


========================= IO Cards =========================
    Bus   Freq
Brd  Type  MHz   Slot        Name                          Model
---  ----  ----  ----------  ----------------------------  --------------------
 0   PCI    33     On-Board  network-SUNW,hme                                 
 0   PCI    33     On-Board  scsi-glm/disk (block)         Symbios,53C875     
 0   PCI    33     On-Board  scsi-glm/disk (block)         Symbios,53C875     
 0   PCI    33         PCI   scsi-glm/disk (block)         Symbios,53C875     
 0   PCI    33         PCI   scsi-glm/disk (block)         Symbios,53C875     
 0   PCI    33     PCI 1 66  pci-pci1011,25.4/pci108e,100+ pci-bridge         
 0   PCI    33     PCI 1 66  SUNW,qfe-pci108e,1001         SUNW,pci-qfe       
 0   PCI    33     PCI 1 66  SUNW,qfe-pci108e,1001         SUNW,pci-qfe       
 0   PCI    33     PCI 1 66  SUNW,qfe-pci108e,1001         SUNW,pci-qfe       
 0   PCI    33     PCI 1 66  SUNW,qfe-pci108e,1001         SUNW,pci-qfe       
No failures found in System
===========================


System Configuration: Sun Microsystems sun4u Memory size: 2048 Megabytes System Peripherals (Software Nodes):

SUNW,Ultra-80

   scsi_vhci, instance #0
   packages (driver not attached)
       terminal-emulator (driver not attached)
       deblocker (driver not attached)
       obp-tftp (driver not attached)
       disk-label (driver not attached)
       SUNW,builtin-drivers (driver not attached)
       sun-keyboard (driver not attached)
       ufs-file-system (driver not attached)
   chosen (driver not attached)
   openprom (driver not attached)
       client-services (driver not attached)
   options, instance #0
   aliases (driver not attached)
   memory (driver not attached)
   virtual-memory (driver not attached)
   pci, instance #0
       ebus, instance #0
           auxio (driver not attached)
           power, instance #0
           SUNW,pll (driver not attached)
           sc (driver not attached)
           se, instance #0
           su, instance #0
           su, instance #1
           ecpp, instance #0
           fdthree (driver not attached)
           eeprom (driver not attached)
           flashprom (driver not attached)
       network, instance #0
       scsi, instance #0
           disk (driver not attached)
           tape (driver not attached)
           sd, instance #4
           sd, instance #0
           sd, instance #6
       scsi, instance #1
           disk (driver not attached)
           tape (driver not attached)
       scsi, instance #2
           disk (driver not attached)
           tape (driver not attached)
           sd, instance #15
           sd, instance #16
           sd, instance #17
           sd, instance #18
           sd, instance #19
           sd, instance #20
           sd, instance #22
           sd, instance #23
           sd, instance #24
           sd, instance #51
           sd, instance #52
           ses, instance #30
           ses, instance #47
       scsi, instance #3
           disk (driver not attached)
           tape (driver not attached)
           sd, instance #30
           sd, instance #31
           sd, instance #32
           sd, instance #33
           sd, instance #43
           sd, instance #44
           sd, instance #49
           sd, instance #53
           sd, instance #54
           ses, instance #62
           ses, instance #45
   pci, instance #1
       pci, instance #0
           pci108e,1000 (driver not attached)
           SUNW,qfe, instance #0
           pci108e,1000 (driver not attached)
           SUNW,qfe, instance #1
           pci108e,1000 (driver not attached)
           SUNW,qfe, instance #2
           pci108e,1000 (driver not attached)
           SUNW,qfe, instance #3
   counter-timer (driver not attached)
   SUNW,UltraSPARC-II (driver not attached)
   SUNW,UltraSPARC-II (driver not attached)
   os-io (driver not attached)
   iscsi, instance #0
   pseudo, instance #0

Discos de las 2 cabinas sun d1000

AVAILABLE DISK SELECTIONS:

      0. c0t0d0 <SUN18G cyl 7506 alt 2 hd 19 sec 248>
         /pci@1f,4000/scsi@3/sd@0,0
      1. c0t1d0 <SUN18G cyl 7506 alt 2 hd 19 sec 248>
         /pci@1f,4000/scsi@3/sd@1,0
      2. c1t0d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
         /pci@1f,4000/scsi@5/sd@0,0
      3. c1t1d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
         /pci@1f,4000/scsi@5/sd@1,0
      4. c1t2d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
         /pci@1f,4000/scsi@5/sd@2,0
      5. c1t3d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
         /pci@1f,4000/scsi@5/sd@3,0
      6. c1t4d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
         /pci@1f,4000/scsi@5/sd@4,0
      7. c1t5d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
         /pci@1f,4000/scsi@5/sd@5,0
      8. c1t8d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
         /pci@1f,4000/scsi@5/sd@8,0
      9. c1t9d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
         /pci@1f,4000/scsi@5/sd@9,0
     10. c1t10d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
         /pci@1f,4000/scsi@5/sd@a,0
     11. c1t11d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
         /pci@1f,4000/scsi@5/sd@b,0
     12. c1t12d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
         /pci@1f,4000/scsi@5/sd@c,0
     13. c1t13d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
         /pci@1f,4000/scsi@5/sd@d,0
     14. c2t0d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
         /pci@1f,4000/scsi@5,1/sd@0,0
     15. c2t1d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
         /pci@1f,4000/scsi@5,1/sd@1,0
     16. c2t2d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
         /pci@1f,4000/scsi@5,1/sd@2,0
     17. c2t3d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
         /pci@1f,4000/scsi@5,1/sd@3,0
     18. c2t4d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
         /pci@1f,4000/scsi@5,1/sd@4,0
     19. c2t5d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
         /pci@1f,4000/scsi@5,1/sd@5,0
     20. c2t8d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
         /pci@1f,4000/scsi@5,1/sd@8,0
     21. c2t9d0 <FUJITSU-MAJ3182M SUN18G-0804-16.87GB>
         /pci@1f,4000/scsi@5,1/sd@9,0
     22. c2t10d0 <FUJITSU-MAJ3364M SUN36G-0804-33.92GB>
         /pci@1f,4000/scsi@5,1/sd@a,0

S/N

Admin 123C138E 600-6952-01

Nodo 1 046A00CA 600-6929-01

Nodo 2 11180A2A 600-6927-01

Cab 1 0519RB0815 R595-5548-01

Cab 2 111M2D4B R595-5548-01