Common Address Redundancy Protocol ( CARP ) 角色說明 主要會有兩種角色, 一種是Host( Primary ), 一種是Provider ( Secondary ) Host 主要就是我們提供服務的機器 Provider 就是當Host 掛掉後, 接手服務的機器 參數說明 ( 這部份看原文吧, 這是我看OpenBSD上找來的, FreeBSD上敘述的比較少, 請大家搭配著一起服用 ) vhid The Virtual Host ID. This is a unique number that is used to identify the redundancy group to other nodes on the network. Acceptable values [...]
這是Jay Pipes 在Google 演講時有關MySQL Tuning 的Tips Direct URL: http://video.google.com/videoplay?docid=2524524540025172110 [02:20] Don’t benchmark without a goal. Have a goal like “improve performance by 20%”. Otherwise you’ll waste a lot of time tuning milliseconds out of your application. [02:50] Change just one thing at a time and re-run the benchmarks. [03:40] Disable the query cache by setting [...]
posted in MySQL by johnpupu
一如往常..在看訂閱的rss 的時後.. 其中這篇 有介紹幾個mysql 的工具.. 其中mytop 已經快樂使用中… 另一個就是 MySQL Active Report 看起來挺不錯的.. 一樣在ports 裡面也有.. #cd /usr/ports/databases/mysqlard/ #make install clean 裝好後的提示似乎不是很完整 1) Add the ‘mysqlar’ user with USAGE privileges to your mysql server: $ mysql -u root -p mysql mysql> GRANT USAGE ON *.* TO mysqlar@localhost; mysql> FLUSH PRIVILEGES; 2) Add the mysqlard crontab to root’s [...]
posted in MySQL by johnpupu