How to enable SQL & Data nodes to use dedicated LAN
Last updated on OCTOBER 25, 2017
Applies to:MySQL Cluster - Version 7.2 and later
Information in this document applies to any platform.
Assume two LAN segments :
1Gb LAN : 10.1.53.0/24 : eth0
10Gb LAN: 10.1.43.0/24 : eth1
This can usually be the case where Physical servers are connected to the network via 1Gb interface and they are interconnected between themselves via 10Gb.
We would like to have a configuration where the following traffic is allowed
Data Node - Data Node Traffic: using LAN 10.1.43.0/24 (10Gb)
Application Server - SQL Node Traffic: using LAN 10.1.53.0/24 (1Gb)
Data Node - SQL Node Traffic: using LAN 10.1.43.0/24 (10Gb)
Traffic handled by SQL Nodes is of two types:
a. Traffic from Data Nodes where actual data retrieval takes place. This can be a lot considering large data can be retrieved and then small subset is sent back to the Application Server.
b. Traffic from Application nodes : This usually is small when compared to the SQL-Data traffic
In many situations is beneficial to segregate traffic between the SQL-Data and SQL-Application server.
This segregation can help in balancing of resource utilization and can also help improve the overall performance.
This isolates the Cluster internal Traffic from any external traffic.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms