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

In view of how to deploy load balancing in distributed database DDM Sidecar mode, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

Brief introduction

1. Distributed database middleware DDM

Distributed database middleware (Distributed Database Middleware) is a middleware service to solve the problems of database capacity, performance bottleneck and distributed expansion. It provides the capabilities of sub-database and sub-table, read-write separation, flexible expansion and so on. It can deal with the high concurrent access scenarios of massive data, and effectively improve the read-write performance of the database.

2.MySQL Router

Mysql-router is the official lightweight middleware of mysql, which is used to replace MySQL Proxy applications to access MySQL Router like MySQL, and MySQL Router forwards the data to the backend DDM node to achieve Sidecar mode load balancing.

The Sidecar pattern is a way of stripping application functionality from the application itself as a separate process. This mode allows us to add a variety of functions to the application without intrusive, thus eliminating the need to add additional configuration code to the application. It is recommended that MySQL Router and the application are deployed on the same machine to do Sidecar mode load balancing. Compared with the server-side load balancing, Sidecar mode load balancing can shorten the call link, reduce the pressure on the server center node, be decentralized, and use it more reliably and efficiently.

Deploy Mysql-Router services

# decompress the installer file

Tar-xzvf mysql-router-8.0.11-linux-glibc2.12-x86-64bit.tar.gz

# rename the installation folder

Mv mysql-router-8.0.11-linux-glibc2.12-x86-64bit / usr/local/mysqlrouter

# create a directory for log and configuration related files

Cd / usr/local/mysqlrouter

Mkdir logs

Mkdir etc

# create configuration files using template files

Cp / usr/local/mysqlrouter/share/doc/mysqlrouter/sample_mysqlrouter.conf. / etc/mysqlrouter.conf

# start mysql router

/ usr/local/mysqlrouter/bin/mysqlrouter-c / usr/local/mysqlrouter/etc/mysqlrouter.conf &

Detailed explanation of configuration file

First, get the DDM connection string, as shown in the following figure:

The following three configuration methods of mysql-router are described in detail:

01

Used as a central agency festival

There is no restriction on mysql-router binding IP, that is, listening to all ip, which can be accessed by any node, and acts as a database access agent to poll each node of DDM. Where destinations is the DDM connection string obtained above.

Vi / usr/local/mysqlrouter/etc/mysqlrouter.conf

[DEFAULT]

Logging_folder = / usr/local/mysqlrouter/log/

Plugin_folder = / usr/local/mysqlrouter/lib/mysqlrouter/

Config_folder = / usr/local/mysqlrouter/etc/

Runtime_folder = / usr/local/mysqlrouter/run/

[logger]

Level = INFO

# load balancer configuration

[routing:balancing]

# bound IP address

Bind_address=0.0.0.0

# listening port

Bind_port = 7002

# connection timeout (seconds)

Connect_timeout = 3

# maximum number of connections

Max_connections = 100

# backend server address. Default read for polling

Destinations = 192.168.4.235VRV 5066192.168.4.231RV 5066

# routing Policy

Routing_strategy=round-robin

[keepalive]

Interval = 60

Connection example:

[root@xxx] #. / mysql-uddmtest-h228.11.2.2-P7002-p

Enter password:

Mysql >

128.11.2.2 is the IP where Mysql Router is located.

02

Used as a local database agent

Mysql-router binds the local address 127.0.0.1 as the local database access agent, allowing only the current node to access the database. It requires applications that need to access the database to be deployed on the same node as router, which is more secure and reliable.

Vi / usr/local/mysqlrouter/etc/mysqlrouter.conf

[DEFAULT]

Logging_folder = / usr/local/mysqlrouter/log/

Plugin_folder = / usr/local/mysqlrouter/lib/mysqlrouter/

Config_folder = / usr/local/mysqlrouter/etc/

Runtime_folder = / usr/local/mysqlrouter/run/

[logger]

Level = INFO

# load balancer configuration

[routing:balancing]

# bound IP address

Bind_address=127.0.0.1

# listening port

Bind_port = 7002

# connection timeout (seconds)

Connect_timeout = 3

# maximum number of connections

Max_connections = 100

# backend server address. Default read for polling

Destinations = 192.168.4.235VRV 5066192.168.4.231RV 5066

# routing Policy

Routing_strategy=round-robin

[keepalive]

Interval = 60

Connection example:

[root@xxx] #. / mysql-uddmtest-h227.0.0.1-P7002-p

Enter password:

Mysql >

The mysql client is on the same node as the Mysql Router.

03

As a local database agent, use Unix sockets connection (recommended)

Mysql-router does not bind ip and port, but only uses Unix sockets connection, so that data can be forwarded without going through the tcp protocol, and only the operating system socket channel can be used, which is more efficient. It also requires applications that need to access the database to be deployed on the same node as router, but it is safe, reliable and efficient.

Vi etc/mysqlrouter.conf

[DEFAULT]

Logging_folder = / usr/local/mysqlrouter/log/

Plugin_folder = / usr/local/mysqlrouter/lib/mysqlrouter/

Config_folder = / usr/local/mysqlrouter/etc/

Runtime_folder = / usr/local/mysqlrouter/run/

[logger]

Level = INFO

# load balancer configuration

[routing:balancing]

# bound IP port

Socket = / tmp/mysqlrouter.sock

# connection timeout (seconds)

Connect_timeout = 3

# maximum number of connections

Max_connections = 100

# backend server address. Default read for polling

Destinations = 192.168.4.235VRV 5066192.168.4.231RV 5066

# routing Policy

Routing_strategy=round-robin

[keepalive]

Interval = 60

Where destinations is the DDM connection string obtained above

Connection example:

[root@xxx] #. / mysql-uddmtest-p-S / tmp/mysqlrouter.sock

Enter password:

Mysql >

The mysql client is on the same node as the Mysql Router.

This is the answer to the question about how to deploy load balancer in DDM Sidecar mode of distributed database. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

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.