# 第一台，請與該Server網卡上的ip一致
dabao-ax1000(config)# slb server Web1 192.168.1.11# 開放 http 埠
dabao-ax1000(config-real server)# port 80 tcp# 離開後設定第二台
dabao-ax1000(config-real server-node port)# exit
dabao-ax1000(config-real server)# exit# 第二台，請與該Server網卡上的ip一致
dabao-ax1000(config)# slb server Web2 192.168.1.12# 開放 http 埠
dabao-ax1000(config-real server)# port 80 tcp# 離開
dabao-ax1000(config-real server-node port)# exit
dabao-ax1000(config-real server)# exit# 查看是否正常，正常來說 status 都是 up，如果是down 有可能是你的防火牆沒開這個port
dabao-ax1000# show slb server
dabao-ax1000#show slb server
Total Number of Services configured: 2
Current = Current Connections, Total = Total Connections
Fwd-pkt = Forward packets, Rev-pkt = Reverse packets
Service Current Total Fwd-pkt Rev-pkt Peak-conn State
---------------------------------------------------------------------------------------
Web1:80/tcp 0 97 26958 101801 0 Up
Web1: Total 0 97 26958 101801 0 Up
Web2:80/tcp 0 49 8380 31482 0 Up
Web2: Total 0 49 8380 31482 0 Up
# 確認完 slb server 運作都up後，要將他們做成一個 group 給Load balance 使用
dabao-ax1000(config)# slb service-group Webtcp
dabao-ax1000(config-slbsvc group)# member Web1:80
dabao-ax1000(config-slbsvc group)# member Web2:80
dabao-ax1000(config-slbsvc group)# end# 確認群組運作狀態
dabao-ax1000(config)# show slb service-group
Total Number of Service Groups configured: 1
Current = Current Connections, Total = Total Connections
Fwd-p = Forward packets, Rev-p = Reverse packets
Peak-c = Peak connections
Service Group Name
Service Current Total Fwd-p Rev-p Peak-c
-------------------------------------------------------------------------------*Webtcp State: All Up
Web1:80 0 97 26958 101801 0
Web2:80 0 49 8380 31482 0
# 到這邊就剩下最後一步，建一個虛擬server 也就是架構圖圖中的 load balance的 位置# 211.78.92.5 為這個虛擬server 對外ip 位址
dabao-ax1000(config)# slbvirtual-server VIP-WEB 211.78.92.5# 一樣要指定開放的port，這邊為http
dabao-ax1000(config-slbvserver)# port 80 http# 指定這台虛擬server對應的群組
dabao-ax1000(config-slbvserver-vport)# service-group Webtcp# 離開
dabao-ax1000(config-slbvserver-vport)# end# 查看虛擬server 運作狀態
dabao-ax1000(config-slbvserver-vport)# show slb virtual-server
Total Number of Virtual Services configured: 1
Virtual Server Name IP Current Total Request Response Peak
Service-Group Service connection connection packets packets connection
----------------------------------------------------------------------------------------*VIP-WEB(A) 192.168.1.161 All Up
port 80 http 0 184 35741 133283 0
Webtcp 80/http 0 146 35338 133283 0
Total received conn attempts on this port: 184
login: reset
password: # A10設備上的serial-number
Do you want to reset admin password to default?[y/n]: y
Do you want to reset enable password to default?[y/n]: y
Do you want to erase startup config?[y/n]: y
做完設定後，通常等過一段時間再來查那些語法過慢，這檔案早已茁壯，要查的話相當不容易，這時候 MySQL 早已推出 mysqldumpslow 這個小工具，幫助開發者分析這茁壯到不行的檔案
mysqldumpslow使用说明
mysqldumpslow --help
Usage: mysqldumpslow [ OPTS... ][ LOGS... ]
Parse and summarize the MySQL slow query log. Options are
--verbose verbose
--debug debug
--help write this text to standard output
-v verbose
-d debug
-s ORDER what to sort by (al, at, ar, c, l, r, t), 'at' is default
al: average lock time
ar: average rows sent
at: average query time
c: count （出现次数）
l: lock time
r: rows sent
t: query time-r reverse the sort order (largest last instead of first) （由大到小排序）
-t NUM just show the top n queries （最高的n個查询）
-a don't abstract all numbers to N and strings to 'S'
-n NUM abstract numbers with at least n digits within names
-g PATTERN grep: only consider stmts that include this string
-h HOSTNAME hostname of db server for *-slow.log filename (can be wildcard),
default is '*', i.e. match all
-i NAME name of server instance (if using mysql.server startup script)
-l don't subtract lock time from total time
以下是幾條常用的分析指令
分析出前50條最常使用又很慢的 Query
/usr/local/services/mysql/bin/mysqldumpslow -s c -t 50 VM_166_154-slow.log
