MYSQL router 自動均衡負載

標籤：

配製檔案:

/etc/mysqlrouter/mysqlrouter.ini

[DEFAULT]logging_folder = /var/log/mysql-routerplugin_folder = /usr/local/mysql-router/lib/mysqlrouterruntime_folder = /usr/local/mysql-router[logger]# 定義日誌等級level = INFO[routing:balancing]bind_address = 0.0.0.0bind_port = 7002max_connections = 1024mode = read-onlydestinations = 10.24.220.70:3306, 10.169.214.33:3306                                                                                                                                                      

 

　起動：

./mysqlrouter -c /etc/mysqlrouter/mysqlrouter.ini &

 

 

測試:自動均衡負載

mysql router 安裝在monitor 上,

10.169.216.172是其中一個網卡

[[email protected] bin]# mysql -u root -p -h 10.169.216.172 -P 7002 -e "show variables like ‘server_id‘";Enter password: +---------------+-------+| Variable_name | Value |+---------------+-------+| server_id     | 101   |+---------------+-------+[[email protected] bin]# mysql -u root -p -h 10.169.216.172 -P 7002 -e "show variables like ‘server_id‘";Enter password: +---------------+-------+| Variable_name | Value |+---------------+-------+| server_id     | 102   |+---------------+-------+[[email protected] bin]# mysql -u root -p -h 10.169.216.172 -P 7002 -e "show variables like ‘server_id‘";Enter password: +---------------+-------+| Variable_name | Value |+---------------+-------+| server_id     | 101   |+---------------+-------+[[email protected] bin]# mysql -u root -p -h 10.169.216.172 -P 7002 -e "show variables like ‘server_id‘";Enter password: +---------------+-------+| Variable_name | Value |+---------------+-------+| server_id     | 102   |+---------------+-------+

 

MYSQL router 自動均衡負載