| « Drift for FUN | RCdriftprix series round 1 » |
# /opt/MegaRaid/LSI/MegaCli -LDInfo -Lall -aALL Adapter 0 -- Virtual Drive Information: Virtual Drive: 0 (Target Id: 0) Name : RAID Level : Primary-1, Secondary-0, RAID Level Qualifier-0 Size : 278.464 GB Sector Size : 512 Mirror Data : 278.464 GB State : Degraded Strip Size : 64 KB Number Of Drives : 2 Span Depth : 1 Default Cache Policy: WriteBack, ReadAheadNone, Cached, No Write Cache if Bad BBU Current Cache Policy: WriteBack, ReadAheadNone, Cached, No Write Cache if Bad BBU Default Access Policy: Read/Write Current Access Policy: Read/Write Disk Cache Policy : Disk's Default Encryption Type : None Is VD Cached: Yes Cache Cade Type : Read Only Exit Code: 0x00
# /opt/MegaRaid/LSI/MegaCli -PDList -aALL Adapter #0 Enclosure Device ID: 252 Slot Number: 0 Enclosure position: N/A Device Id: 9 WWN: 5000CCA01600163F Sequence Number: 6 Media Error Count: 0 Other Error Count: 0 Predictive Failure Count: 0 Last Predictive Failure Event Seq Number: 0 PD Type: SAS Raw Size: 279.396 GB [0x22ecb25c Sectors] Non Coerced Size: 278.896 GB [0x22dcb25c Sectors] Coerced Size: 278.464 GB [0x22cee000 Sectors] Sector Size: 0 Firmware state: Unconfigured(bad) Device Firmware Level: A31A Shield Counter: 0 Successful diagnostics completion on : N/A SAS Address(0): 0x5000cca01600163d SAS Address(1): 0x0 Connected Port Number: 1(path0) Inquiry Data: HITACHI H109030SESUN300GA31A1335C01GXN FDE Capable: Not Capable FDE Enable: Disable Secured: Unsecured Locked: Unlocked Needs EKM Attention: No Foreign State: Foreign Foreign Secure: Drive is not secured by a foreign lock key Device Speed: 6.0Gb/s Link Speed: 6.0Gb/s Media Type: Hard Disk Device Drive: Not Certified Drive Temperature :25C (77.00 F) PI Eligibility: No Drive is formatted for PI information: No PI: No PI Port-0 : Port status: Active Port's Linkspeed: 6.0Gb/s Port-1 : Port status: Active Port's Linkspeed: Unknown Drive has flagged a S.M.A.R.T alert : No Enclosure Device ID: 252 Slot Number: 1 Drive's position: DiskGroup: 0, Span: 0, Arm: 1 Enclosure position: N/A Device Id: 8 WWN: 5000CCA016002EBB Sequence Number: 2 Media Error Count: 0 Other Error Count: 0 Predictive Failure Count: 0 Last Predictive Failure Event Seq Number: 0 PD Type: SAS Raw Size: 279.396 GB [0x22ecb25c Sectors] Non Coerced Size: 278.896 GB [0x22dcb25c Sectors] Coerced Size: 278.464 GB [0x22cee000 Sectors] Sector Size: 0 Firmware state: Online, Spun Up Commissioned Spare : No Emergency Spare : No Device Firmware Level: A31A Shield Counter: 0 Successful diagnostics completion on : N/A SAS Address(0): 0x5000cca016002eb9 SAS Address(1): 0x0 Connected Port Number: 0(path0) Inquiry Data: HITACHI H109030SESUN300GA31A1335C033GN FDE Capable: Not Capable FDE Enable: Disable Secured: Unsecured Locked: Unlocked Needs EKM Attention: No Foreign State: None Device Speed: 6.0Gb/s Link Speed: 6.0Gb/s Media Type: Hard Disk Device Drive: Not Certified Drive Temperature :26C (78.80 F) PI Eligibility: No Drive is formatted for PI information: No PI: No PI Port-0 : Port status: Active Port's Linkspeed: 6.0Gb/s Port-1 : Port status: Active Port's Linkspeed: Unknown Drive has flagged a S.M.A.R.T alert : No Exit Code: 0x00
# /opt/MegaRaid/LSI/MegaCli -PDMakeGood -physDrv [252:0] -a0 Adapter: 0: EnclId-252 SlotId-0 state changed to Unconfigured-Good. Exit Code: 0x00
# /opt/MegaRaid/LSI/MegaCli -PDList -aALL Adapter #0 Enclosure Device ID: 252 Slot Number: 0 Enclosure position: N/A Device Id: 9 WWN: 5000CCA01600163F Sequence Number: 7 Media Error Count: 0 Other Error Count: 0 Predictive Failure Count: 0 Last Predictive Failure Event Seq Number: 0 PD Type: SAS Raw Size: 279.396 GB [0x22ecb25c Sectors] Non Coerced Size: 278.896 GB [0x22dcb25c Sectors] Coerced Size: 278.464 GB [0x22cee000 Sectors] Sector Size: 0 Firmware state: Unconfigured(good), Spun Up Device Firmware Level: A31A Shield Counter: 0 Successful diagnostics completion on : N/A SAS Address(0): 0x5000cca01600163d SAS Address(1): 0x0 Connected Port Number: 1(path0) Inquiry Data: HITACHI H109030SESUN300GA31A1335C01GXN FDE Capable: Not Capable FDE Enable: Disable Secured: Unsecured Locked: Unlocked Needs EKM Attention: No Foreign State: Foreign Foreign Secure: Drive is not secured by a foreign lock key Device Speed: 6.0Gb/s Link Speed: 6.0Gb/s Media Type: Hard Disk Device Drive: Not Certified Drive Temperature :26C (78.80 F) PI Eligibility: No Drive is formatted for PI information: No PI: No PI Port-0 : Port status: Active Port's Linkspeed: 6.0Gb/s Port-1 : Port status: Active Port's Linkspeed: Unknown Drive has flagged a S.M.A.R.T alert : No Enclosure Device ID: 252 Slot Number: 1 Drive's position: DiskGroup: 0, Span: 0, Arm: 1 Enclosure position: N/A Device Id: 8 WWN: 5000CCA016002EBB Sequence Number: 2 Media Error Count: 0 Other Error Count: 0 Predictive Failure Count: 0 Last Predictive Failure Event Seq Number: 0 PD Type: SAS Raw Size: 279.396 GB [0x22ecb25c Sectors] Non Coerced Size: 278.896 GB [0x22dcb25c Sectors] Coerced Size: 278.464 GB [0x22cee000 Sectors] Sector Size: 0 Firmware state: Online, Spun Up Commissioned Spare : No Emergency Spare : No Device Firmware Level: A31A Shield Counter: 0 Successful diagnostics completion on : N/A SAS Address(0): 0x5000cca016002eb9 SAS Address(1): 0x0 Connected Port Number: 0(path0) Inquiry Data: HITACHI H109030SESUN300GA31A1335C033GN FDE Capable: Not Capable FDE Enable: Disable Secured: Unsecured Locked: Unlocked Needs EKM Attention: No Foreign State: None Device Speed: 6.0Gb/s Link Speed: 6.0Gb/s Media Type: Hard Disk Device Drive: Not Certified Drive Temperature :26C (78.80 F) PI Eligibility: No Drive is formatted for PI information: No PI: No PI Port-0 : Port status: Active Port's Linkspeed: 6.0Gb/s Port-1 : Port status: Active Port's Linkspeed: Unknown Drive has flagged a S.M.A.R.T alert : No Exit Code: 0x00
# /opt/MegaRaid/LSI/MegaCli -PDReplaceMissing -physDrv [252:0] -a0
# /opt/MegaRaid/LSI/MegaCli -PDOnline -physDrv [252:0] -a0 EnclId-252 SlotId-0 state changed to OnLine. Exit Code: 0x00
# /opt/MegaRaid/LSI/MegaCli -PDList -aALL Adapter #0 Enclosure Device ID: 252 Slot Number: 0 Drive's position: DiskGroup: 0, Span: 0, Arm: 0 Enclosure position: N/A Device Id: 9 WWN: 5000CCA01600163F Sequence Number: 9 Media Error Count: 0 Other Error Count: 0 Predictive Failure Count: 0 Last Predictive Failure Event Seq Number: 0 PD Type: SAS Raw Size: 279.396 GB [0x22ecb25c Sectors] Non Coerced Size: 278.896 GB [0x22dcb25c Sectors] Coerced Size: 278.464 GB [0x22cee000 Sectors] Sector Size: 0 Firmware state: Online, Spun Up Commissioned Spare : No Emergency Spare : No Device Firmware Level: A31A Shield Counter: 0 Successful diagnostics completion on : N/A SAS Address(0): 0x5000cca01600163d SAS Address(1): 0x0 Connected Port Number: 1(path0) Inquiry Data: HITACHI H109030SESUN300GA31A1335C01GXN FDE Capable: Not Capable FDE Enable: Disable Secured: Unsecured Locked: Unlocked Needs EKM Attention: No Foreign State: None Device Speed: 6.0Gb/s Link Speed: 6.0Gb/s Media Type: Hard Disk Device Drive: Not Certified Drive Temperature :27C (80.60 F) PI Eligibility: No Drive is formatted for PI information: No PI: No PI Port-0 : Port status: Active Port's Linkspeed: 6.0Gb/s Port-1 : Port status: Active Port's Linkspeed: Unknown Drive has flagged a S.M.A.R.T alert : No Enclosure Device ID: 252 Slot Number: 1 Drive's position: DiskGroup: 0, Span: 0, Arm: 1 Enclosure position: N/A Device Id: 8 WWN: 5000CCA016002EBB Sequence Number: 2 Media Error Count: 0 Other Error Count: 0 Predictive Failure Count: 0 Last Predictive Failure Event Seq Number: 0 PD Type: SAS Raw Size: 279.396 GB [0x22ecb25c Sectors] Non Coerced Size: 278.896 GB [0x22dcb25c Sectors] Coerced Size: 278.464 GB [0x22cee000 Sectors] Sector Size: 0 Firmware state: Online, Spun Up Commissioned Spare : No Emergency Spare : No Device Firmware Level: A31A Shield Counter: 0 Successful diagnostics completion on : N/A SAS Address(0): 0x5000cca016002eb9 SAS Address(1): 0x0 Connected Port Number: 0(path0) Inquiry Data: HITACHI H109030SESUN300GA31A1335C033GN FDE Capable: Not Capable FDE Enable: Disable Secured: Unsecured Locked: Unlocked Needs EKM Attention: No Foreign State: None Device Speed: 6.0Gb/s Link Speed: 6.0Gb/s Media Type: Hard Disk Device Drive: Not Certified Drive Temperature :25C (77.00 F) PI Eligibility: No Drive is formatted for PI information: No PI: No PI Port-0 : Port status: Active Port's Linkspeed: 6.0Gb/s Port-1 : Port status: Active Port's Linkspeed: Unknown Drive has flagged a S.M.A.R.T alert : No
read comments (0)
http://ganlob.com/2013/12/35015/sarinah-never-sleep-wadah-komunitas-di-jakarta/
Sarinah Thamrin 7-dec-2013
sedikit dokumentasi dari kebanyakan yg gagal install SYSBENCH di Solaris khususnya pada architecture SPARC 
dengan menu dasar:
1. make sure solaris studio sudah siap
# export PATH=$PATH:/opt/solarisstudio/bin
2. extract, build & install m4
# cd m4-1.4.17/ # ./configure --prefix=/opt/app checking for a BSD-compatible install... build-aux/install-sh -c checking whether build environment is sane... yes checking for a thread-safe mkdir -p... build-aux/install-sh -c -d .. .. # make # make install
3. update path binary executable
# export PATH=$PATH:/opt/app/bin
4. extract, build & install autoconf
# cd autoconf-2.69/ # ./configure --prefix=/opt/app checking for a BSD-compatible install... build-aux/install-sh -c checking whether build environment is sane... yes checking for a thread-safe mkdir -p... build-aux/install-sh -c -d .. .. # make # make install
5. extract, build & install automake
# cd automake-1.14 # ./configure --prefix=/opt/app checking whether make supports nested variables... yes checking build system type... sparc-sun-solaris2.10 checking host system type... sparc-sun-solaris2.10 checking for a BSD-compatible install... lib/install-sh -c checking whether build environment is sane... yes checking for a thread-safe mkdir -p... lib/install-sh -c -d .. .. # make # make install
6. extract, build & install sysbench
edit file configure.ac
# cd sysbench-0.4.12 # vi configure.ac
edit menjadi AC_PROG_RANLIB
# Checks for programs.
AC_PROG_CC
AC_PROG_LIBTOOL
Menjadi
# Checks for programs.
AC_PROG_CC
AC_PROG_RANLIB
# ./configure --prefix=/opt/sysbench CFLAGS=-m64 checking build system type... sparc-sun-solaris2.10 checking host system type... sparc-sun-solaris2.10 checking target system type... sparc-sun-solaris2.10 checking for a BSD-compatible install... config/install-sh -c checking whether build environment is sane... yes .. .. # make # make install
mari mem-Benchmark OLTP MySQL Enterprise. 
bagaimana hasilnya?? 
[Surabaya] kelayapan bingung Hotel Majapahit(Ex. Hotel Yamato / Hotel Oranje)
http://id.wikipedia.org/wiki/Insiden_Hotel_Yamato
MySQL Cluster @ Solaris 10.
node1 [10.0.5.41]: nDB, Sql, Management
node2 [10.0.5.42]: nDB, Sql
node3 [10.0.5.43]: nDB, Sql
berhubung cuman develop, struktur direcrory config & datadir nyah ditaruh di /apps
# ls /apps
config
ndb_data
mysql_data# cat /apps/config/config.ini [TCP DEFAULT] [NDB_MGMD DEFAULT] Datadir=/apps/ndb_data/ [NDB_MGMD] NodeId=1 Hostname=10.0.5.41 [NDBD DEFAULT] NoOfReplicas=2 Datadir=/apps/ndb_data/ [NDBD] Hostname=10.0.5.41 [NDBD] Hostname=10.0.5.42 [NDBD] Hostname=10.0.5.43 [MYSQLD] [MYSQLD] [MYSQLD]
# cat /apps/config/my.cnf [MYSQLD] ndbcluster ndb-connectstring=10.0.5.41 datadir=/apps/mysql_data socket=/tmp/mysql.sock user=mysql [MYSQLD_SAFE] log-error=/apps/mysqld.log pid-file=/apps/mysqld.pid [MYSQL_CLUSTER] ndb-connectstring=10.0.5.41
Execute @ node1: # /opt/mysql/mysql/bin/ndb_mgmd -f /apps/config/config.ini –configdir=/apps/config/ –initial
# /opt/mysql/mysql/bin/ndb_mgmd -f /apps/config/config.ini --configdir=/apps/config/ MySQL Cluster Management Server mysql-5.5.30 ndb-7.2.12 bash-3.2# ndb_mgm -- NDB Cluster -- Management Client -- ndb_mgm> show Connected to Management Server at: localhost:1186 Cluster Configuration --------------------- [ndbd(NDB)] 3 node(s) id=2 (not connected, accepting connect from 10.0.5.41) id=3 (not connected, accepting connect from 10.0.5.42) id=4 (not connected, accepting connect from 10.0.5.43) [ndb_mgmd(MGM)] 1 node(s) id=1 @10.0.5.41 (mysql-5.5.30 ndb-7.2.12) [mysqld(API)] 3 node(s) id=5 (not connected, accepting connect from any host) id=6 (not connected, accepting connect from any host) id=7 (not connected, accepting connect from any host)
exec @ node1: # /opt/mysql/mysql/bin/ndbmtd –defaults-file=/apps/config/my.cnf
# /opt/mysql/mysql/bin/ndbmtd --defaults-file=/apps/config/my.cnf 2013-07-09 23:58:44 [ndbd] INFO -- Angel connected to '10.0.5.41:1186' 2013-07-09 23:58:44 [ndbd] INFO -- Angel allocated nodeid: 2 # ndb_mgm -e show Connected to Management Server at: localhost:1186 Cluster Configuration --------------------- [ndbd(NDB)] 3 node(s) id=2 @10.0.5.41 (mysql-5.5.30 ndb-7.2.12, starting, Nodegroup: 0) id=3 (not connected, accepting connect from 10.0.5.42) id=4 (not connected, accepting connect from 10.0.5.43) [ndb_mgmd(MGM)] 1 node(s) id=1 @10.0.5.41 (mysql-5.5.30 ndb-7.2.12) [mysqld(API)] 3 node(s) id=5 (not connected, accepting connect from any host) id=6 (not connected, accepting connect from any host) id=7 (not connected, accepting connect from any host)
execute @ node2 & node3: # /opt/mysql/mysql/bin/ndbmtd –defaults-file=/apps/config/my.cnf
# /opt/mysql/mysql/bin/ndbmtd --defaults-file=/apps/config/my.cnf 2013-07-10 00:01:50 [ndbd] INFO -- Angel connected to '10.0.5.41:1186' 2013-07-10 00:01:50 [ndbd] INFO -- Angel allocated nodeid: 3
cek pada cluster management:
2# ndb_mgm -- NDB Cluster -- Management Client -- ndb_mgm> show Connected to Management Server at: localhost:1186 Cluster Configuration --------------------- [ndbd(NDB)] 3 node(s) id=2 @10.0.5.41 (mysql-5.5.30 ndb-7.2.12, Nodegroup: 0, Master) id=3 @10.0.5.42 (mysql-5.5.30 ndb-7.2.12, Nodegroup: 1) id=4 @10.0.5.43 (mysql-5.5.30 ndb-7.2.12, Nodegroup: 2) [ndb_mgmd(MGM)] 1 node(s) id=1 @10.0.5.41 (mysql-5.5.30 ndb-7.2.12) [mysqld(API)] 3 node(s) id=5 (not connected, accepting connect from any host) id=6 (not connected, accepting connect from any host) id=7 (not connected, accepting connect from any host) indb_mgm>
Execute pada semua Node:
# /opt/mysql/mysql/scripts/mysql_install_db --defaults-file=/apps/config/my.cnf \ --user=mysql --datadir=/apps/mysql_data --basedir=/opt/mysql/mysql # /opt/mysql/mysql/bin/mysqld_safe --defaults-extra-file=/apps/config/my.cnf &
# ndb_mgm -e show Connected to Management Server at: localhost:1186 Cluster Configuration --------------------- [ndbd(NDB)] 3 node(s) id=2 @10.0.5.41 (mysql-5.5.30 ndb-7.2.12, Nodegroup: 0, Master) id=3 @10.0.5.42 (mysql-5.5.30 ndb-7.2.12, Nodegroup: 1) id=4 @10.0.5.43 (mysql-5.5.30 ndb-7.2.12, Nodegroup: 2) [ndb_mgmd(MGM)] 1 node(s) id=1 @10.0.5.41 (mysql-5.5.30 ndb-7.2.12) [mysqld(API)] 3 node(s) id=5 @10.0.5.41 (mysql-5.5.30 ndb-7.2.12) id=6 @10.0.5.42 (mysql-5.5.30 ndb-7.2.12) id=7 @10.0.5.43 (mysql-5.5.30 ndb-7.2.12)
# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.5.30-ndb-7.2.12-cluster-commercial-advanced MySQL Cluster Server - Advanced Edition (Commercial) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
tadaaa..
tinggal configure privileges & create database dengan engine ndbcluster
Removing a Node From a Resource Group
how to ngebuang node (monyet3) dari resource group aktif..
# clq show d1 === Quorum Devices === Quorum Device Name: d1 Enabled: yes Votes: 2 Global Name: /dev/did/rdsk/d1s2 Type: shared_disk Access Mode: scsi3 Hosts (enabled): monyet3, monyet1, monyet2 === Cluster Resource Groups === Group Name Node Name Suspended State ---------- --------- --------- ----- MySQL-RG monyet1 No Offline monyet2 No Online monyet3 No Offline # clrg status === Cluster Resources === Resource Name Node Name State Status Message ------------- --------- ----- -------------- MySQL-RS monyet1 Offline Offline monyet2 Online Online - Service is online. monyet3 Offline Offline MySQL-LH monyet1 Offline Offline - LogicalHostname offline. monyet2 Online Online - LogicalHostname online. monyet3 Offline Offline MySQL-HAS monyet1 Offline Offline monyet2 Online Online monyet3 Offline Offline # scrgadm -pv -g MySQL-RG Res Group name: MySQL-RG (MySQL-RG) Res Group RG_description: <NULL> (MySQL-RG) Res Group mode: Failover (MySQL-RG) Res Group management state: Managed (MySQL-RG) Res Group RG_project_name: default (MySQL-RG) Res Group RG_SLM_type: manual (MySQL-RG) Res Group RG_affinities: <NULL> (MySQL-RG) Res Group Auto_start_on_new_cluster: True (MySQL-RG) Res Group Failback: False (MySQL-RG) Res Group Nodelist: monyet1 monyet2 monyet3 (MySQL-RG) Res Group Maximum_primaries: 1 (MySQL-RG) Res Group Desired_primaries: 1 (MySQL-RG) Res Group RG_dependencies: <NULL> (MySQL-RG) Res Group network dependencies: True (MySQL-RG) Res Group Global_resources_used: <All> (MySQL-RG) Res Group Pingpong_interval: 3600 (MySQL-RG) Res Group Pathprefix: <NULL> (MySQL-RG) Res Group system: False (MySQL-RG) Res Group Suspend_automatic_recovery: False # scrgadm -pv -g MySQL-RG | grep -i nodelist (MySQL-RG) Res Group Nodelist: monyet1 monyet2 monyet3 # scrgadm -c -g MySQL-RG -h monyet1,monyet2 # scrgadm -pv -g MySQL-RG | grep -i nodelist (MySQL-RG) Res Group Nodelist: monyet1 monyet2 # scrgadm -pvv -g MySQL-RG | grep -i netiflist (MySQL-RG:MySQL-LH) Res property name: NetIfList (MySQL-RG:MySQL-LH:NetIfList) Res property class: extension (MySQL-RG:MySQL-LH:NetIfList) Res property description: List of IPMP groups on each node (MySQL-RG:MySQL-LH:NetIfList) Res property pernode: False (MySQL-RG:MySQL-LH:NetIfList) Res property type: stringarray (MySQL-RG:MySQL-LH:NetIfList) Res property value: sc_ipmp0@1 sc_ipmp0@2 sc_ipmp0@3 # scrgadm -c -j MySQL-LH -x netiflist=sc_ipmp0@1,sc_ipmp0@2
dari node yang aktif:
# clnode evacuate monyet3shutdown monyet3 dan booting non cluster mode
ok boot -x
bersambung….
build MySQL HA enterprise pada Solaris Cluster kandang-monyet & kandang-buaya…
karena Data Service MySQL belum include pada Solaris Cluster.. jadi registrasi manual..
*** Data Services Menu ***
Please select from one of the following options:
* 1) Apache Web Server
* 2) Oracle
* 3) NFS
* 4) Oracle Real Application Clusters
* 5) PeopleSoft Enterprise Application Server
* 6) Highly Available Storage
* 7) Logical Hostname
* 8) Shared Address
* 9) Per Node Logical Hostname
*10) Weblogic Server
* ?) Help
* q) Return to the Main Menu
Option:register Generic Data Service
# clresourcetype register SUNW.gds SUNW.HAStoragePlus # clresourcetype show === Registered Resource Types === .... .... Resource Type: SUNW.gds:6 RT_description: Generic Data Service for Oracle Solaris Cluster RT_version: 6 API_version: 2 RT_basedir: /opt/SUNWscgds/bin Single_instance: False Proxy: False Init_nodes: All potential masters Installed_nodes: <All> Failover: False Pkglist: <NULL> RT_system: False Global_zone: False Resource Type: SUNW.HAStoragePlus:10 RT_description: HA Storage Plus RT_version: 10 API_version: 2 RT_basedir: /usr/cluster/lib/rgm/rt/hastorageplus Single_instance: False Proxy: False Init_nodes: All potential masters Installed_nodes: <All> Failover: False Pkglist: SUNWscu RT_system: False Global_zone: True .....
Create resource group dan logical hostname untuk Failover
# clresourcegroup create MySQL-RG # clresource create -g MySQL-RG -t SUNW.HAStoragePlus -p AffinityOn=TRUE -p Zpools=zMysql -p ZpoolsSearchDir=/dev/did/dsk MySQL-HAS # clreslogicalhostname create -g MySQL-RG -h buaya MySQL-LH # clresource list -v Resource Name Resource Type Resource Group ------------- ------------- -------------- MySQL-LH SUNW.LogicalHostname:4 MySQL-RG MySQL-HAS SUNW.HAStoragePlus:10 MySQL-RG
Register Manual:
setting parameter sesuai konfigurasi & register…
# cp /opt/SUNWscmys/util/mysql_config /export/home/ozzie/mysql_config # cp /opt/SUNWscmys/util/ha_mysql_config /export/home/ozzie/ha_mysql_config
mysql_config:
MYSQL_BASE=/opt/mysql/mysql MYSQL_USER=root MYSQL_PASSWD=baueek MYSQL_HOST=Buaya FMUSER=fmuser FMPASS=fmuser MYSQL_SOCK=/tmp/mysql.sock MYSQL_NIC_HOSTNAME=Buaya MYSQL_DATADIR=/global/mysql
ha_mysql_config:
RS=MySQL-RS RG=MySQL-RG PORT=3306 LH=buaya SCALABLE= LB_POLICY= RS_PROP= HAS_RS=MySQL-HAS BASEDIR=/opt/mysql/mysql DATADIR=/global/mysql MYSQLUSER=mysql MYSQLHOST=buaya FMUSER=fmuser FMPASS=fmuser LOGDIR=/global/mysql/logs CHECK=yes
register Data Service:
# /opt/SUNWscmys/util/mysql_register -f /export/home/ozzie/mysql_config # /opt/SUNWscmys/util/ha_mysql_register -f /export/home/ozzie/ha_mysql_config # clrs enable MySQL-RS
Taddaaaaa
bash-3.2# clrs status === Cluster Resources === Resource Name Node Name State Status Message ------------- --------- ----- -------------- MySQL-RS buaya2 Online Online - Service is online. buaya1 Offline Offline MySQL-LH buaya2 Online Online - LogicalHostname online. buaya1 Offline Offline MySQL-HAS buaya2 Online Online buaya1 Offline Offline
tinggal switch antar node dah 
# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 84 Server version: 5.6.12-enterprise-commercial-advanced-log MySQL Enterprise Server - Advanced Edition (Commercial) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
Shutdown semua node.
root@Monyet3:~# scshutdown Broadcast Message from root (???) on Monyet3 Mon Jun 24 02:42:38... The cluster kandang-monyet will be shutdown in 1 minute Broadcast Message from root (???) on Monyet3 Mon Jun 24 02:43:08... The cluster kandang-monyet will be shutdown in 30 seconds Do you want to continue? (y or n): y
Berhubung mesin SPARC tinggal tambah option di OKpromt..
SPARC Enterprise T5220, No Keyboard
Copyright (c) 1998, 2012, Oracle and/or its affiliates. All rights reserved.
OpenBoot 4.33.6.b, 4096 MB memory available, Serial #83382360.
Ethernet address 0:14:4f:f8:50:58, Host ID: 84f85058.
{0} ok boot -x
Boot device: /virtual-devices@100/channel-devices@200/disk@0:a File and args: -x
SunOS Release 5.11 Version 11.1 64-bit
Copyright (c) 1983, 2012, Oracle and/or its affiliates. All rights reserved.
\tinggal execute clsetup
*** Main Menu ***
Select from one of the following options:
1) Change Network Addressing and Ranges for the Cluster Transport
2) Show Network Addressing and Ranges for the Cluster Transport
?) Help with menu options
q) Quit
Option: >>> Change Network Addressing and Ranges for the Cluster Transport <<<
Network addressing for the cluster transport is currently configured
as follows:
=== Private Network ===
private_netaddr: 172.16.0.0
private_netmask: 255.255.240.0
max_nodes: 62
max_privatenets: 10
num_zoneclusters: 12
num_xip_zoneclusters: 3
Do you want to change this configuration (yes/no) [yes]?
The default network address for the cluster transport is 172.16.0.0.
Do you want to use the default (yes/no) [yes]? no
What network address do you want to use? 172.16.202.0
The combination of private netmask and network address will dictate
both the maximum number of nodes and private networks that can be
supported by a cluster. Given your private network address, this
program will generate a range of recommended private netmasks based on
the maximum number of nodes and private networks that you anticipate
for this cluster.
In specifying the anticipated number of maximum nodes and private
networks for this cluster, it is important that you give serious
consideration to future growth potential. While both the private
netmask and network address can be changed later, the tools for making
such changes require that all nodes in the cluster be booted into
noncluster mode.
Maximum number of nodes anticipated for future growth [3]?
Maximum number of private networks anticipated for future growth [2]?
Specify a netmask of 255.255.254.0 to meet anticipated future
requirements of 3 cluster nodes and 2 private networks.
To accommodate more growth, specify a netmask of 255.255.254.0 to
support up to 6 cluster nodes and 4 private networks.
What netmask do you want to use [255.255.254.0]?
Is it okay to proceed with the update (yes/no) [yes]?
/usr/cluster/bin/cluster set-netprops -p private_netaddr=172.16.202.0 -p private_netmask=255.255.254.0 -p max_nodes=3 -p max_privatenets=2
Attempting to contact node "Monyet3" ...done
Attempting to contact node "Monyet2" ...done
Command completed successfully.
tinggal reboot dan taadddaaaaa.. 
root@Monyet1:~# clinterconnect show === Transport Cables === Transport Cable: Monyet3:net0,switch1@1 Endpoint1: Monyet3:net0 Endpoint2: switch1@1 State: Enabled Transport Cable: Monyet3:net2,switch2@1 Endpoint1: Monyet3:net2 Endpoint2: switch2@1 State: Enabled Transport Cable: Monyet2:net0,switch1@2 Endpoint1: Monyet2:net0 Endpoint2: switch1@2 State: Enabled Transport Cable: Monyet2:net2,switch2@2 Endpoint1: Monyet2:net2 Endpoint2: switch2@2 State: Enabled Transport Cable: Monyet1:net0,switch1@3 Endpoint1: Monyet1:net0 Endpoint2: switch1@3 State: Enabled Transport Cable: Monyet1:net2,switch2@3 Endpoint1: Monyet1:net2 Endpoint2: switch2@3 State: Enabled === Transport Switches === Transport Switch: switch1 State: Enabled Type: switch Port Names: 1 2 3 Port State(1): Enabled Port State(2): Enabled Port State(3): Enabled Transport Switch: switch2 State: Enabled Type: switch Port Names: 1 2 3 Port State(1): Enabled Port State(2): Enabled Port State(3): Enabled --- Transport Adapters for Monyet3 --- Transport Adapter: net0 State: Enabled Transport Type: dlpi device_name: net device_instance: 0 lazy_free: 1 dlpi_heartbeat_timeout: 10000 dlpi_heartbeat_quantum: 1000 nw_bandwidth: 80 bandwidth: 70 ip_address: 172.16.202.17 netmask: 255.255.255.248 Port Names: 0 Port State(0): Enabled Transport Adapter: net2 State: Enabled Transport Type: dlpi device_name: net device_instance: 2 lazy_free: 1 dlpi_heartbeat_timeout: 10000 dlpi_heartbeat_quantum: 1000 nw_bandwidth: 80 bandwidth: 70 ip_address: 172.16.202.9 netmask: 255.255.255.248 Port Names: 0 Port State(0): Enabled --- Transport Adapters for Monyet2 --- Transport Adapter: net0 State: Enabled Transport Type: dlpi device_name: net device_instance: 0 lazy_free: 1 dlpi_heartbeat_timeout: 10000 dlpi_heartbeat_quantum: 1000 nw_bandwidth: 80 bandwidth: 70 ip_address: 172.16.202.18 netmask: 255.255.255.248 Port Names: 0 Port State(0): Enabled Transport Adapter: net2 State: Enabled Transport Type: dlpi device_name: net device_instance: 2 lazy_free: 1 dlpi_heartbeat_timeout: 10000 dlpi_heartbeat_quantum: 1000 nw_bandwidth: 80 bandwidth: 70 ip_address: 172.16.202.10 netmask: 255.255.255.248 Port Names: 0 Port State(0): Enabled --- Transport Adapters for Monyet1 --- Transport Adapter: net0 State: Enabled Transport Type: dlpi device_name: net device_instance: 0 lazy_free: 1 dlpi_heartbeat_timeout: 10000 dlpi_heartbeat_quantum: 1000 nw_bandwidth: 80 bandwidth: 70 ip_address: 172.16.202.19 netmask: 255.255.255.248 Port Names: 0 Port State(0): Enabled Transport Adapter: net2 State: Enabled Transport Type: dlpi device_name: net device_instance: 2 lazy_free: 1 dlpi_heartbeat_timeout: 10000 dlpi_heartbeat_quantum: 1000 nw_bandwidth: 80 bandwidth: 70 ip_address: 172.16.202.11 netmask: 255.255.255.248 Port Names: 0 Port State(0): Enabled
 |