Sun Cluster 3.3 文件寫到，似乎只支援到 MySQL 4.X
我用到 MySQL 5.X 上果然出了些問題
似乎是 MySQL create table 的 key 換了
於是乎 Sun Cluster MySQL Agent 在 create test table 時就出現了此訊息
Feb 17 12:56:27 TPDBDSS2 SC[SUNWscmys.probe_mysql]:BDSS:mysql-rs: [ID 986150 daemon.error] check_mysql - Sql-command USE sc3_test_database; CREATE TABLE sc3_test_table ( Number int(5) NOT NULL, PRIMARY KEY (Number)) TYPE=MyISAM;COMMIT returned error (ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1)
debug 一番，找到 SUNWscmys/function
修改這行
for cmd in 'USE sc3_test_database; CREATE TABLE sc3_test_table ( Number int(5) NOT NULL, PRIMARY KEY (Number)) TYPE=MyISAM;COMMIT' \
把 TYPE 換成 ENGINE
for cmd in 'USE sc3_test_database; CREATE TABLE sc3_test_table ( Number int(5) NOT NULL, PRIMARY KEY (Number)) ENGINE=MyISAM;COMMIT' \
ok, work fine now
--
update: a patch release
Patch-ID# 145646-03
Keywords: oracle ha-mysql patch
Synopsis: Oracle Solaris Cluster 3.3: HA-MySQL Patch for Oracle Solaris 10
Date: Jul/11/2011
Add support for MySQL 5.X
---------------
if (( ${MYSQL_VERSION} >= 5 ))
then
ENGINE="ENGINE=MyISAM"
else
ENGINE="TYPE=MyISAM"
fi
---------------
Solaris 10 Resource Management - project.cpu-cap
Solairs 10 7/08 add project.cpu-cap to limit cpu usages
add a project fraud, and assign user to this project
# projadd -U user1 user.test
change user user1 default project:
add a line to the end of /etc/user_attr
=> user1::::project=user.test
# id -p user1
uid=109(user1) gid=201(users) projid=100(user.test)
==> project.cpu-cap
==> a value of 100 means 100% of one CPU
add a project attribute:
# projmod -aK "project.cpu-cap=(priv,800,deny)" user.test => 50%
(it's a 16 cpu system)
# prctl -n project.cpu-cap -i project user.test
move a process to a project task
# newtask -v -p user.test -c [pid]
.
add a project fraud, and assign user to this project
# projadd -U user1 user.test
change user user1 default project:
add a line to the end of /etc/user_attr
=> user1::::project=user.test
# id -p user1
uid=109(user1) gid=201(users) projid=100(user.test)
==> project.cpu-cap
==> a value of 100 means 100% of one CPU
add a project attribute:
# projmod -aK "project.cpu-cap=(priv,800,deny)" user.test => 50%
(it's a 16 cpu system)
# prctl -n project.cpu-cap -i project user.test
project: 100: user.test
NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT
project.cpu-cap
privileged 800 - deny -
system 4.29G inf deny -
# prstat -J
PROJID NPROC SWAP RSS MEMORY TIME CPU PROJECT
100 18 7040K 8000K 0.0% 1:08:50 49% user.test <=== 50% CPU
3 90 6880M 6910M 21% 168:18:24 8.5% default
1 25 144M 154M 0.5% 12:31:05 0.7% user.root
0 60 197M 203M 0.6% 41:03:22 0.0% system
move a process to a project task
# newtask -v -p user.test -c [pid]
.
[轉載] Recommended mount options for VxFS
http://www.mail-archive.com/veritas-vx@mailman.eng.auburn.edu/msg00289.html
節錄
DSS/HPC
==========================
VxFS mount options:
Log mode= delaylog (best performance and enables data integrity)
Logsize= medium (doesn't need to be very much larger than default or
keep default)
Mincache=direct (turn off in-kernel buffering)
Convosync=direct (delay inode updates for writes to files)
Tunefs:
Read_ahead=1 (traditional vxfs read ahead enabled)
Fcl_winterval=6000 (50 minute update interval for FCL)
VxVM kernel tuning (/etc/system)
Set vxio:vol_maxio=32768 (max IO size = 16MB)
OLTP
=======================
VxFS mount options:
Log mode= delaylog (best performance and enables data integrity)
Logsize= medium (doesn't need to be very much larger than default or
keep default)
Mincache=direct (turn off in-kernel buffering)
Convosync=direct (delay inode updates for writes to files)
Tunefs:
Read_ahead=0 (turn off read ahead)
Fcl_winterval=6000 (50 minute update interval for FCL)
VxVM kernel tuning (/etc/system)
Set vxio:vol_maxio=32768 (max IO size = 16MB)
節錄
DSS/HPC
==========================
VxFS mount options:
Log mode= delaylog (best performance and enables data integrity)
Logsize= medium (doesn't need to be very much larger than default or
keep default)
Mincache=direct (turn off in-kernel buffering)
Convosync=direct (delay inode updates for writes to files)
Tunefs:
Read_ahead=1 (traditional vxfs read ahead enabled)
Fcl_winterval=6000 (50 minute update interval for FCL)
VxVM kernel tuning (/etc/system)
Set vxio:vol_maxio=32768 (max IO size = 16MB)
OLTP
=======================
VxFS mount options:
Log mode= delaylog (best performance and enables data integrity)
Logsize= medium (doesn't need to be very much larger than default or
keep default)
Mincache=direct (turn off in-kernel buffering)
Convosync=direct (delay inode updates for writes to files)
Tunefs:
Read_ahead=0 (turn off read ahead)
Fcl_winterval=6000 (50 minute update interval for FCL)
VxVM kernel tuning (/etc/system)
Set vxio:vol_maxio=32768 (max IO size = 16MB)
[轉載] Basic Performance Tuning settings for the Solaris OS for Datawarehouse Loads
Friday, October 5, 2007
Basic Performance Tuning settings for the Solaris OS for Datawarehouse Loads
Below are some settings I typically change/enable on the Solaris OS for a DW environment. I generally change the default settings for OS, Network , Vxvm/VXFS, Emulex settings and Storage connectivity. All these parameters need to be tested thoroughly in a non-prod environment before being implemented.全文詳...
http://dsstos.blogspot.com/2007/10/basic-settings-for-solaris-os-to-meet.html
.
[預告] Solaris 10 10/08 Coming soon
快出來了～，預計十月底開放下載
Solaris 10 U6 10/08
What's New
ZFS and Solaris 10 10/08 FAQ
五月 release 的 OpenSolaris 正是使用 zfs 為 root filesystem
那時就想，Solaris 10 應該也快了
這是 open 的效應嗎？
我覺得發展的速度好像變快了耶....
.
Solaris 10 U6 10/08
What's New
ZFS and Solaris 10 10/08 FAQ
五月 release 的 OpenSolaris 正是使用 zfs 為 root filesystem
那時就想，Solaris 10 應該也快了
這是 open 的效應嗎？
我覺得發展的速度好像變快了耶....
.
訂閱：
文章 (Atom)