MySQL Forums
Forum List  »  Router & Proxy

Re: Router COnfig
Posted by: Gan MySQL
Date: February 07, 2022 10:30PM

The above method works fine. But it require couple of changes.
Step1: Install router using MYSQL install file ( router is component in install file)
ste2: do not configure using wizard.
step3. create a ini. file with above routing 1 and routing2 method.
Bing_address: it is same as router install machine address
assign a bind_port

You can forward the bind_address and bind_port to application team to use it to connect to mysql.

If multiple subnets are required, then routing2 come into picture. where bind_address and port will be assigned with different subnet.
gave new subnet address to different applicaiton team to connect to mysql.

Here router machine has 2 ip address: 151.132.20.20 & 200.20.200.1

[routing:1]
bind_address = 151.132.20.20
bind_port = 7001
destinations = foo.example.org:3306
routing_strategy = round-robin

[routing:2]
bind_address = 200.20.200.1
bind_port = 7002
destinations = foo.example.org:3306
routing_strategy = first-available

Note: if we use 0.0.0.0,8009 , i think , all the ip address with 8009 port open can connect to mysql.
to avoid this we can configure the router with multiple routings with different
ip_address .

Options: ReplyQuote


Subject
Views
Written By
Posted
292
February 03, 2022 10:51PM
Re: Router COnfig
145
February 07, 2022 10:30PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.