mysql route安装

mysql route

安装包下载：  
http://dev.mysql.com/downloads/router/  
文档：  
http://downloads.mysql.com/docs/mysql-router-en.pdf  
二进制安装：  
解压--设置环境变量path即可  


cat /etc/sample_mysqlrouter.ini  

# MySQL Router sample configuration  
#  
# The following is a sample configuration file which shows  
# most of the plugins available and most of their options.  
#  
# The paths used are defaults and should be adapted based  
# on how MySQL Router was installed, for example, using the  
# CMake option CMAKE_INSTALL_PREFIX  
#  
# The logging_folder is kept empty so message go to the  
# console.  
#  
# The fabric_cache plugin only works with the MySQL-RPC  
# protocol (by default running on port 32275)  
#  

#[DEFAULT]  
#logging_folder =  
#plugin_folder = /usr/local/lib/mysqlrouter  
#config_folder = /etc/mysql  
#runtime_folder = /var/run  

#[logger]  
#level = INFO  

#[fabric_cache]  
#address = your_fabric_node.example.com:32275  
#user =  

[routing:basic_failover]  
# To be more transparent, use MySQL Server port 3306  
bind_address=10.10.157.43 --本机的地址  
bind_port = 7001 --本机的端口  
mode = read-write  
destinations = 10.10.224.217:3306 --db的地址及端口  

#[routing:homepage_reads_fabric]  
#bind_port = 7002  
#destinations = fabric+cache:///group/homepage_group?allow_primary_reads=yes  
#mode = read-only  

# If no plugin is configured which starts a service, keepalive  
# will make sure MySQL Router will not immediately exit. It is  
# safe to remove once Router is configured.  
#[keepalive]  
#interval = 60  

cd /root/mysql-router-2.0.3-linux-glibc2.12-x86-64bit/bin  

mysqlrouter -c /etc/sample_mysqlrouter.ini &
转载请注明源出处 
QQ 273002188 欢迎一起学习 
QQ 群 236941212 
oracle,mysql,PG 相互交流

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25099483/viewspace-2112535/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25099483/viewspace-2112535/