Re: Router COnfig

[Gan MySQL]

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 .