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 .
Subject
Views
Written By
Posted
600
February 03, 2022 10:51PM
Re: Router COnfig
340
February 07, 2022 10:30PM
Sorry, you can't reply to this topic. It has been closed.
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.