mysql如何安装route-创新互联

这篇文章主要为大家展示了“mysql如何安装route”,内容简而易懂,条理清晰,希望能够帮助大家解决疑惑,下面让小编带领大家一起研究并学习一下“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 &

以上是“mysql如何安装route”这篇文章的所有内容,感谢各位的阅读!相信大家都有了一定的了解,希望分享的内容对大家有所帮助,如果还想学习更多知识,欢迎关注创新互联-成都网站建设公司行业资讯频道!


分享标题:mysql如何安装route-创新互联
分享链接:http://ybzwz.com/article/iegso.html