Shulou(Shulou.com)05/31 Report--

This article mainly shows you "mysql how to install route", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "mysql how to install route" this article.

Mysql route

Download the installation package:

Http://dev.mysql.com/downloads/router/

Documentation:

Http://downloads.mysql.com/docs/mysql-router-en.pdf

Binary installation:

Decompress-set the environment variable 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-the address of this machine

Bind_port = 7001-- the port of this machine

Mode = read-write

Destinations = 10.10.224.217 3306-address and port of 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 &

The above is all the contents of the article "how to install route in mysql". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.