加入收藏 | 设为首页 | 会员中心 | 我要投稿 海南站长网 (https://www.0898zz.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 站长学院 > MySql教程 > 正文

mysql如何安装route

发布时间:2022-01-10 16:27:38 所属栏目:MySql教程 来源:互联网
导读:这篇文章主要为大家展示了mysql如何安装route,内容简而易懂,条理清晰,希望能够帮助大家解决疑惑,下面让小编带领大家一起研究并学习一下mysql如何安装route这篇文章吧。 二进制安装: 解压--设置环境变量path即可 cat /etc/sample_mysqlrouter.ini # My
      这篇文章主要为大家展示了“mysql如何安装route”,内容简而易懂,条理清晰,希望能够帮助大家解决疑惑,下面让小编带领大家一起研究并学习一下“mysql如何安装route”这篇文章吧。
 
      二进制安装:
     解压--设置环境变量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”这篇文章的所有内容,感谢各位的阅读!

(编辑:海南站长网)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!